protected void Button1_Click(object sender, EventArgs e)
{
Model.H_Clerk clerk = new Model.H_Clerk();
string strSql = "update H_User set isoccupy=1 where id=" + userid + "";
int count = DbHelperSQL.ExecuteSql(strSql);
clerk.username = username;
clerk.name = this.TextName.Value.Trim();
clerk.phone = this.TextPhone.Value.Trim();
clerk.telphone = this.TextTel.Value.Trim();
clerk.TeamViewerID = this.TextTeamViewerID.Value.Trim();
clerk.zhifubao = this.TextZhifubao.Value.Trim();
clerk.bank_name = this.TextBank_name.Value.Trim();
clerk.bank_region = this.TextBank.Value.Trim();
clerk.bank_number = this.TextBank_number.Value.Trim();
clerk.region_province = this.HiddenProvince.Value.ToString();
clerk.region_city = this.HiddenCity.Value.ToString();
clerk.region_county = this.HiddenArea.Value.ToString();
if (H_ClerkClass.Add(clerk) && count > 0)
{
JScript.Alert("操作成功！", "a2", this);
}
else
{
JScript.Alert("操作失败！", "a2", this);
}
}
private void InitData()
{
HttpCookie cookie = Request.Cookies["qx"];
if (cookie != null)
{
qx = cookie.Values["qxid"].ToString();
}
if (qx == "4")
{
Response.Redirect("Error.aspx");
}
if (qx == "3")
{
string username = HttpUtility.UrlDecode(Request.Cookies["qx"].Values["user"].ToString(), Encoding.UTF8);
strWhere = "username='******'";
}
int PageIndex = 1;
if (Request.QueryString["page"] != null)
{
int.TryParse(Request.QueryString["page"].ToString(), out PageIndex);
}
int PageSize = 10;
int TotalCount = 0;
;
DataTable dt = H_ClerkClass.GetList(PageSize, PageIndex, strWhere, out TotalCount);
this.Repeater1.DataSource = dt;
this.Repeater1.DataBind();
this.LiteralPage.Text = PageClass.BuildPage(PageIndex, TotalCount, PageSize);
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.H_Clerk clerk = new Model.H_Clerk();
clerk.id = int.Parse(Request.QueryString["pid"]);
clerk.name = this.TextName.Value.Trim();
clerk.username = H_ClerkClass.GetModel(Request.QueryString["pid"].ToString()).username;
clerk.phone = this.TextPhone.Value.Trim();
clerk.TeamViewerID = this.TextTeamViewerID.Value.Trim();
clerk.telphone = this.TextTel.Value.Trim();
clerk.zhifubao = this.TextZhifubao.Value.Trim();
clerk.bank_region = this.TextBank.Value.Trim();
clerk.bank_name = this.TextBank_name.Value.Trim();
clerk.bank_number = this.TextBank_number.Value.Trim();
clerk.region_province = this.HiddenProvince.Value.ToString();
clerk.region_city = this.HiddenCity.Value.ToString();
clerk.region_county = this.HiddenArea.Value.ToString();
if (H_ClerkClass.Update(clerk))
{
JScript.AlertAndRedirect("操作成功！", "ClerkList.aspx", this);
}
else
{
JScript.Alert("操作失败！", "a2", this);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Form["pid"] != null)
{
string pid = Request.Form["pid"].ToString();
string getSql = "select * from H_OrderView where clerk_name=(select username from H_Clerk where id=" + pid + ")";
int count = DbHelperSQL.Query(getSql).Tables[0].Rows.Count;
if (count > 0)
{
Response.Write(Tool.CreateJson("该工作人员下有相关业务，不能被删除掉", "2"));
}
else
{
if (H_ClerkClass.Delete(pid))
{
Response.Write(Tool.CreateJson("操作成功", "1"));
}
else
{
Response.Write(Tool.CreateJson("操作失败", "2"));
}
}
}
else
{
Response.Write(Tool.CreateJson("缺少参数", "3"));
}
Response.End();
}
private void initData()
{
if (Request.QueryString["pid"] != null)
{
string id = Request.QueryString["pid"].ToString();
Model.H_Clerk clerk = H_ClerkClass.GetModel(id);
this.TextName.Value = clerk.name;
this.TextPhone.Value = clerk.phone;
this.TextTel.Value = clerk.telphone;
this.TextTeamViewerID.Value = clerk.TeamViewerID;
this.TextZhifubao.Value = clerk.zhifubao;
this.TextBank.Value = clerk.bank_region;
this.TextBank_name.Value = clerk.bank_name;
this.TextBank_number.Value = clerk.bank_number;
}
}
