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();
}
