protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_STATION>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_STATION>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
int delStattion(decimal delid) { HR_STATION old = BLLTable <HR_STATION> .Factory(conn).GetRowData(HR_STATION.Attribute.STATION_ID, delid); int re = BLLTable <HR_STATION> .Factory(conn).Delete(HR_STATION.Attribute.STATION_ID, delid); if (re > 0 && old.PID > 0) { HR_STATION pCond = new HR_STATION(); pCond.STATION_ID = old.PID; BLLTable <HR_STATION> .UpdateAuto(pCond, HR_STATION.Attribute.SUB_NUM, -1); } return(re); }
private void BindList(HR_STAFF condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc); } if (deptid != "") { condObj.DEPT_ID = deptid; //Response.Write(deptid); } //condObj.PID = decimal.Parse(pid); valObj.LoadAllAttributes(false); showTableColumnList.Add(HR_STAFF.Attribute.PATH); showTableColumnList.Add(HR_STAFF.Attribute.PNAME); showTableColumnList.Add(HR_STAFF.Attribute.GENDER); valObj.Add(showTableColumnList.ToArray()); listObj = BLLTable <HR_STAFF> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; //部门领导 HR_DEPT_MANAGER valObj2 = new HR_DEPT_MANAGER(); HR_DEPT_MANAGER condObj2 = new HR_DEPT_MANAGER(); condObj2.DEPT_ID = deptid; List <HR_DEPT_MANAGER> listObj2 = BLLTable <HR_DEPT_MANAGER> .Factory(conn).Select(valObj2, condObj2); repList_DEPT_MANAGER.DataSource = listObj2; repList_DEPT_MANAGER.DataBind(); //岗位信息 HR_STATION valObj3 = new HR_STATION(); HR_STATION condObj3 = new HR_STATION(); condObj3.DEPT_ID = deptid; List <HR_STATION> listObj3 = BLLTable <HR_STATION> .Factory(conn).Select(valObj3, condObj3); repList_HR_STATION.DataSource = listObj3; repList_HR_STATION.DataBind(); }
private void BindList(HR_STATION condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(HR_STATION.Attribute.STATION_ID, Order.Asc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); if (org != "") { condObj.DEPT_ID = "0"; condObj.ORG_ID = org; } if (dept != "") { condObj.DEPT_ID = dept; } Relation r1 = new Relation(HR_STATION.Attribute.LEVEL_ID, HR_STATION_LEVEL.Attribute.LEVEL_ID); Relation r2 = new Relation(HR_STATION.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_ID); List <Relation> lstRelatio = new List <Relation>(); lstRelatio.Add(r1); lstRelatio.Add(r2); HR_STATION_TYPE valType = new HR_STATION_TYPE(); valType.TYPE_NAME = ""; HR_STATION_LEVEL valLevel = new HR_STATION_LEVEL(); valLevel.LEVEL_NAME = ""; List <ITableImplement> lstTable = new List <ITableImplement>(); lstTable.Add(valType); lstTable.Add(valLevel); List <ITableImplement> lstCond = new List <ITableImplement>(); lstCond.Add(condObj); List <HR_STATION> listObj = BLLTable <HR_STATION> .Factory(conn).Select(valObj, lstRelatio, lstTable, lstCond); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_STATION>(hidCondition.Value); } listObj = BLLTable <HR_STATION> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_STATION>(hidCondition.Value); } listObj = BLLTable<HR_STATION>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new HR_STATION(); if(txtSTATION_ID.Value !="" ) condObj.Like(HR_STATION.Attribute.STATION_ID, Convert.ToDecimal(txtSTATION_ID.Value)); if(txtSTATION_NAME.Value !="" ) condObj.Like(HR_STATION.Attribute.STATION_NAME, Convert.ToString(txtSTATION_NAME.Value)); if(txtPID.Value !="" ) condObj.Like(HR_STATION.Attribute.PID, Convert.ToDecimal(txtPID.Value)); if(txtPATH.Value !="" ) condObj.Like(HR_STATION.Attribute.PATH, Convert.ToString(txtPATH.Value)); if(txtSUB_NUM.Value !="" ) condObj.Like(HR_STATION.Attribute.SUB_NUM, Convert.ToDecimal(txtSUB_NUM.Value)); if(txtSORT_NO.Value !="" ) condObj.Like(HR_STATION.Attribute.SORT_NO, Convert.ToDecimal(txtSORT_NO.Value)); if(txtORG_ID.Value !="" ) condObj.Like(HR_STATION.Attribute.ORG_ID, Convert.ToString(txtORG_ID.Value)); if(txtDEPT_ID.Value !="" ) condObj.Like(HR_STATION.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value)); listObj = BLLTable<HR_STATION>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; }
protected void btnOK_Click(object sender, EventArgs e) { try { HR_STATION valObj = new HR_STATION(); if (txtSTATION_ID.Value != "") { valObj.STATION_ID = Convert.ToDecimal(txtSTATION_ID.Value); } if (txtSTATION_NAME.Value != "") { valObj.STATION_NAME = Convert.ToString(txtSTATION_NAME.Value); } if (txtMBR_NUM.Value != "") { valObj.MBR_NUM = Convert.ToInt32(txtMBR_NUM.Value); } if (txtLEVEL_NAME.Value != "") { valObj.LEVEL_ID = Convert.ToDecimal(txtLEVEL_NAME.Value); } if (txtTYPE_NAME.Value != "") { valObj.TYPE_ID = Convert.ToDecimal(txtTYPE_NAME.Value); } //if(txtPID.Value !="" ) // valObj.PID = Convert.ToDecimal(txtPID.Value); //if(txtPATH.Value !="" ) // valObj.PATH = Convert.ToString(txtPATH.Value); //if(txtSUB_NUM.Value !="" ) // valObj.SUB_NUM = Convert.ToDecimal(txtSUB_NUM.Value); if (txtSORT_NO.Value != "") { valObj.SORT_NO = Convert.ToDecimal(txtSORT_NO.Value); } //if(txtORG_ID.Value !="" ) // valObj.ORG_ID = Convert.ToString(txtORG_ID.Value); //if(txtDEPT_ID.Value !="" ) // valObj.DEPT_ID = Convert.ToString(txtDEPT_ID.Value); if (keyid != "") { valObj.STATION_ID = Convert.ToInt32(keyid); count = BLLTable <HR_STATION> .Factory(conn).Update(valObj, HR_STATION.Attribute.STATION_ID); } else { valObj.ORG_ID = org; valObj.DEPT_ID = dept; if (org == "0" && dept != "") { valObj.ORG_ID = BLLTable <HR_DEPT> .Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, dept).ORG_ID; } valObj.SUB_NUM = 0; valObj.PID = decimal.Parse(pid); valObj.PATH = "0"; count = BLLTable <HR_STATION> .Factory(conn).Insert(valObj, HR_STATION.Attribute.STATION_ID); keyid = valObj.STATION_ID.ToString(); } if (count > 0) { string path = "0," + keyid; if (valObj.PID > 0) { HR_STATION pObj = BLLTable <HR_STATION> .Factory(conn).GetRowData(HR_STATION.Attribute.STATION_ID, valObj.PID); path = pObj.PATH + "," + keyid; HR_STATION pCond = new HR_STATION(); pCond.STATION_ID = valObj.PID; BLLTable <HR_STATION> .UpdateAuto(pCond, HR_STATION.Attribute.SUB_NUM, 1); } BLLTable <HR_STATION> .Factory(conn).Update(HR_STATION.Attribute.STATION_ID, keyid, HR_STATION.Attribute.PATH, path); 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } } else { txtSTATION_ID.Value = ""; txtSTATION_NAME.Value = ""; txtSORT_NO.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { //��ʾ�ӽڵ� if (Request["ShowSubNodes"] != null) { string nodetype = Request["ntype"]; StringBuilder sb = new StringBuilder("["); string pid = Request["id"];//orgid/deptid/taskid if (nodetype == "org") { #region HR_ORG obj = new HR_ORG(); HR_ORG val = new HR_ORG(); obj.P_ORG_ID = pid; val.OrderBy(HR_ORG.Attribute.SORT_NO, Order.Asc); List<HR_ORG> lst = BLLTable<HR_ORG>.Factory(conn).Select(val, obj); if (lst.Count != null) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } decimal subcount = 1;// lst[i].SUB_NUM;// lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1; sb.Append("{id:'").Append(lst[i].ORG_ID); sb.Append("',pid:'").Append(lst[i].P_ORG_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append(subcount.ToString()); sb.Append(",name:'").Append(lst[i].ORG_NAME).Append("',ntype:'org'}"); } } #endregion } if (nodetype == "org" || nodetype == "dept") { #region HR_DEPT obj = new HR_DEPT(); HR_DEPT val = new HR_DEPT(); if (nodetype == "org") { obj.ORG_ID = pid; obj.P_DEPT_ID = "0"; } else { obj.P_DEPT_ID = pid; } val.OrderBy(HR_DEPT.Attribute.SORT_NO, Order.Asc); List<HR_DEPT> lst = BLLTable<HR_DEPT>.Factory(conn).Select(val, obj); if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } int subcount = 1;// BLLTable<HR_DEPT>.Factory(conn).Select(HR_DEPT.Attribute.P_DEPT_ID, lst[i].DEPT_ID).Count; sb.Append("{rid:'").Append(lst[i].P_DEPT_ID).Append("',id:'").Append(lst[i].DEPT_ID.ToString()); sb.Append("',pid:'").Append(lst[i].P_DEPT_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append(subcount.ToString()); sb.Append(",name:'").Append(lst[i].DEPT_NAME).Append("',ntype:'dept'}"); } } #endregion } #region HR_STATION objSta = new HR_STATION(); HR_STATION valSta = new HR_STATION(); if (nodetype == "org") { objSta.ORG_ID = pid; objSta.DEPT_ID = "0"; } else if (nodetype == "dept") { objSta.DEPT_ID = pid; } else { objSta.PID = decimal.Parse(pid); } //objSta.P_ORG_ID = pid; valSta.OrderBy(HR_STATION.Attribute.SORT_NO, Order.Asc); List<HR_STATION> lstSta = BLLTable<HR_STATION>.Factory(conn).Select(valSta, objSta); if (lstSta.Count != null) { for (int i = 0; i < lstSta.Count; i++) { if (sb.Length > 2) { sb.Append(","); } decimal subcount = lstSta[i].SUB_NUM;// lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1; sb.Append("{id:'").Append(lstSta[i].STATION_ID); sb.Append("',pid:'").Append(lstSta[i].PID.ToString()).Append("',no:").Append(lstSta[i].SORT_NO); sb.Append(",sc:").Append(subcount.ToString()); sb.Append(",name:'").Append(lstSta[i].STATION_NAME).Append("',ntype:'station'}"); } } #endregion sb.Append("]"); Response.Write(sb.ToString()); } //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelSTATION_ID"] != null) { int re = delStattion(decimal.Parse(Request["DelSTATION_ID"]));// BLLTable<HR_STATION>.Factory(conn).Delete(HR_STATION.Attribute.STATION_ID, Request["DelSTATION_ID"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { //HR_STATION cond = new HR_STATION(); //cond.In(HR_STATION.Attribute.STATION_ID, Request["DelKeyIDS"]); int re = 0;// BLLTable<HR_STATION>.Factory(conn).Delete(cond); string[] arr = StringHelper.GetStringArray(Request["DelKeyIDS"], ','); for (int i = 0; i < arr.Length; i++) { re+= delStattion(decimal.Parse(arr[i])); } if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { HR_STATION val = new HR_STATION(); val.STATION_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<HR_STATION>.Factory(conn).Update(val, HR_STATION.Attribute.STATION_ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
int delStattion(decimal delid) { HR_STATION old = BLLTable<HR_STATION>.Factory(conn).GetRowData(HR_STATION.Attribute.STATION_ID, delid); int re = BLLTable<HR_STATION>.Factory(conn).Delete(HR_STATION.Attribute.STATION_ID, delid); if (re > 0 && old.PID>0) { HR_STATION pCond = new HR_STATION(); pCond.STATION_ID = old.PID; BLLTable<HR_STATION>.UpdateAuto(pCond, HR_STATION.Attribute.SUB_NUM, -1); } return re; }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new HR_STATION(); if (txtSTATION_ID.Value != "") { condObj.Like(HR_STATION.Attribute.STATION_ID, Convert.ToDecimal(txtSTATION_ID.Value)); } if (txtSTATION_NAME.Value != "") { condObj.Like(HR_STATION.Attribute.STATION_NAME, Convert.ToString(txtSTATION_NAME.Value)); } if (txtPID.Value != "") { condObj.Like(HR_STATION.Attribute.PID, Convert.ToDecimal(txtPID.Value)); } if (txtPATH.Value != "") { condObj.Like(HR_STATION.Attribute.PATH, Convert.ToString(txtPATH.Value)); } if (txtSUB_NUM.Value != "") { condObj.Like(HR_STATION.Attribute.SUB_NUM, Convert.ToDecimal(txtSUB_NUM.Value)); } if (txtSORT_NO.Value != "") { condObj.Like(HR_STATION.Attribute.SORT_NO, Convert.ToDecimal(txtSORT_NO.Value)); } if (txtORG_ID.Value != "") { condObj.Like(HR_STATION.Attribute.ORG_ID, Convert.ToString(txtORG_ID.Value)); } if (txtDEPT_ID.Value != "") { condObj.Like(HR_STATION.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value)); } listObj = BLLTable <HR_STATION> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; }
protected void btnOK_Click(object sender, EventArgs e) { try { HR_STATION valObj = new HR_STATION(); if(txtSTATION_ID.Value !="" ) valObj.STATION_ID = Convert.ToDecimal(txtSTATION_ID.Value); if(txtSTATION_NAME.Value !="" ) valObj.STATION_NAME = Convert.ToString(txtSTATION_NAME.Value); if (txtMBR_NUM.Value != "") valObj.MBR_NUM = Convert.ToInt32(txtMBR_NUM.Value); if (txtLEVEL_NAME.Value != "") valObj.LEVEL_ID = Convert.ToDecimal(txtLEVEL_NAME.Value); if (txtTYPE_NAME.Value != "") valObj.TYPE_ID = Convert.ToDecimal(txtTYPE_NAME.Value); //if(txtPID.Value !="" ) // valObj.PID = Convert.ToDecimal(txtPID.Value); //if(txtPATH.Value !="" ) // valObj.PATH = Convert.ToString(txtPATH.Value); //if(txtSUB_NUM.Value !="" ) // valObj.SUB_NUM = Convert.ToDecimal(txtSUB_NUM.Value); if(txtSORT_NO.Value !="" ) valObj.SORT_NO = Convert.ToDecimal(txtSORT_NO.Value); //if(txtORG_ID.Value !="" ) // valObj.ORG_ID = Convert.ToString(txtORG_ID.Value); //if(txtDEPT_ID.Value !="" ) // valObj.DEPT_ID = Convert.ToString(txtDEPT_ID.Value); if (keyid != "") { valObj.STATION_ID = Convert.ToInt32(keyid); count = BLLTable<HR_STATION>.Factory(conn).Update(valObj, HR_STATION.Attribute.STATION_ID); } else { valObj.ORG_ID = org; valObj.DEPT_ID = dept; if (org == "0" && dept != "") { valObj.ORG_ID = BLLTable<HR_DEPT>.Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, dept).ORG_ID; } valObj.SUB_NUM = 0; valObj.PID = decimal.Parse(pid); valObj.PATH = "0"; count = BLLTable<HR_STATION>.Factory(conn).Insert(valObj, HR_STATION.Attribute.STATION_ID); keyid = valObj.STATION_ID.ToString(); } if (count > 0) { string path = "0,"+keyid; if (valObj.PID > 0) { HR_STATION pObj = BLLTable<HR_STATION>.Factory(conn).GetRowData(HR_STATION.Attribute.STATION_ID, valObj.PID); path = pObj.PATH + "," + keyid; HR_STATION pCond = new HR_STATION(); pCond.STATION_ID = valObj.PID; BLLTable<HR_STATION>.UpdateAuto(pCond, HR_STATION.Attribute.SUB_NUM, 1); } BLLTable<HR_STATION>.Factory(conn).Update(HR_STATION.Attribute.STATION_ID, keyid, HR_STATION.Attribute.PATH, path); 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } } else { txtSTATION_ID.Value =""; txtSTATION_NAME.Value =""; txtSORT_NO.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { //显示子节点 if (Request["ShowSubNodes"] != null) { string nodetype = Request["ntype"]; StringBuilder sb = new StringBuilder("["); string pid = Request["id"];//orgid/deptid/taskid if (nodetype == "org") { #region HR_ORG obj = new HR_ORG(); HR_ORG val = new HR_ORG(); obj.P_ORG_ID = pid; val.OrderBy(HR_ORG.Attribute.SORT_NO, Order.Asc); List <HR_ORG> lst = BLLTable <HR_ORG> .Factory(conn).Select(val, obj); if (lst.Count != null) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } decimal subcount = 1;// lst[i].SUB_NUM;// lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1; sb.Append("{id:'").Append(lst[i].ORG_ID); sb.Append("',pid:'").Append(lst[i].P_ORG_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append(subcount.ToString()); sb.Append(",name:'").Append(lst[i].ORG_NAME).Append("',ntype:'org'}"); } } #endregion } if (nodetype == "org" || nodetype == "dept") { #region HR_DEPT obj = new HR_DEPT(); HR_DEPT val = new HR_DEPT(); if (nodetype == "org") { obj.ORG_ID = pid; obj.P_DEPT_ID = "0"; } else { obj.P_DEPT_ID = pid; } val.OrderBy(HR_DEPT.Attribute.SORT_NO, Order.Asc); List <HR_DEPT> lst = BLLTable <HR_DEPT> .Factory(conn).Select(val, obj); if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } int subcount = 1;// BLLTable<HR_DEPT>.Factory(conn).Select(HR_DEPT.Attribute.P_DEPT_ID, lst[i].DEPT_ID).Count; sb.Append("{rid:'").Append(lst[i].P_DEPT_ID).Append("',id:'").Append(lst[i].DEPT_ID.ToString()); sb.Append("',pid:'").Append(lst[i].P_DEPT_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append(subcount.ToString()); sb.Append(",name:'").Append(lst[i].DEPT_NAME).Append("',ntype:'dept'}"); } } #endregion } #region HR_STATION objSta = new HR_STATION(); HR_STATION valSta = new HR_STATION(); if (nodetype == "org") { objSta.ORG_ID = pid; objSta.DEPT_ID = "0"; } else if (nodetype == "dept") { objSta.DEPT_ID = pid; } else { objSta.PID = decimal.Parse(pid); } //objSta.P_ORG_ID = pid; valSta.OrderBy(HR_STATION.Attribute.SORT_NO, Order.Asc); List <HR_STATION> lstSta = BLLTable <HR_STATION> .Factory(conn).Select(valSta, objSta); if (lstSta.Count != null) { for (int i = 0; i < lstSta.Count; i++) { if (sb.Length > 2) { sb.Append(","); } decimal subcount = lstSta[i].SUB_NUM;// lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1; sb.Append("{id:'").Append(lstSta[i].STATION_ID); sb.Append("',pid:'").Append(lstSta[i].PID.ToString()).Append("',no:").Append(lstSta[i].SORT_NO); sb.Append(",sc:").Append(subcount.ToString()); sb.Append(",name:'").Append(lstSta[i].STATION_NAME).Append("',ntype:'station'}"); } } #endregion sb.Append("]"); Response.Write(sb.ToString()); } //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelSTATION_ID"] != null) { int re = delStattion(decimal.Parse(Request["DelSTATION_ID"]));// BLLTable<HR_STATION>.Factory(conn).Delete(HR_STATION.Attribute.STATION_ID, Request["DelSTATION_ID"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { //HR_STATION cond = new HR_STATION(); //cond.In(HR_STATION.Attribute.STATION_ID, Request["DelKeyIDS"]); int re = 0;// BLLTable<HR_STATION>.Factory(conn).Delete(cond); string[] arr = StringHelper.GetStringArray(Request["DelKeyIDS"], ','); for (int i = 0; i < arr.Length; i++) { re += delStattion(decimal.Parse(arr[i])); } if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { HR_STATION val = new HR_STATION(); val.STATION_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 <HR_STATION> .Factory(conn).Update(val, HR_STATION.Attribute.STATION_ID); Response.Write("修改用户信息成功"); } Response.End(); }
private void BindList(HR_STATION condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(HR_STATION.Attribute.STATION_ID, Order.Asc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); if (org != "") { condObj.DEPT_ID = "0"; condObj.ORG_ID = org; } if (dept != "") { condObj.DEPT_ID = dept; } Relation r1 = new Relation(HR_STATION.Attribute.LEVEL_ID, HR_STATION_LEVEL.Attribute.LEVEL_ID); Relation r2 = new Relation(HR_STATION.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_ID); List<Relation> lstRelatio = new List<Relation>(); lstRelatio.Add(r1); lstRelatio.Add(r2); HR_STATION_TYPE valType = new HR_STATION_TYPE(); valType.TYPE_NAME = ""; HR_STATION_LEVEL valLevel = new HR_STATION_LEVEL(); valLevel.LEVEL_NAME = ""; List<ITableImplement> lstTable = new List<ITableImplement>(); lstTable.Add(valType); lstTable.Add(valLevel); List<ITableImplement> lstCond = new List<ITableImplement>(); lstCond.Add(condObj); List<HR_STATION> listObj = BLLTable<HR_STATION>.Factory(conn).Select(valObj, lstRelatio, lstTable, lstCond); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void Page_Load(object sender, EventArgs e) { title = "��λ��Ϣ�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["STATION_ID"])) { keyid = Request["STATION_ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!string.IsNullOrEmpty(Request["ORG_ID"])) { org = Request["ORG_ID"]; } if (!string.IsNullOrEmpty(Request["DEPT_ID"])) { dept = Request["DEPT_ID"]; //Response.Write(BLLTable<HR_DEPT>.Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, dept).ORG_ID); } if (!string.IsNullOrEmpty(Request["P_ID"])) { pid = Request["P_ID"]; } if (!IsPostBack) { txtTYPE_NAME.Items.AddRange(FormHelper.GetListItem(HR_STATION_TYPE.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_NAME)); txtLEVEL_NAME.Items.AddRange(FormHelper.GetListItem(HR_STATION_LEVEL.Attribute.LEVEL_ID,HR_STATION_LEVEL.Attribute.LEVEL_ID,HR_STATION_LEVEL.Attribute.LEVEL_NAME)); this.txtSTATION_ID.Disabled = true; this.txtSTATION_ID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable<HR_STATION>.Factory(conn).GetRowData(HR_STATION.Attribute.STATION_ID, keyid); if(valObj==null) return ; txtSTATION_ID.Value = Convert.ToString(valObj.STATION_ID);//Convert.ToDecimal txtSTATION_NAME.Value = Convert.ToString(valObj.STATION_NAME);//Convert.ToString //txtPID.Value = Convert.ToString(valObj.PID);//Convert.ToDecimal //txtPATH.Value = Convert.ToString(valObj.PATH);//Convert.ToString //txtSUB_NUM.Value = Convert.ToString(valObj.SUB_NUM);//Convert.ToDecimal txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToDecimal txtMBR_NUM.Value = Convert.ToString(valObj.MBR_NUM); txtLEVEL_NAME.Value = Convert.ToString(valObj.LEVEL_ID); txtTYPE_NAME.Value = Convert.ToString(valObj.TYPE_ID); //txtORG_ID.Value = Convert.ToString(valObj.ORG_ID);//Convert.ToString //txtDEPT_ID.Value = Convert.ToString(valObj.DEPT_ID);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
private void BindList(HR_STAFF condObj, int curPage) { if (valObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { valObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc); } if (deptid != "") { condDep.DEPT_ID = deptid; //Response.Write(deptid); } else { condDep.Where("HR_DEPT_STAFF.DEPT_ID = '' or HR_DEPT_STAFF.DEPT_ID is null"); } //condObj.PID = decimal.Parse(pid); valObj.LoadAllAttributes(false); showTableColumnList.Add(HR_STAFF.Attribute.PATH); showTableColumnList.Add(HR_STAFF.Attribute.PNAME); showTableColumnList.Add(HR_STAFF.Attribute.GENDER); valObj.Add(showTableColumnList.ToArray()); Relation rel = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_DEPT_STAFF.Attribute.STAFF_ID); List <ITableImplement> lst = new List <ITableImplement>(); lst.Add(condDep); lst.Add(condObj); listObj = BLLTable <HR_STAFF> .Factory(conn).SelectByPage(valObj, rel, new HR_DEPT_STAFF(), lst, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; //部门领导 HR_DEPT_MANAGER valObj2 = new HR_DEPT_MANAGER(); HR_DEPT_MANAGER condObj2 = new HR_DEPT_MANAGER(); valObj2.Top(1); condObj2.DEPT_ID = deptid; List <HR_DEPT_MANAGER> listObj2 = BLLTable <HR_DEPT_MANAGER> .Factory(conn).Select(valObj2, condObj2); repList_DEPT_MANAGER.DataSource = listObj2; repList_DEPT_MANAGER.DataBind(); //岗位信息 HR_STATION valObj3 = new HR_STATION(); HR_STATION condObj3 = new HR_STATION(); Relation r1 = new Relation(HR_STATION.Attribute.LEVEL_ID, HR_STATION_LEVEL.Attribute.LEVEL_ID); Relation r2 = new Relation(HR_STATION.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_ID); List <Relation> lstRelatio = new List <Relation>(); lstRelatio.Add(r1); lstRelatio.Add(r2); HR_STATION_TYPE valType = new HR_STATION_TYPE(); valType.TYPE_NAME = ""; HR_STATION_LEVEL valLevel = new HR_STATION_LEVEL(); valLevel.LEVEL_NAME = ""; List <ITableImplement> lstTable = new List <ITableImplement>(); lstTable.Add(valType); lstTable.Add(valLevel); condObj3.DEPT_ID = deptid; List <ITableImplement> lstCond = new List <ITableImplement>(); lstCond.Add(condObj3); List <HR_STATION> listObj3 = BLLTable <HR_STATION> .Factory(conn).Select(valObj3, lstRelatio, lstTable, lstCond); repList_HR_STATION.DataSource = listObj3; repList_HR_STATION.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { title = "╦зн╩пео╒╠Ю╪╜"; Page.Title = title; if (!string.IsNullOrEmpty(Request["STATION_ID"])) { keyid = Request["STATION_ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!string.IsNullOrEmpty(Request["ORG_ID"])) { org = Request["ORG_ID"]; } if (!string.IsNullOrEmpty(Request["DEPT_ID"])) { dept = Request["DEPT_ID"]; //Response.Write(BLLTable<HR_DEPT>.Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, dept).ORG_ID); } if (!string.IsNullOrEmpty(Request["P_ID"])) { pid = Request["P_ID"]; } if (!IsPostBack) { txtTYPE_NAME.Items.AddRange(FormHelper.GetListItem(HR_STATION_TYPE.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_NAME)); txtLEVEL_NAME.Items.AddRange(FormHelper.GetListItem(HR_STATION_LEVEL.Attribute.LEVEL_ID, HR_STATION_LEVEL.Attribute.LEVEL_ID, HR_STATION_LEVEL.Attribute.LEVEL_NAME)); this.txtSTATION_ID.Disabled = true; this.txtSTATION_ID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable <HR_STATION> .Factory(conn).GetRowData(HR_STATION.Attribute.STATION_ID, keyid); if (valObj == null) { return; } txtSTATION_ID.Value = Convert.ToString(valObj.STATION_ID); //Convert.ToDecimal txtSTATION_NAME.Value = Convert.ToString(valObj.STATION_NAME); //Convert.ToString //txtPID.Value = Convert.ToString(valObj.PID);//Convert.ToDecimal //txtPATH.Value = Convert.ToString(valObj.PATH);//Convert.ToString //txtSUB_NUM.Value = Convert.ToString(valObj.SUB_NUM);//Convert.ToDecimal txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToDecimal txtMBR_NUM.Value = Convert.ToString(valObj.MBR_NUM); txtLEVEL_NAME.Value = Convert.ToString(valObj.LEVEL_ID); txtTYPE_NAME.Value = Convert.ToString(valObj.TYPE_ID); //txtORG_ID.Value = Convert.ToString(valObj.ORG_ID);//Convert.ToString //txtDEPT_ID.Value = Convert.ToString(valObj.DEPT_ID);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
private void BindList(HR_STAFF condObj, int curPage) { if (valObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� valObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc); if (deptid != "") { condDep.DEPT_ID = deptid; //Response.Write(deptid); } else { condDep.Where("HR_DEPT_STAFF.DEPT_ID = '' or HR_DEPT_STAFF.DEPT_ID is null"); } //condObj.PID = decimal.Parse(pid); valObj.LoadAllAttributes(false); showTableColumnList.Add(HR_STAFF.Attribute.PATH); showTableColumnList.Add(HR_STAFF.Attribute.PNAME); showTableColumnList.Add(HR_STAFF.Attribute.GENDER); valObj.Add(showTableColumnList.ToArray()); Relation rel = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_DEPT_STAFF.Attribute.STAFF_ID); List<ITableImplement> lst = new List<ITableImplement>(); lst.Add(condDep); lst.Add(condObj); listObj = BLLTable<HR_STAFF>.Factory(conn).SelectByPage(valObj, rel, new HR_DEPT_STAFF(), lst, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; //�����쵼 HR_DEPT_MANAGER valObj2 = new HR_DEPT_MANAGER(); HR_DEPT_MANAGER condObj2 = new HR_DEPT_MANAGER(); valObj2.Top(1); condObj2.DEPT_ID = deptid; List<HR_DEPT_MANAGER> listObj2 = BLLTable<HR_DEPT_MANAGER>.Factory(conn).Select(valObj2, condObj2); repList_DEPT_MANAGER.DataSource = listObj2; repList_DEPT_MANAGER.DataBind(); //��λ��Ϣ HR_STATION valObj3 = new HR_STATION(); HR_STATION condObj3 = new HR_STATION(); Relation r1 = new Relation(HR_STATION.Attribute.LEVEL_ID,HR_STATION_LEVEL.Attribute.LEVEL_ID); Relation r2 = new Relation(HR_STATION.Attribute.TYPE_ID, HR_STATION_TYPE.Attribute.TYPE_ID); List<Relation> lstRelatio=new List<Relation>(); lstRelatio.Add(r1); lstRelatio.Add(r2); HR_STATION_TYPE valType = new HR_STATION_TYPE(); valType.TYPE_NAME = ""; HR_STATION_LEVEL valLevel = new HR_STATION_LEVEL(); valLevel.LEVEL_NAME = ""; List<ITableImplement> lstTable = new List<ITableImplement>(); lstTable.Add(valType); lstTable.Add(valLevel); condObj3.DEPT_ID = deptid; List<ITableImplement> lstCond = new List<ITableImplement>(); lstCond.Add(condObj3); List<HR_STATION> listObj3 = BLLTable<HR_STATION>.Factory(conn).Select(valObj3, lstRelatio, lstTable, lstCond); repList_HR_STATION.DataSource = listObj3; repList_HR_STATION.DataBind(); }
private void BindList(HR_STAFF condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc); if (deptid != "") { condObj.DEPT_ID = deptid; //Response.Write(deptid); } //condObj.PID = decimal.Parse(pid); valObj.LoadAllAttributes(false); showTableColumnList.Add(HR_STAFF.Attribute.PATH); showTableColumnList.Add(HR_STAFF.Attribute.PNAME); showTableColumnList.Add(HR_STAFF.Attribute.GENDER); valObj.Add(showTableColumnList.ToArray()); listObj = BLLTable<HR_STAFF>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; //�����쵼 HR_DEPT_MANAGER valObj2 = new HR_DEPT_MANAGER(); HR_DEPT_MANAGER condObj2 = new HR_DEPT_MANAGER(); condObj2.DEPT_ID = deptid; List<HR_DEPT_MANAGER> listObj2 = BLLTable<HR_DEPT_MANAGER>.Factory(conn).Select(valObj2, condObj2); repList_DEPT_MANAGER.DataSource = listObj2; repList_DEPT_MANAGER.DataBind(); //��λ��Ϣ HR_STATION valObj3 = new HR_STATION(); HR_STATION condObj3 = new HR_STATION(); condObj3.DEPT_ID = deptid; List<HR_STATION> listObj3 = BLLTable<HR_STATION>.Factory(conn).Select(valObj3, condObj3); repList_HR_STATION.DataSource = listObj3; repList_HR_STATION.DataBind(); }