protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<SYS_USERDATA>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "����"; Page.Title = title; if (Request["PID"] != null) { pid = Request["PID"]; } if (Request["USER_ID"] != null) { userid = Request["USER_ID"]; paraStr = "?USER_ID="+userid; } if (!IsPostBack) { #region//Ĭ�����Գ�ʼ�� aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//WebCtrls. aspPager.PageSize = 30; #endregion #region//���ݳ�ʼ�� #endregion if (pid == "0") { liToTop.Visible = false; } else { liToTop.Visible = true; } StringBuilder orgids =new StringBuilder(); if (userid != "") { SYS_USERDATA cond=new SYS_USERDATA(); cond.USER_ID=decimal.Parse(userid); cond.DATA_TYPE = HR_ORG.Attribute.ORG_ID.LongName.Replace("[", "").Replace("]", ""); //Response.Write(HR_ORG.Attribute.ORG_ID.LongName.Replace("[","").Replace("]","")); List<SYS_USERDATA> lst = BLLTable<SYS_USERDATA>.Factory(conn).Select(new SYS_USERDATA(), cond); if (lst != null) { for (int i = 0; i < lst.Count; i++) { if (orgids.Length > 0) { orgids.Append(","); } orgids.Append(lst[i].DATA_ID); } } } condObj.P_ORG_ID = pid; if (orgids.Length > 0) { condObj.In(HR_ORG.Attribute.ORG_ID, orgids.ToString()); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); } }
protected void btnSetPageNum_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageNum.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<SYS_USERDATA>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnOK_Click(object sender, EventArgs e) { try { SYS_USERDATA valObj = new SYS_USERDATA(); if (txtUSER_ID.Value != "") { valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value); } if (txtDATA_TYPE.Value != "") { valObj.DATA_TYPE = Convert.ToString(txtDATA_TYPE.Value); } if (txtDATA_ID.Value != "") { valObj.DATA_ID = Convert.ToString(txtDATA_ID.Value); } if (keyid != "") { valObj.USER_ID = Convert.ToInt32(keyid); count = BLLTable <SYS_USERDATA> .Factory(conn).Update(valObj, SYS_USERDATA.Attribute.USER_ID); } else { count = BLLTable <SYS_USERDATA> .Factory(conn).Insert(valObj, SYS_USERDATA.Attribute.USER_ID); keyid = valObj.USER_ID.ToString(); } if (count > 0) { StringBuilder sbData = new StringBuilder("({valObj:''"); List <AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valObj.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } sbData.Append("})"); ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true); } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnOK_Click(object sender, EventArgs e) { try { SYS_USERDATA valObj = new SYS_USERDATA(); if(txtUSER_ID.Value !="" ) valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value); if(txtDATA_TYPE.Value !="" ) valObj.DATA_TYPE = Convert.ToString(txtDATA_TYPE.Value); if(txtDATA_ID.Value !="" ) valObj.DATA_ID = Convert.ToString(txtDATA_ID.Value); if (keyid != "") { valObj.USER_ID = Convert.ToInt32(keyid); count = BLLTable<SYS_USERDATA>.Factory(conn).Update(valObj, SYS_USERDATA.Attribute.USER_ID); } else { count = BLLTable<SYS_USERDATA>.Factory(conn).Insert(valObj, SYS_USERDATA.Attribute.USER_ID); keyid = valObj.USER_ID.ToString(); } if (count > 0) { StringBuilder sbData = new StringBuilder("({valObj:''"); List<AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valObj.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } sbData.Append("})"); ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true); } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = "部门权限范围配置"; if (Request["USER_ID"] != null) { userid = Request["USER_ID"]; } if (Request["ROLE_ID"] != null) { roleid = Request["ROLE_ID"]; } if (!IsPostBack) { tvDept.ShowCheckBoxes = TreeNodeTypes.All; DeptHelper.InitDeptDPTree(tvDept.Nodes, "0", userid, roleid); if (userid != "") { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = decimal.Parse(userid); val.DATA_TYPE = date_type; List <SYS_USERDATA> lst = BLLTable <SYS_USERDATA> .Factory(conn).Select(new SYS_USERDATA(), val); if (lst.Count == 1 && lst[0].DATA_ID == "0") { ckAll.Checked = true; } } if (roleid != "") { SYS_ROLEDATA val = new SYS_ROLEDATA(); val.ROLE_ID = decimal.Parse(roleid); val.DATA_TYPE = date_type; List <SYS_ROLEDATA> lst = BLLTable <SYS_ROLEDATA> .Factory(conn).Select(new SYS_ROLEDATA(), val); if (lst.Count == 1 && lst[0].DATA_ID == "0") { ckAll.Checked = true; } } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new SYS_USERDATA(); if(txtUSER_ID.Value !="" ) condObj.Like(SYS_USERDATA.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value)); if(txtDATA_TYPE.Value !="" ) condObj.Like(SYS_USERDATA.Attribute.DATA_TYPE, Convert.ToString(txtDATA_TYPE.Value)); if(txtDATA_ID.Value !="" ) condObj.Like(SYS_USERDATA.Attribute.DATA_ID, Convert.ToString(txtDATA_ID.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["USER_ID"])) { keyid = Request["USER_ID"]; } if (!IsPostBack) { this.txtUSER_ID.Attributes["readonly"] = "readonly"; this.txtUSER_ID.Attributes["disabled"] = "disabled"; this.txtUSER_ID.Style["background-color"] = "Silver"; try { if (keyid != "") { valObj = BLLTable <SYS_USERDATA> .Factory(conn).GetRowData(SYS_USERDATA.Attribute.USER_ID, Request["USER_ID"]); if (valObj == null) { return; } txtUSER_ID.Value = Convert.ToString(valObj.USER_ID); //Convert.ToDecimal txtDATA_TYPE.Value = Convert.ToString(valObj.DATA_TYPE); //Convert.ToString txtDATA_ID.Value = Convert.ToString(valObj.DATA_ID); //Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = "����Ȩ��Χ����"; if (Request["USER_ID"] != null) { userid = Request["USER_ID"]; } if (Request["ROLE_ID"] != null) { roleid = Request["ROLE_ID"]; } if (!IsPostBack) { tvDept.ShowCheckBoxes = TreeNodeTypes.All; DeptHelper.InitDeptDPTree(tvDept.Nodes, "0", userid, roleid); if (userid != "") { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = decimal.Parse(userid); val.DATA_TYPE = date_type; List<SYS_USERDATA> lst = BLLTable<SYS_USERDATA>.Factory(conn).Select(new SYS_USERDATA(), val); if (lst.Count == 1 && lst[0].DATA_ID == "0") { ckAll.Checked = true; } } if (roleid != "") { SYS_ROLEDATA val = new SYS_ROLEDATA(); val.ROLE_ID = decimal.Parse(roleid); val.DATA_TYPE = date_type; List<SYS_ROLEDATA> lst = BLLTable<SYS_ROLEDATA>.Factory(conn).Select(new SYS_ROLEDATA(), val); if (lst.Count == 1 && lst[0].DATA_ID == "0") { ckAll.Checked = true; } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (ckAll.Checked == true) { if (userid != "") { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = decimal.Parse(userid); val.DATA_TYPE = date_type; BLLTable<SYS_USERDATA>.Factory(conn).Delete(val); val.DATA_ID = "0"; BLLTable<SYS_USERDATA>.Factory(conn).Insert(val); } else if (roleid != "") { SYS_ROLEDATA val = new SYS_ROLEDATA(); val.ROLE_ID = decimal.Parse(roleid); val.DATA_TYPE = date_type; BLLTable<SYS_ROLEDATA>.Factory(conn).Delete(val); val.DATA_ID = "0"; BLLTable<SYS_ROLEDATA>.Factory(conn).Insert(val); } } else { int num = 0; if (userid != "") { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = decimal.Parse(userid); val.DATA_TYPE = date_type; BLLTable<SYS_USERDATA>.Factory(conn).Delete(val); foreach (TreeNode tn in tvDept.CheckedNodes) { val.DATA_ID = tn.Value; num+=BLLTable<SYS_USERDATA>.Factory(conn).Insert(val); } } else if (roleid != "") { SYS_ROLEDATA val = new SYS_ROLEDATA(); val.ROLE_ID = decimal.Parse(roleid); val.DATA_TYPE = date_type; BLLTable<SYS_ROLEDATA>.Factory(conn).Delete(val); foreach (TreeNode tn in tvDept.CheckedNodes) { val.DATA_ID = tn.Value; num+=BLLTable<SYS_ROLEDATA>.Factory(conn).Insert(val); } } if (num > 0) { litWarn.Text = "����ɹ�"; } else { litWarn.Text = "����ʧ��"; } } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "管理"; Page.Title = title; if (Request["PID"] != null) { pid = Request["PID"]; } if (Request["USER_ID"] != null) { userid = Request["USER_ID"]; paraStr = "USER_ID=" + userid; } if (!IsPostBack) { #region //默认属性初始化 aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //WebCtrls. aspPager.PageSize = 30; #endregion #region//数据初始化 #endregion if (pid == "0" || pid == "") { liToTop.Visible = false; SYS_USERDATA cond = new SYS_USERDATA(); cond.USER_ID = decimal.Parse(userid); cond.DATA_TYPE = date_type; SYS_USERDATA valTop = new SYS_USERDATA(); valTop.OrderBy(SYS_USERDATA.Attribute.DATA_ID, Order.Asc); SYS_USERDATA tempObj = BLLTable <SYS_USERDATA> .Factory(conn).GetRowData(valTop, cond); //Response.Write(dataid); if (tempObj != null) { pid = BLLTable <HR_DEPT> .Factory(conn).GetOneValue(HR_DEPT.Attribute.DEPT_ID, tempObj.DATA_ID, HR_DEPT.Attribute.P_DEPT_ID); } } else { liToTop.Visible = true; } StringBuilder orgids = new StringBuilder(); if (userid != "") { SYS_USERDATA cond = new SYS_USERDATA(); cond.USER_ID = decimal.Parse(userid); cond.DATA_TYPE = date_type; List <SYS_USERDATA> lst = BLLTable <SYS_USERDATA> .Factory(conn).Select(new SYS_USERDATA(), cond); if (lst != null) { for (int i = 0; i < lst.Count; i++) { if (orgids.Length > 0) { orgids.Append(","); } orgids.Append(lst[i].DATA_ID); } } } if (orgids.Length > 0) { if (pid != "") { condObj.P_DEPT_ID = pid; } condObj.In(HR_DEPT.Attribute.DEPT_ID, orgids.ToString()); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); } } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "管理"; Page.Title = title; if (Request["PID"] != null) { pid = Request["PID"]; } if (Request["USER_ID"] != null) { userid = Request["USER_ID"]; paraStr = "?USER_ID=" + userid; } if (!IsPostBack) { #region //默认属性初始化 aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //WebCtrls. aspPager.PageSize = 30; #endregion #region//数据初始化 #endregion if (pid == "0") { liToTop.Visible = false; } else { liToTop.Visible = true; } StringBuilder orgids = new StringBuilder(); if (userid != "") { SYS_USERDATA cond = new SYS_USERDATA(); cond.USER_ID = decimal.Parse(userid); cond.DATA_TYPE = HR_ORG.Attribute.ORG_ID.LongName.Replace("[", "").Replace("]", ""); //Response.Write(HR_ORG.Attribute.ORG_ID.LongName.Replace("[","").Replace("]","")); List <SYS_USERDATA> lst = BLLTable <SYS_USERDATA> .Factory(conn).Select(new SYS_USERDATA(), cond); if (lst != null) { for (int i = 0; i < lst.Count; i++) { if (orgids.Length > 0) { orgids.Append(","); } orgids.Append(lst[i].DATA_ID); } } } condObj.P_ORG_ID = pid; if (orgids.Length > 0) { condObj.In(HR_ORG.Attribute.ORG_ID, orgids.ToString()); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["USER_ID"])) { keyid = Request["USER_ID"]; } if (!IsPostBack) { this.txtUSER_ID.Attributes["readonly"] = "readonly"; this.txtUSER_ID.Attributes["disabled"] = "disabled"; this.txtUSER_ID.Style["background-color"] = "Silver"; try { if (keyid != "") { valObj = BLLTable<SYS_USERDATA>.Factory(conn).GetRowData(SYS_USERDATA.Attribute.USER_ID, Request["USER_ID"]); if(valObj==null) return ; txtUSER_ID.Value = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtDATA_TYPE.Value = Convert.ToString(valObj.DATA_TYPE);//Convert.ToString txtDATA_ID.Value = Convert.ToString(valObj.DATA_ID);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "����"; Page.Title = title; if (Request["PID"] != null) { pid = Request["PID"]; } if (Request["USER_ID"] != null) { userid = Request["USER_ID"]; paraStr = "USER_ID="+userid; } if (!IsPostBack) { #region//Ĭ�����Գ�ʼ�� aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//WebCtrls. aspPager.PageSize = 30; #endregion #region//���ݳ�ʼ�� #endregion if (pid == "0" || pid == "") { liToTop.Visible = false; SYS_USERDATA cond = new SYS_USERDATA(); cond.USER_ID = decimal.Parse(userid); cond.DATA_TYPE = date_type; SYS_USERDATA valTop = new SYS_USERDATA(); valTop.OrderBy(SYS_USERDATA.Attribute.DATA_ID, Order.Asc); SYS_USERDATA tempObj= BLLTable<SYS_USERDATA>.Factory(conn).GetRowData(valTop, cond); //Response.Write(dataid); if (tempObj!=null) { pid = BLLTable<HR_DEPT>.Factory(conn).GetOneValue(HR_DEPT.Attribute.DEPT_ID, tempObj.DATA_ID, HR_DEPT.Attribute.P_DEPT_ID); } } else { liToTop.Visible = true; } StringBuilder orgids =new StringBuilder(); if (userid != "") { SYS_USERDATA cond=new SYS_USERDATA(); cond.USER_ID=decimal.Parse(userid); cond.DATA_TYPE = date_type; List<SYS_USERDATA> lst = BLLTable<SYS_USERDATA>.Factory(conn).Select(new SYS_USERDATA(), cond); if (lst != null) { for (int i = 0; i < lst.Count; i++) { if (orgids.Length > 0) { orgids.Append(","); } orgids.Append(lst[i].DATA_ID); } } } if (orgids.Length > 0) { if (pid != "") { condObj.P_DEPT_ID = pid; } condObj.In(HR_DEPT.Attribute.DEPT_ID, orgids.ToString()); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); } } }
private void BindList(SYS_USERDATA condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(SYS_USERDATA.Attribute.USER_ID, Order.Desc); listObj = BLLTable<SYS_USERDATA>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void btnSave_Click(object sender, EventArgs e) { if (ckAll.Checked == true) { if (userid != "") { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = decimal.Parse(userid); val.DATA_TYPE = date_type; BLLTable <SYS_USERDATA> .Factory(conn).Delete(val); val.DATA_ID = "0"; BLLTable <SYS_USERDATA> .Factory(conn).Insert(val); } else if (roleid != "") { SYS_ROLEDATA val = new SYS_ROLEDATA(); val.ROLE_ID = decimal.Parse(roleid); val.DATA_TYPE = date_type; BLLTable <SYS_ROLEDATA> .Factory(conn).Delete(val); val.DATA_ID = "0"; BLLTable <SYS_ROLEDATA> .Factory(conn).Insert(val); } } else { int num = 0; if (userid != "") { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = decimal.Parse(userid); val.DATA_TYPE = date_type; BLLTable <SYS_USERDATA> .Factory(conn).Delete(val); foreach (TreeNode tn in tvDept.CheckedNodes) { val.DATA_ID = tn.Value; num += BLLTable <SYS_USERDATA> .Factory(conn).Insert(val); } } else if (roleid != "") { SYS_ROLEDATA val = new SYS_ROLEDATA(); val.ROLE_ID = decimal.Parse(roleid); val.DATA_TYPE = date_type; BLLTable <SYS_ROLEDATA> .Factory(conn).Delete(val); foreach (TreeNode tn in tvDept.CheckedNodes) { val.DATA_ID = tn.Value; num += BLLTable <SYS_ROLEDATA> .Factory(conn).Insert(val); } } if (num > 0) { litWarn.Text = "保存成功"; } else { litWarn.Text = "保存失败"; } } }
protected void Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["USER_ID"] != null && Request["delFromUserRole"] != null) { SYS_USERDATA delCond = new SYS_USERDATA(); delCond.USER_ID =decimal.Parse( Request["USER_ID"]); delCond.DATA_TYPE = Request["Data_Type"]; delCond.In(SYS_USERDATA.Attribute.DATA_ID, Request["delFromUserRole"]); BLLTable<SYS_USERDATA>.Factory(conn).Delete(delCond); Response.Write("{}"); } if (Request["USER_ID"] != null && Request["AddToUserData"] != null) { SYS_USERDATA valObj = new SYS_USERDATA(); valObj.USER_ID = decimal.Parse(Request["USER_ID"]); string datatype = Request["Data_Type"]; valObj.DATA_TYPE = datatype; string[] arrDataID = null; string dataid = Request["AddToUserData"]; if (dataid.IndexOf(",") == -1) { arrDataID = new string[] { dataid }; } else { arrDataID = dataid.Split(','); } if (valObj.DATA_ID != "0") { SYS_USERDATA delCond = new SYS_USERDATA(); delCond.USER_ID = valObj.USER_ID; delCond.DATA_TYPE = datatype; BLLTable<SYS_USERDATA>.Factory(conn).Delete(delCond); } StringBuilder sbData = new StringBuilder("["); for (int a = 0; a < arrDataID.Length; a++) { valObj.DATA_ID = arrDataID[a]; if (!BLLTable<SYS_USERDATA>.Exists(valObj)) { int re = BLLTable<SYS_USERDATA>.Factory(conn).Insert(valObj); if (re > 0) { if (sbData.Length > 1) { sbData.Append(","); } sbData.Append("{valObj:''"); if (datatype.IndexOf("HR_ORG") != -1) { #region// HR_ORG valORG = BLLTable<HR_ORG>.Factory(conn).GetRowData(HR_ORG.Attribute.ORG_ID, valObj.DATA_ID); List<AttributeItem> lstCol = valORG.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valORG.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } #endregion } else if (datatype.IndexOf("HR_DEPT") != -1) { #region// HR_DEPT valORG = BLLTable<HR_DEPT>.Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, valObj.DATA_ID); List<AttributeItem> lstCol = valORG.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valORG.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } #endregion } else if (datatype.IndexOf("IM_STORAGE") != -1) { #region// IM_STORAGE valORG = BLLTable<IM_STORAGE>.Factory(conn).GetRowData(IM_STORAGE.Attribute.STOR_ID, valObj.DATA_ID); List<AttributeItem> lstCol = valORG.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valORG.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } #endregion } sbData.Append("}"); } } } sbData.Append("]"); Response.Write(sbData.ToString()); } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { if (Request["USER_ID"] != null) { SYS_USERDATA cond = new SYS_USERDATA(); cond.In(SYS_USERDATA.Attribute.DATA_ID, Request["DelKeyIDS"]); cond.DATA_TYPE = Request["Data_Type"]; cond.USER_ID = decimal.Parse(Request["USER_ID"]); int re = BLLTable<SYS_USERDATA>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } else { SYS_USERDATA cond = new SYS_USERDATA(); cond.In(SYS_USERDATA.Attribute.USER_ID, Request["DelKeyIDS"]); int re = BLLTable<SYS_USERDATA>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = int.Parse(Request["FieldKeyID"]); List<AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]); } } BLLTable<SYS_USERDATA>.Factory(conn).Update(val, SYS_USERDATA.Attribute.USER_ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["USER_ID"] != null && Request["delFromUserRole"] != null) { SYS_USERDATA delCond = new SYS_USERDATA(); delCond.USER_ID = decimal.Parse(Request["USER_ID"]); delCond.DATA_TYPE = Request["Data_Type"]; delCond.In(SYS_USERDATA.Attribute.DATA_ID, Request["delFromUserRole"]); BLLTable <SYS_USERDATA> .Factory(conn).Delete(delCond); Response.Write("{}"); } if (Request["USER_ID"] != null && Request["AddToUserData"] != null) { SYS_USERDATA valObj = new SYS_USERDATA(); valObj.USER_ID = decimal.Parse(Request["USER_ID"]); string datatype = Request["Data_Type"]; valObj.DATA_TYPE = datatype; string[] arrDataID = null; string dataid = Request["AddToUserData"]; if (dataid.IndexOf(",") == -1) { arrDataID = new string[] { dataid }; } else { arrDataID = dataid.Split(','); } if (valObj.DATA_ID != "0") { SYS_USERDATA delCond = new SYS_USERDATA(); delCond.USER_ID = valObj.USER_ID; delCond.DATA_TYPE = datatype; BLLTable <SYS_USERDATA> .Factory(conn).Delete(delCond); } StringBuilder sbData = new StringBuilder("["); for (int a = 0; a < arrDataID.Length; a++) { valObj.DATA_ID = arrDataID[a]; if (!BLLTable <SYS_USERDATA> .Exists(valObj)) { int re = BLLTable <SYS_USERDATA> .Factory(conn).Insert(valObj); if (re > 0) { if (sbData.Length > 1) { sbData.Append(","); } sbData.Append("{valObj:''"); if (datatype.IndexOf("HR_ORG") != -1) { #region// HR_ORG valORG = BLLTable <HR_ORG> .Factory(conn).GetRowData(HR_ORG.Attribute.ORG_ID, valObj.DATA_ID); List <AttributeItem> lstCol = valORG.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valORG.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } #endregion } else if (datatype.IndexOf("HR_DEPT") != -1) { #region// HR_DEPT valORG = BLLTable <HR_DEPT> .Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, valObj.DATA_ID); List <AttributeItem> lstCol = valORG.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valORG.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } #endregion } else if (datatype.IndexOf("IM_STORAGE") != -1) { #region// IM_STORAGE valORG = BLLTable <IM_STORAGE> .Factory(conn).GetRowData(IM_STORAGE.Attribute.STOR_ID, valObj.DATA_ID); List <AttributeItem> lstCol = valORG.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valORG.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } #endregion } sbData.Append("}"); } } } sbData.Append("]"); Response.Write(sbData.ToString()); } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { if (Request["USER_ID"] != null) { SYS_USERDATA cond = new SYS_USERDATA(); cond.In(SYS_USERDATA.Attribute.DATA_ID, Request["DelKeyIDS"]); cond.DATA_TYPE = Request["Data_Type"]; cond.USER_ID = decimal.Parse(Request["USER_ID"]); int re = BLLTable <SYS_USERDATA> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } else { SYS_USERDATA cond = new SYS_USERDATA(); cond.In(SYS_USERDATA.Attribute.USER_ID, Request["DelKeyIDS"]); int re = BLLTable <SYS_USERDATA> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { SYS_USERDATA val = new SYS_USERDATA(); val.USER_ID = int.Parse(Request["FieldKeyID"]); List <AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]); } } BLLTable <SYS_USERDATA> .Factory(conn).Update(val, SYS_USERDATA.Attribute.USER_ID); Response.Write("修改用户信息成功"); } Response.End(); }