62,074
社区成员
发帖
与我相关
我的任务
分享
protected void btnSave_Click(object sender, EventArgs e)
{
SqlParameter[] parms ={
new SqlParameter("@xingming", txtxingming.Text.Trim()), //客户姓名
new SqlParameter("@tel", txttel.Text.Trim()), //电话
new SqlParameter("@address", txtaddress.Text.Trim()), //地址
new SqlParameter()
};
if (txtIDEdit.Value == string.Empty)
{
SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnection, CommandType.StoredProcedure, "yongfa365_ZhuaiZhiInsert", parms);
JS.AlertTo("添加成功", "/ZhuaiZhi/ZhuaiZhi.aspx");
}
else
{
parms[parms.Length - 1] = new SqlParameter("@Id", txtIDEdit.Value.Trim());
SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnection, CommandType.StoredProcedure, "yongfa365_ZhuaiZhiUpdate", parms);
Response.Redirect(Request["txtFromUrl"]);
}
}
protected void btnSave2_Click(object sender, EventArgs e)
{
using (SqlConnection ConnNow = new SqlConnection(SqlHelper.SqlConnection))
{
SqlParameter[] parms ={
new SqlParameter("@xingming", txtxingming.Text.Trim()), //客户姓名
new SqlParameter("@tel", txttel.Text.Trim()), //电话
new SqlParameter("@address", txtaddress.Text.Trim()), //地址
new SqlParameter()
};
if (txtIDEdit.Value == string.Empty)
{
SqlHelper.ExecuteNonQuery(ConnNow, CommandType.StoredProcedure, "yongfa365_ZhuaiZhiInsert", parms);
JS.AlertTo("添加成功", "/ZhuaiZhi/ZhuaiZhi.aspx");
}
else
{
parms[parms.Length - 1] = new SqlParameter("@Id", txtIDEdit.Value.Trim());
SqlHelper.ExecuteNonQuery(ConnNow, CommandType.StoredProcedure, "yongfa365_ZhuaiZhiUpdate", parms);
Response.Redirect(Request["txtFromUrl"]);
}
}
}