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