private void BindList(HR_DEPT_MANAGER condObj)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(HR_DEPT_MANAGER.Attribute.DEPT_ID, Order.Desc);
condObj.DEPT_ID = deptid;
listObj = BLLTable<HR_DEPT_MANAGER>.Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelMAG_ID"] != null)
{
int re = BLLTable <HR_DEPT_MANAGER> .Factory(conn).Delete(HR_DEPT_MANAGER.Attribute.MAG_ID, Request["DelMAG_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
HR_DEPT_MANAGER cond = new HR_DEPT_MANAGER();
cond.In(HR_DEPT_MANAGER.Attribute.MAG_ID, Request["DelKeyIDS"]);
int re = BLLTable <HR_DEPT_MANAGER> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
HR_DEPT_MANAGER val = new HR_DEPT_MANAGER();
val.MAG_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_DEPT_MANAGER> .Factory(conn).Update(val, HR_DEPT_MANAGER.Attribute.MAG_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
private void BindList(HR_DEPT_MANAGER condObj)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(HR_DEPT_MANAGER.Attribute.DEPT_ID, Order.Desc);
}
condObj.DEPT_ID = deptid;
listObj = BLLTable <HR_DEPT_MANAGER> .Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelMAG_ID"] != null)
{
int re = BLLTable<HR_DEPT_MANAGER>.Factory(conn).Delete(HR_DEPT_MANAGER.Attribute.MAG_ID, Request["DelMAG_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
HR_DEPT_MANAGER cond = new HR_DEPT_MANAGER();
cond.In(HR_DEPT_MANAGER.Attribute.MAG_ID, Request["DelKeyIDS"]);
int re = BLLTable<HR_DEPT_MANAGER>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
HR_DEPT_MANAGER val = new HR_DEPT_MANAGER();
val.MAG_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_DEPT_MANAGER>.Factory(conn).Update(val, HR_DEPT_MANAGER.Attribute.MAG_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
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();
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
HR_DEPT_MANAGER valObj = new HR_DEPT_MANAGER();
valObj.DEPT_ID = deptid;
if (wucSelStaff1.Staff_ID > 0)
{
valObj.STAFF_ID = wucSelStaff1.Staff_ID;
valObj.MAG_NAME = wucSelStaff1.Staff_NAME;
}
if (txtLEVEL_CODE.Value != "")
{
valObj.LEVEL_CODE = Convert.ToString(txtLEVEL_CODE.Value);
}
count = BLLTable <HR_DEPT_MANAGER> .Factory(conn).Insert(valObj, HR_DEPT_MANAGER.Attribute.MAG_ID);
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("})");
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
{
//txtDEPT_ID.Value ="";
//txtSTAFF_ID.Value ="";
txtLEVEL_CODE.Value = "";
}
}
}
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 btnOK_Click(object sender, EventArgs e)
{
try
{
HR_DEPT_MANAGER valObj = new HR_DEPT_MANAGER();
valObj.DEPT_ID = deptid;
if (wucSelStaff1.Staff_ID > 0)
{
valObj.STAFF_ID = wucSelStaff1.Staff_ID;
valObj.MAG_NAME = wucSelStaff1.Staff_NAME;
}
if(txtLEVEL_CODE.Value !="" )
valObj.LEVEL_CODE = Convert.ToString(txtLEVEL_CODE.Value);
count = BLLTable<HR_DEPT_MANAGER>.Factory(conn).Insert(valObj, HR_DEPT_MANAGER.Attribute.MAG_ID);
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("})");
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
{
//txtDEPT_ID.Value ="";
//txtSTAFF_ID.Value ="";
txtLEVEL_CODE.Value ="";
}
}
}
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();
}
