private void BindList(DateTime stime, DateTime etime)
{
m_StaffAndScore = new List <List <string> >();
if (staffid > 0)
{
List <string> sas = GetStaffScore(stime, etime, staffid.ToString(), staffname);
if (sas != null && sas.Count > 0)
{
m_StaffAndScore.Add(sas);
}
}
else if (!string.IsNullOrEmpty(deptid))
{
HR_STAFF conObj = new HR_STAFF();
conObj.Where("{0} like '{1}%' ", HR_STAFF.Attribute.DEPT_ID, deptid);
HR_STAFF valObj = new HR_STAFF();
valObj.STAFF_ID = 0;
valObj.STAFF_NAME = "";
List <HR_STAFF> staffs = BLLTable <HR_STAFF> .Factory(conn).Select(valObj, conObj);
foreach (HR_STAFF s in staffs)
{
List <string> sas = GetStaffScore(stime, etime, s.STAFF_ID.ToString(), s.STAFF_NAME);
if (sas != null && sas.Count > 0)
{
m_StaffAndScore.Add(sas);
}
}
}
repList.DataSource = m_StaffAndScore;
repList.DataBind();
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <HR_STAFF>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<HR_STAFF>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
HR_STAFF js = userBase.GetStaff();
hid_SID.Value = js.STAFF_ID.ToString();
ddl_CusStatus.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus));
txt_addCustSexMan.Checked = true;
btnAddShop.Visible = false;
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <HR_STAFF>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new HR_STAFF();
if(txtSTAFF_NO.Value !="" )
condObj.Like(HR_STAFF.Attribute.STAFF_NO, Convert.ToString(txtSTAFF_NO.Value));
if(txtNAME.Value !="" )
condObj.Like(HR_STAFF.Attribute.STAFF_NAME, Convert.ToString(txtNAME.Value));
if(txtDEPT_ID.Value !="" )
condObj.Like(HR_STAFF.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));
if(txtGENDER.Value !="" )
condObj.GENDER = Convert.ToString(txtGENDER.Value);
if(txtPOS_NAME.Value !="" )
condObj.Like(HR_STAFF.Attribute.POS_NAME, Convert.ToString(txtPOS_NAME.Value));
if(txtSTATION_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.STATION_CODE, Convert.ToString(txtSTATION_CODE.Value));
if(txtWORK_TYPE_CODE.Value !="" )
condObj.WORK_TYPE_CODE = Convert.ToString(txtWORK_TYPE_CODE.Value);
if(txtTECH_LEVEL_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.TECH_LEVEL_CODE, Convert.ToString(txtTECH_LEVEL_CODE.Value));
if(txtMOBILE.Value !="" )
condObj.Like(HR_STAFF.Attribute.MOBILE, Convert.ToString(txtMOBILE.Value));
if(txtOFFICE_TEL.Value !="" )
condObj.Like(HR_STAFF.Attribute.OFFICE_TEL, Convert.ToString(txtOFFICE_TEL.Value));
if(txtCERT_FLAG.Value !="" )
condObj.Like(HR_STAFF.Attribute.CERT_FLAG, Convert.ToString(txtCERT_FLAG.Value));
if(txtON_POS_FLAG.Value !="" )
condObj.Like(HR_STAFF.Attribute.ON_POS_FLAG, Convert.ToString(txtON_POS_FLAG.Value));
if(txtJOIN_DATE.Value !="" )
condObj.Like(HR_STAFF.Attribute.JOIN_DATE, Convert.ToString(txtJOIN_DATE.Value));
if(txtTITLE_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.TITLE_CODE, Convert.ToString(txtTITLE_CODE.Value));
if(txtSTATUS_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.STATUS_CODE, Convert.ToString(txtSTATUS_CODE.Value));
if(txtDEGREE_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.DEGREE_CODE, Convert.ToString(txtDEGREE_CODE.Value));
if(txtMAJOR.Value !="" )
condObj.Like(HR_STAFF.Attribute.MAJOR, Convert.ToString(txtMAJOR.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
private void BindList(HR_STAFF condObj)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc);
listObj = BLLTable<HR_STAFF>.Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new HR_STAFF();
condObj.PID = decimal.Parse(pid);
if (txtSNAME.Value != "")
condObj.Like(HR_STAFF.Attribute.SNAME, Convert.ToDecimal(txtSNAME.Value));
if (txtRNAME.Value != "")
condObj.Like(HR_STAFF.Attribute.RNAME, Convert.ToDecimal(txtRNAME.Value));
if(txtSTAFF_NO.Value !="" )
condObj.Like(HR_STAFF.Attribute.STAFF_NO, Convert.ToString(txtSTAFF_NO.Value));
if(txtNAME.Value !="" )
condObj.Like(HR_STAFF.Attribute.STAFF_NAME, Convert.ToString(txtNAME.Value));
if(txtDEPT_ID.Value !="" )
condObj.Like(HR_STAFF.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));
if(txtGENDER.Value !="" )
condObj.GENDER = Convert.ToString(txtGENDER.Value);
if(txtSTATION_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.STATION_CODE, Convert.ToString(txtSTATION_CODE.Value));
if(txtMOBILE.Value !="" )
condObj.Like(HR_STAFF.Attribute.MOBILE, Convert.ToString(txtMOBILE.Value));
if(txtOFFICE_TEL.Value !="" )
condObj.Like(HR_STAFF.Attribute.OFFICE_TEL, Convert.ToString(txtOFFICE_TEL.Value));
if(txtON_POS_FLAG.Value !="" )
condObj.Like(HR_STAFF.Attribute.ON_POS_FLAG, Convert.ToString(txtON_POS_FLAG.Value));
if(txtTITLE_CODE.Value !="" )
condObj.Like(HR_STAFF.Attribute.TITLE_CODE, Convert.ToString(txtTITLE_CODE.Value));
if(txtEMAIL.Value !="" )
condObj.Like(HR_STAFF.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value));
listObj = BLLTable<HR_STAFF>.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;
}
private void BindList(HR_STAFF condObj)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc);
}
listObj = BLLTable <HR_STAFF> .Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
private void BindList(HR_STAFF condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc);
}
listObj = BLLTable <HR_STAFF> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelSTAFF_ID"] != null)
{
int re = StaffHelper.DelStaff(Request["DelSTAFF_ID"]);// BLLTable<HR_STAFF>.Factory(conn).Delete(HR_STAFF.Attribute.STAFF_ID, Request["DelSTAFF_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
//HR_STAFF cond = new HR_STAFF();
//cond.In(HR_STAFF.Attribute.STAFF_ID, Request["DelKeyIDS"]);
int re = StaffHelper.DelStaff(Request["DelKeyIDS"]);// BLLTable<HR_STAFF>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
HR_STAFF val = new HR_STAFF();
val.STAFF_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_STAFF> .Factory(conn).Update(val, HR_STAFF.Attribute.STAFF_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelSTAFF_ID"] != null)
{
int re = StaffHelper.DelStaff(Request["DelSTAFF_ID"]);// BLLTable<HR_STAFF>.Factory(conn).Delete(HR_STAFF.Attribute.STAFF_ID, Request["DelSTAFF_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
//HR_STAFF cond = new HR_STAFF();
//cond.In(HR_STAFF.Attribute.STAFF_ID, Request["DelKeyIDS"]);
int re = StaffHelper.DelStaffs(Request["DelKeyIDS"]);// BLLTable<HR_STAFF>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
HR_STAFF val = new HR_STAFF();
val.STAFF_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_STAFF>.Factory(conn).Update(val, HR_STAFF.Attribute.STAFF_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
pid = Request[hidSelID.Name];
HR_STAFF valObj = BLLTable <HR_STAFF> .Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, pid);
litPathLink.Text = CommonHelper.GetPathLinks("STAFFSel.aspx", pid, valObj.PATH, valObj.PNAME);
a_top.Visible = true;
condObj.PID = decimal.Parse(pid);
listObj = BLLTable <HR_STAFF> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
aspPager.PageSize = 20;
HR_STAFF js = userBase.GetStaff();
SID = js.STAFF_ID.ToString();
if (userBase.UserType.ToString() == EnumInfo.SYS_UserType.Admin.ToString("d"))//wcp?
{
V_CMR_STAF csVal = new V_CMR_STAF();
csVal.STAFF_ID = 0;
csVal._SNAME = "";
csVal._DEPT_ID = "";
csVal.USER_ID = 0;
V_CMR_STAF csCon = new V_CMR_STAF();
csCon.DEPT_ID = js.DEPT_ID;
List <V_CMR_STAF> csList = BLLTable <V_CMR_STAF> .Factory(conn).Select(csVal, csCon);
if (csList.Count > 0)
{
ddl_Staf.Items.Add(new ListItem("自己", js.STAFF_ID.ToString()));
foreach (V_CMR_STAF cs in csList)
{
if (cs.USER_ID == userBase.UserID)
{
continue;
}
else
{
ddl_Staf.Items.Add(new ListItem(cs.SNAME, cs.STAFF_ID.ToString()));
}
}
ddl_Staf.SelectedIndex = 0;
}
}
else
{
ddl_Staf.Visible = true;
ddl_Staf.Items.Add(new ListItem("自己", SID));
ddl_Staf.SelectedIndex = 0;
}
BindData(new V_CUSTHIGHSEAS(), 1);
}
protected void Page_Load(object sender, EventArgs e)
{
#region 外部传入 非主键参数
if (Request["PID"] != null)
{
pid = Request["PID"];
}
title = valObj._ZhName + "选择";
Page.Title = title;
#endregion
if (!IsPostBack)
{
txtGENDER.Items.AddRange(FormHelper.GetListItem(HR_STAFF.Attribute.GENDER));
if (pid == "" || pid == "0")
{
a_top.Visible = false;
}
if (!string.IsNullOrEmpty(Request["ids"]))
{
HR_STAFF roleOld = new HR_STAFF();
roleOld.Where(HR_STAFF.Attribute.STAFF_ID, Request["ids"].ToString());
listObj = BLLTable <HR_STAFF> .Factory(conn).Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].STAFF_ID + "',Name:'" + listObj[i].STAFF_NAME + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].STAFF_ID;
}
}
btn_Find.Text = LanguageService.GetLanguageString("btnFind", "查询");
Page.Title = title + LanguageService.GetLanguageString("Choose", "选择");
aspPager.PageSize = 15;
condObj.PID = decimal.Parse(pid);
BindList(condObj, 1);
aspPager.CurrentPageIndex = 1;
}
}
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 aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<HR_STAFF>(hidCondition.Value);
}
listObj = BLLTable<HR_STAFF>.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_STAFF>(hidCondition.Value);
}
listObj = BLLTable <HR_STAFF> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private void BindList(DateTime stime, DateTime etime)
{
m_StaffAndScore = new List <List <string> >();
if (selStaff.Staff_ID > 0)
{
List <string> sas = GetStaffScore(stime, etime, selStaff.Staff_ID.ToString(), selStaff.Staff_NAME);
if (sas != null && sas.Count > 0)
{
m_StaffAndScore.Add(sas);
}
}
else if (!string.IsNullOrEmpty(selDept.DEPT_ID))
{
HR_STAFF conObj = new HR_STAFF();
conObj.Where("{0} like '{1}%' ", HR_STAFF.Attribute.DEPT_ID, selDept.DEPT_ID);
HR_STAFF valObj = new HR_STAFF();
valObj.STAFF_ID = 0;
valObj.STAFF_NAME = "";
List <HR_STAFF> staffs = BLLTable <HR_STAFF> .Factory(conn).Select(valObj, conObj);
foreach (HR_STAFF s in staffs)
{
List <string> sas = GetStaffScore(stime, etime, s.STAFF_ID.ToString(), s.STAFF_NAME);
if (sas != null && sas.Count > 0)
{
m_StaffAndScore.Add(sas);
}
}
}
aspPager.RecordCount = m_StaffAndScore.Count;
List <List <string> > sass = m_StaffAndScore.Count > 0 ? (m_StaffAndScore.GetRange(0, aspPager.CurrentPageIndex == aspPager.PageCount ? (m_StaffAndScore.Count) : aspPager.PageSize)) : new List <List <string> >();
repList.DataSource = sass;
repList.DataBind();
ViewState["StaffAndScore"] = m_StaffAndScore;
litScript.Text = "<script>$('.main').unmask();</script>";
}
protected void Page_Load(object sender, EventArgs e)
{
//执行投入公海操作，每天第一个用户登录的时候执行
if (LastOutPutCustToHighSeas.Date != DateTime.Now.Date)
{
OutPutCustToHighSeas();//执行投入公海操作
LastOutPutCustToHighSeas = DateTime.Now;
}
m_SName = userBase.RealName;
m_userId = "" + userBase.UserID;
HR_STAFF js = userBase.GetStaff();
m_SID = js.STAFF_ID.ToString();
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdToDayCon.STAFF_ID = js.STAFF_ID;
vcrmscdToDayCon.Where("{0} <> {1} And {2} Between '{3}' And '{4}'", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.ToString(), DateTime.Now.Date.AddDays(1).AddSeconds(-1).ToString());
V_CRM_STAFF_CUSTOMER_NOTCONTACT valToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valToDayCon.STAFF_ID = 0;
toDayConCount = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).Select(valToDayCon, vcrmscdToDayCon).Count;
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdExpiredCon.STAFF_ID = js.STAFF_ID;
vcrmscdExpiredCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-57).ToString(), DateTime.Now.Date.AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
//vcrmscdExpiredCon.Where("{0} < '{1}' And {2} <> {3}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
V_CRM_STAFF_CUSTOMER_NOTCONTACT valExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valExpiredCon.STAFF_ID = 0;
expiredCount = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).Select(valExpiredCon, vcrmscdExpiredCon).Count;
if (userBase.UserType.ToString() != EnumInfo.SYS_UserType.Admin.ToString("d"))
{
sysMange.Visible = false;
}
}
private void BindList(HR_CK_USERINFO condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(HR_CK_USERINFO.Attribute.USERID, Order.Asc);
}
#region//数据权限条件
#endregion
//condObj.PID = decimal.Parse(pid);
HR_STAFF otherVal = new HR_STAFF();
otherVal.STAFF_NAME = "";
Relation r2 = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_CK_USERINFO.Attribute.STAFF_ID, RelationType.RightJoin);
if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value) || !string.IsNullOrEmpty(txtSTAFF_NO.Value))
{
HR_STAFF otherCon = new HR_STAFF();
if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value))
{
otherCon.Like(HR_STAFF.Attribute.STAFF_NAME, txtSTAFF_NAME.Value);
}
if (!string.IsNullOrEmpty(txtSTAFF_NO.Value))
{
otherCon.Like(HR_STAFF.Attribute.STAFF_NO, txtSTAFF_NO.Value);
}
listObj = BLLTable <HR_CK_USERINFO> .Factory(conn).SelectByPage(valObj, new List <Relation>(new Relation[] { r2 }), new List <ITableImplement>(new ITableImplement[] { otherVal }), new List <ITableImplement>(new ITableImplement[] { condObj, otherCon }), aspPager.PageSize, curPage, ref recount);
}
else
{
listObj = BLLTable <HR_CK_USERINFO> .Factory(conn).SelectByPage(valObj, r2, otherVal, condObj, aspPager.PageSize, curPage, ref recount);
}
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "����";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
valObj = BLLTable<HR_STAFF>.Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, Request["STAFF_ID"]);
if(valObj==null) return ;
txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal
txtSTAFF_NO.Text = Convert.ToString(valObj.STAFF_NO);//Convert.ToString
txtNAME.Text = Convert.ToString(valObj.STAFF_NAME);//Convert.ToString
txtDEPT_ID.Text = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
txtGENDER.Text=valObj.GENDER.ToString();
//txtGENDER.Attributes.Add("Items", PageHelper.GetColOptionsText(HR_STAFF.Attribute.GENDER));
txtGENDER.Attributes.Add("Value", valObj.GENDER.ToString());
txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToString
txtPOS_NAME.Text = Convert.ToString(valObj.POS_NAME);//Convert.ToString
txtSTATION_CODE.Text = Convert.ToString(valObj.STATION_CODE);//Convert.ToString
txtWORK_TYPE_CODE.Text=valObj.WORK_TYPE_CODE.ToString();
//txtWORK_TYPE_CODE.Attributes.Add("Items", PageHelper.GetColOptionsText(HR_STAFF.Attribute.WORK_TYPE_CODE));
txtWORK_TYPE_CODE.Attributes.Add("Value", valObj.WORK_TYPE_CODE.ToString());
txtTECH_LEVEL_CODE.Text = Convert.ToString(valObj.TECH_LEVEL_CODE);//Convert.ToString
txtYMD.Text = Convert.ToString(valObj.YMD);//Convert.ToString
txtMOBILE.Text = Convert.ToString(valObj.MOBILE);//Convert.ToString
txtOFFICE_TEL.Text = Convert.ToString(valObj.OFFICE_TEL);//Convert.ToString
txtCERT_FLAG.Text = Convert.ToString(valObj.CERT_FLAG);//Convert.ToString
txtFIXED_FLAG.Text = Convert.ToString(valObj.FIXED_FLAG);//Convert.ToString
txtON_POS_FLAG.Text = Convert.ToString(valObj.ON_POS_FLAG);//Convert.ToString
txtPROFESSION_CODE.Text = Convert.ToString(valObj.PROFESSION_CODE);//Convert.ToString
txtPROFESSION_BGN_DATE.Text = Convert.ToString(valObj.PROFESSION_BGN_DATE);//Convert.ToString
txtJOIN_DATE.Text = Convert.ToString(valObj.JOIN_DATE);//Convert.ToString
txtPOLITICAL_STATUS_CODE.Text = Convert.ToString(valObj.POLITICAL_STATUS_CODE);//Convert.ToString
txtTITLE_CODE.Text = Convert.ToString(valObj.TITLE_CODE);//Convert.ToString
txtSTATUS_CODE.Text = Convert.ToString(valObj.STATUS_CODE);//Convert.ToString
txtADDR.Text = Convert.ToString(valObj.ADDR);//Convert.ToString
txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtNATION.Text = Convert.ToString(valObj.NATION);//Convert.ToString
txtNATIVE_PLACE.Text = Convert.ToString(valObj.NATIVE_PLACE);//Convert.ToString
txtPOST_NO.Text = Convert.ToString(valObj.POST_NO);//Convert.ToString
txtDEGREE_CODE.Text = Convert.ToString(valObj.DEGREE_CODE);//Convert.ToString
txtGRAD_SCHOOL.Text = Convert.ToString(valObj.GRAD_SCHOOL);//Convert.ToString
txtGRAD_DATE.Text = Convert.ToString(valObj.GRAD_DATE);//Convert.ToString
txtMAJOR.Text = Convert.ToString(valObj.MAJOR);//Convert.ToString
txtADDTIME.Text = (valObj.AF_ADDTIME == DateTime.MinValue) ? "" : valObj.AF_ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtEDITIME.Text = (valObj.AF_EDITTIME == DateTime.MinValue) ? "" : valObj.AF_EDITTIME.ToString("yyyy-MM-dd HH:mm");
txtREMARK.Text = Convert.ToString(valObj.REMARK);//Convert.ToString
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "编辑";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
//Response.Write(keyid);
txtSTATE_FLAG.Items.AddRange(FormHelper.GetListItem(SYS_USER.Attribute.USE_FLAG));
txtUSER_TYPE.Items.AddRange(FormHelper.GetListItem(SYS_USER.Attribute.USER_TYPE));
try
{
if (keyid != "")
{
valObj = BLLTable<SYS_USER>.Factory(conn).GetRowData(SYS_USER.Attribute.USER_ID, keyid);
if (valObj == null) return;
List<SYS_USERROLE> lst = BLLTable<SYS_USERROLE>.Factory(conn).Select(SYS_USERROLE.Attribute.USER_ID, keyid);
string user_role = "";
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
user_role += user_role == "" ? lst[i].ROLE_ID.ToString() : "," + lst[i].ROLE_ID;
}
}
hidSelReals.Value = user_role;
txtUSER_ID.Value = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
txtUSER_NAME.Value = Convert.ToString(valObj.USER_NAME);//Convert.ToString
ViewState["txtUSER_NAME"] = valObj.USER_NAME;
//txtPASS.Value = Convert.ToString(valObj.PASS);//Convert.ToString
txtEMAIL.Value = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtLOGIN_IPS.Value = Convert.ToString(valObj.LOGIN_IPS);//Convert.ToString
#region wk(用户新增字段)
txtUSER_QQ.Value = Convert.ToString(valObj.USER_QQ);//Convert.ToString
txtUSER_Taobao.Value = Convert.ToString(valObj.USER_Taobao);//Convert.ToString
txtIS_FeiQ_Remind.Checked = Convert.ToBoolean(valObj.IS_FeiQ_Remind);//Convert.ToString
txtIS_EMAIL_Remind.Value = Convert.ToString(valObj.IS_EMAIL_Remind);//Convert.ToString
txtIS_Taobao_Remind.Value = Convert.ToString(valObj.IS_Taobao_Remind);//Convert.ToString
txtIS_QQ_Remind.Value = Convert.ToString(valObj.IS_QQ_Remind);//Convert.ToString
#endregion
if (!string.IsNullOrEmpty(valObj.USE_FLAG))
{
txtSTATE_FLAG.Value = valObj.USE_FLAG.ToString();
}
if (!string.IsNullOrEmpty(valObj.USER_TYPE))
{
txtUSER_TYPE.Value = valObj.USER_TYPE.ToString();
}
HR_STAFF staff = BLLTable<HR_STAFF>.Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, valObj.STAFF_ID);
if (staff == null || staff.IsNull())
{
litWarn.Text = "此账户未有对应员工信息，建议增加关联或删除无效账户";
}
else
{
wucSelStaff1.Staff_ID = staff.STAFF_ID;
wucSelStaff1.Staff_NAME = valObj.REAL_NAME; //wk 2012年9月14日 15:29:18
}
btnSave.Enabled = false;
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//显示子节点
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 = 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);
HR_STAFF stfVal = new HR_STAFF();
stfVal.DEPT_ID = "";
stfVal.STAFF_ID = 0;
stfVal.STAFF_NAME = "";
HR_STAFF stfCon = new HR_STAFF();
stfCon.DEPT_ID = obj.P_DEPT_ID;
List <HR_STAFF> stflst = BLLTable <HR_STAFF> .Factory(conn).Select(stfVal, stfCon);
if (stflst.Count > 0)
{
for (int i = 0; i < stflst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{rid:'").Append(stflst[i].DEPT_ID).Append("',id:'").Append(stflst[i].STAFF_ID.ToString());
sb.Append("',pid:'").Append(stflst[i].DEPT_ID.ToString()).Append("',no:").Append(stflst[i].STAFF_ID);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(stflst[i].STAFF_NAME.Replace("?粀", "").Replace("\0", "").Replace("?", "").Replace("粀", "")).Append("',ntype:'man'}");
}
}
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 = BLLTable <HR_DEPT> .Factory(conn).Select(HR_DEPT.Attribute.P_DEPT_ID, lst[i].DEPT_ID).Count;
subcount += BLLTable <HR_STAFF> .Factory(conn).Select(HR_STAFF.Attribute.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
}
sb.Append("]");
Response.Write(sb.ToString());
}
Response.End();
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
string wran = "";
litWarn.Visible = false;
//值班类型设置
string wdTypeHtml = tbyWorkDayType.InnerHtml;
string[] wdTypeStrs = wdTypeHtml.ToLower().Contains("<tr>") ? wdTypeHtml.ToLower().Substring(wdTypeHtml.ToLower().IndexOf("<tr>")).Split(new string[] { "<tr>" }, StringSplitOptions.RemoveEmptyEntries) : new string[0];
Dictionary<DateTime, int> dicWdType = new Dictionary<DateTime, int>();
foreach (string wdTStr in wdTypeStrs)
{
string[] tds = wdTStr.ToLower().Substring(wdTStr.ToLower().IndexOf("<td>")).Split(new string[] { "<td>" }, StringSplitOptions.RemoveEmptyEntries);
if (tds.Length < 3)
continue;
DateTime sd = DateTime.MinValue;
DateTime ed = DateTime.MinValue;
int ty = -1;
if (!DateTime.TryParse(tds[0].Remove(tds[0].IndexOf('<'), tds[0].Length - tds[0].IndexOf('<')), out sd) || !DateTime.TryParse(tds[1].Remove(tds[1].IndexOf('<'), tds[1].Length - tds[1].IndexOf('<')), out ed) || !int.TryParse(tds[2].Remove(tds[2].IndexOf('<'), tds[2].Length - tds[2].IndexOf('<')), out ty))
continue;
sd = sd.Date;
ed = ed.Date;
while (sd <= ed)
{
if (!dicWdType.ContainsKey(sd))
dicWdType.Add(sd, ty);
else
dicWdType[sd] = ty;
sd = sd.AddDays(1);
}
}
//休息日设置
string[] weekStr = txtXiuXi.Value.Split(new char[] { ',', '，', ' ', ' ' }, StringSplitOptions.RemoveEmptyEntries);
//是否 周一到周7之间
bool isAllRight = true;
int[] week = new int[weekStr.Length];
for (int i = 0; i < weekStr.Length; i++)
{
if (!int.TryParse(weekStr[i].Replace(" ", ""), out week[i]))
isAllRight = false;
else if (week[i] < 1 || week[i] > 7)
isAllRight = false;
}
HR_Scheduling_IniProject proj = new HR_Scheduling_IniProject();
proj.WorkDayType = wdTypeHtml;
proj.XiuXi = txtXiuXi.Value;
proj.ProjectName = txtProjectName.Value;
if (chkFuGai.Checked)
proj.FuGaiOrZengBu = 1;
else
proj.FuGaiOrZengBu = 2;
if (isAllRight)
{
string delschWhere = " 1=1 ";
HR_STAFF stfVal = new HR_STAFF();
stfVal.STAFF_ID = 0;
HR_STAFF stfCon = new HR_STAFF();
if (!string.IsNullOrEmpty(hidstaffid.Value.Trim()))
{
stfCon.STAFF_ID = decimal.Parse(hidstaffid.Value);
delschWhere += " and HR_STAFF.STAFF_ID = " + stfCon.STAFF_ID;
proj.StaffID = stfCon.STAFF_ID.ToString();
}
else if (!string.IsNullOrEmpty(hiddeptid.Value.Trim()))
{
stfCon.Like(HR_STAFF.Attribute.DEPT_ID, hiddeptid.Value);
delschWhere += " and HR_STAFF.DEPT_ID like '" + hiddeptid.Value + "%'";
proj.DeptID = stfCon.DEPT_ID;
}
else if (!string.IsNullOrEmpty(hidorgid.Value.Trim()))
{
stfCon.Like(HR_STAFF.Attribute.ORG_ID, hidorgid.Value);
delschWhere += " and HR_STAFF.ORG_ID like '" + hidorgid.Value + "%'";
proj.OrgID = stfCon.ORG_ID;
}
else
{
stfCon.STAFF_ID = userBase.StaffID;
delschWhere += " and HR_STAFF.STAFF_ID = " + userBase.StaffID;
proj.StaffID = stfCon.STAFF_ID.ToString();
}
List<HR_STAFF> stffs = BLLTable<HR_STAFF>.Factory(conn).Select(stfVal, stfCon);
//外部传入选中的班次id
string[] schidstr = hidSelBanciId.Value.TrimEnd(',').Split(',');
proj.SelBanciId = hidSelBanciId.Value;
List<int> schids = new List<int>();
for (int i = 0; i < schidstr.Length; i++)
{
int sid = -1;
if (int.TryParse(schidstr[i], out sid))
schids.Add(sid);
}
int stfCount = 0;
int stfSch = 0;
//开始时间
DateTime sDate = DateTime.Parse(txtStartTime.Value);
proj.StartTime = sDate;
//结束时间
DateTime eDate = DateTime.Parse(txtEndTime.Value);
proj.EndTime = eDate;
DateTime dt = sDate;
//找出班次
List<HR_Scheduling> schList = new List<HR_Scheduling>();
foreach (HR_STAFF stf in stffs)
{
stfCount++;
dt = sDate;
while (dt.Date <= eDate.Date)
{
foreach (int schid in schids)
{
HR_Scheduling sch = new HR_Scheduling();
sch._SchYear = dt.Date.Year;
sch._SchMonth = Convert.ToInt16(dt.Date.Month);
sch._SchDay = Convert.ToInt16(dt.Date.Day);
sch._STAFF_ID = Convert.ToInt32(stf.STAFF_ID);
sch._SchType = week.Contains(CheckInOutHelper.IndexOfWeekByEnWeek(dt)) ? 3 : 1;
if (dicWdType.ContainsKey(dt.Date))
sch._SchType = dicWdType[dt.Date];
sch._SchClassid = schid;
schList.Add(sch);
}
dt = dt.AddDays(1);
stfSch++;
}
}
int buildCount = 0;
int delsCount = 0;
if (chkFuGai.Checked)
{
//HR_Scheduling delCon = new HR_Scheduling();
//delCon.Top(1000);
//string wher = " CAST(CAST({0} AS char(4)) + '-' + CAST({1} AS char(2)) + '-' + CAST({2} AS char(2)) as datetime) >= '{3}-{4}-{5}' and CAST(CAST({6} AS char(4)) + '-' + CAST({7} AS char(2)) + '-' + CAST({8} AS char(2)) as datetime) <= '{9}-{10}-{11}' ";
//delCon.Where(wher, HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
// sDate.Year, sDate.Month, sDate.Day,
// HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
// eDate.Year, eDate.Month, eDate.Day);
//Relation rt = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_Scheduling.Attribute.STAFF_ID);
//rt.AddCondition(stfCon);
//while (BLLTable<HR_Scheduling>.Factory(conn).Delete(delCon, rt) > 0)
//{
// continue;
//}
string wher = " delete top(1000) " +
" from HR_Scheduling " +
" where CAST(CAST({0} AS char(4)) + '-' + CAST({1} AS char(2)) + '-' + CAST({2} AS char(2)) as datetime) >= '{3}-{4}-{5}' and CAST(CAST({6} AS char(4)) + '-' + CAST({7} AS char(2)) + '-' + CAST({8} AS char(2)) as datetime) <= '{9}-{10}-{11}' " +
" and HR_Scheduling.staff_id in (select hr_staff.staff_id from hr_staff where " + delschWhere + ")";
wher = string.Format(wher, HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
sDate.Year, sDate.Month, sDate.Day,
HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
eDate.Year, eDate.Month, eDate.Day);
int delCount = BLLTable.ExecSQL(new HR_Scheduling(), wher, CommandType.Text);
while (delCount > 0)
{
delsCount += delCount;
delCount = BLLTable.ExecSQL(new HR_Scheduling(), wher, CommandType.Text);
continue;
}
DataTable dataTable = BLLTable<HR_Scheduling>.qDataTable("select * from " + HR_Scheduling.Attribute.SchDay.TableName + " where 1=2");
List<DataRow> dataList = new List<DataRow>();
foreach (HR_Scheduling sch in schList)
{
DataRow dr = dataTable.NewRow();
foreach (DataColumn dc in dataTable.Columns)
{
dr[dc] = sch.GetValue(new AttributeItem(HR_Scheduling.Attribute.STAFF_ID.TableName, dc.ColumnName));
}
dataList.Add(dr);
}
try
{
//将电量数据批量插入数据库
SqlBulkCopy sbc = new SqlBulkCopy(MyConfigurationSettings.GetValue("conn"));
sbc.BatchSize = 1000;
sbc.BulkCopyTimeout = (((dataList.Count) / 1000) + 1) * 3;
sbc.DestinationTableName = HR_Scheduling.Attribute.STAFF_ID.TableName;
sbc.WriteToServer(dataList.ToArray());
buildCount += dataList.Count;
}
catch { }
}
else
{
foreach (HR_Scheduling sch in schList)
{
if (!BLLTable<HR_Scheduling>.Exists(sch))
buildCount += BLLTable<HR_Scheduling>.Factory(conn).Insert(sch, HR_Scheduling.Attribute.ID);
}
}
int ret2 = BLLTable<HR_Scheduling_IniProject>.Factory(conn).Insert(proj, HR_Scheduling_IniProject.Attribute.ID);
litScript.Text = "<script>alert('生成成功!" + (chkFuGai.Checked ? "覆盖" : "增补") + "生成" + buildCount + "条记录！删除" + delsCount
+ "条记录，保存" + ret2 + "个配置方案"
+ "');$('.main').unmask();</script>";
}
else
{
wran = "休息日输入有误！请参考提示输入。";
}
if (!string.IsNullOrEmpty(wran))
{
litWarn.Text = wran;
litWarn.Visible = true;
litScript.Text = "<script>alert('" + wran + "');$('.main').unmask();</script>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//显示子节点
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 = 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);
HR_STAFF stfVal = new HR_STAFF();
stfVal.DEPT_ID = "";
stfVal.STAFF_ID = 0;
stfVal.STAFF_NAME = "";
HR_STAFF stfCon = new HR_STAFF();
stfCon.DEPT_ID = obj.P_DEPT_ID;
List<HR_STAFF> stflst = BLLTable<HR_STAFF>.Factory(conn).Select(stfVal, stfCon);
if (stflst.Count > 0)
{
for (int i = 0; i < stflst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{rid:'").Append(stflst[i].DEPT_ID).Append("',id:'").Append(stflst[i].STAFF_ID.ToString());
sb.Append("',pid:'").Append(stflst[i].DEPT_ID.ToString()).Append("',no:").Append(stflst[i].STAFF_ID);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(stflst[i].STAFF_NAME.Replace("?粀", "").Replace("\0", "").Replace("?", "").Replace("粀", "")).Append("',ntype:'man'}");
}
}
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 = BLLTable<HR_DEPT>.Factory(conn).Select(HR_DEPT.Attribute.P_DEPT_ID, lst[i].DEPT_ID).Count;
subcount += BLLTable<HR_STAFF>.Factory(conn).Select(HR_STAFF.Attribute.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
}
sb.Append("]");
Response.Write(sb.ToString());
}
Response.End();
}
}
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)
{
if (Request["SetToStep"] != null)
{
string ids = Request["SetToStep"];
int stepid = int.Parse(Request["StepID"]);
WF_STEP_TPL step= BLLTable<WF_STEP_TPL>.Factory(conn).GetRowData(WF_STEP_TPL.Attribute.STEP_ID,stepid);
HR_STAFF cond = new HR_STAFF();
cond.In(HR_STAFF.Attribute.STAFF_ID,ids);
List<HR_STAFF> lst = BLLTable<HR_STAFF>.Factory(conn).Select(new HR_STAFF(), cond);
for (int i = 0; i < lst.Count; i++) {
WF_NOTIFIER_TPL val = new WF_NOTIFIER_TPL();
val.WFID = step.WFID;
val.PROCID = step.PROCID;
val.STEP_ID = stepid;
val.STAFF_ID = lst[i].STAFF_ID.ToString();
if (!BLLTable<WF_NOTIFIER_TPL>.Exists(val))
{
val.NOTIFIER_TYPE = "1";
val.CONDITION = "";
val.FORMULAR = "";
val.STAFF_NAME = lst[i].STAFF_NAME;
val.STATUS = "1";
BLLTable<WF_NOTIFIER_TPL>.Factory(conn).Insert(val, WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID);
}
}
WF_NOTIFIER_TPL delObj1=new WF_NOTIFIER_TPL();
delObj1.WFID = step.WFID;
delObj1.PROCID = step.PROCID;
delObj1.STEP_ID = stepid;
delObj1.STEP_ID=stepid;
if (BLLTable<WF_NOTIFIER_TPL>.Count(delObj1) > lst.Count)
{
WF_NOTIFIER_TPL delOld = new WF_NOTIFIER_TPL();
delOld.WFID = step.WFID;
delOld.PROCID = step.PROCID;
delOld.STEP_ID = stepid;
delOld.NOTIFIER_TYPE = "1";
delOld.Where("STAFF_ID not in(" + ids + ")");
BLLTable<WF_NOTIFIER_TPL>.Factory(conn).Delete(delOld);
}
}
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelNOTIFIER_ID"] != null)
{
int re = BLLTable<WF_NOTIFIER_TPL>.Factory(conn).Delete(WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID, Request["DelNOTIFIER_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
WF_NOTIFIER_TPL cond = new WF_NOTIFIER_TPL();
cond.In(WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID, Request["DelKeyIDS"]);
int re = BLLTable<WF_NOTIFIER_TPL>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
WF_NOTIFIER_TPL val = new WF_NOTIFIER_TPL();
val.NOTIFIER_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<WF_NOTIFIER_TPL>.Factory(conn).Update(val, WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "编辑";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
keyid = Request["STAFF_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["DEPT_ID"]))
{
deptid = Request["DEPT_ID"];
}
if (!string.IsNullOrEmpty(Request["PID"]))
{
pid = Request["PID"];
}
if (!IsPostBack)
{
txtGENDER.Items.AddRange(FormHelper.GetListItem(HR_STAFF.Attribute.GENDER));
txtWORK_TYPE_CODE.Items.AddRange(FormHelper.GetListItem(HR_STAFF.Attribute.WORK_TYPE_CODE));
txtGENDER.SelectedIndex = 2;
try
{
if (keyid != "")
{
valObj = BLLTable <HR_STAFF> .Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, keyid);
if (valObj == null)
{
return;
}
SYS_USER user = BLLTable <SYS_USER> .Factory(conn).GetRowData(SYS_USER.Attribute.STAFF_ID, valObj.STAFF_ID);
if (user != null && user.IsNotNull())
{
txtUSER_ID.Value = Convert.ToString(user.USER_ID);
txtUSER_NAME.Value = Convert.ToString(user.USER_NAME);
txtUSER_NAME1.Value = Convert.ToString(user.USER_NAME);
txtPASS.Value = Convert.ToString(user.PASS);
}
txtSTAFF_ID.Value = Convert.ToString(valObj.STAFF_ID); //Convert.ToDecimal
txtSTAFF_NO.Value = Convert.ToString(valObj.STAFF_NO); //Convert.ToString
txtNAME.Value = Convert.ToString(valObj.STAFF_NAME); //Convert.ToString
wucSelDept1.DEPT_ID = valObj.DEPT_ID;
//txtDEPT_ID.Value = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
//txtDEPT_Name.Value = BLLTable<HR_DEPT>.Factory(conn).GetOneValue(HR_DEPT.Attribute.DEPT_ID, valObj.DEPT_ID, HR_DEPT.Attribute.DEPT_NAME);
wucSelDept1.Enabled = true;
txtGENDER.Value = valObj.GENDER;
txtPHOTO.Value = Convert.ToString(valObj.PHOTO); //Convert.ToString
txtPOS_NAME.Value = Convert.ToString(valObj.POS_NAME); //Convert.ToString
//txtSTATION_CODE.Value = Convert.ToString(valObj.STATION_CODE);//Convert.ToString
wucSelStation1.STATION_ID = valObj.STATION_CODE;
txtWORK_TYPE_CODE.Value = valObj.WORK_TYPE_CODE;
txtTECH_LEVEL_CODE.Value = Convert.ToString(valObj.TECH_LEVEL_CODE); //Convert.ToString
txtYMD.Value = Convert.ToString(valObj.YMD); //Convert.ToString
txtMOBILE.Value = Convert.ToString(valObj.MOBILE); //Convert.ToString
txtOFFICE_TEL.Value = Convert.ToString(valObj.OFFICE_TEL); //Convert.ToString
txtCERT_FLAG.Value = Convert.ToString(valObj.CERT_FLAG); //Convert.ToString
txtFIXED_FLAG.Value = Convert.ToString(valObj.FIXED_FLAG); //Convert.ToString
txtON_POS_FLAG.Value = Convert.ToString(valObj.ON_POS_FLAG); //Convert.ToString
txtPROFESSION_CODE.Value = Convert.ToString(valObj.PROFESSION_CODE); //Convert.ToString
txtPROFESSION_BGN_DATE.Value = Convert.ToString(valObj.PROFESSION_BGN_DATE); //Convert.ToString
txtJOIN_DATE.Value = Convert.ToString(valObj.JOIN_DATE); //Convert.ToString
txtPOLITICAL_STATUS_CODE.Value = Convert.ToString(valObj.POLITICAL_STATUS_CODE); //Convert.ToString
txtTITLE_CODE.Value = Convert.ToString(valObj.TITLE_CODE); //Convert.ToString
txtSTATUS_CODE.Value = Convert.ToString(valObj.STATUS_CODE); //Convert.ToString
txtADDR.Value = Convert.ToString(valObj.ADDR); //Convert.ToString
txtEMAIL.Value = Convert.ToString(valObj.EMAIL); //Convert.ToString
txtNATION.Value = Convert.ToString(valObj.NATION); //Convert.ToString
txtNATIVE_PLACE.Value = Convert.ToString(valObj.NATIVE_PLACE); //Convert.ToString
txtPOST_NO.Value = Convert.ToString(valObj.POST_NO); //Convert.ToString
txtDEGREE_CODE.Value = Convert.ToString(valObj.DEGREE_CODE); //Convert.ToString
txtGRAD_SCHOOL.Value = Convert.ToString(valObj.GRAD_SCHOOL); //Convert.ToString
txtGRAD_DATE.Value = Convert.ToString(valObj.GRAD_DATE); //Convert.ToString
txtMAJOR.Value = Convert.ToString(valObj.MAJOR); //Convert.ToString
txtREMARK.Value = Convert.ToString(valObj.REMARK); //Convert.ToString
txtUSER_ID.Value = Convert.ToString(valObj.USER_ID); //Convert.ToDecimal
txtSNAME.Value = Convert.ToString(valObj.SNAME); //Convert.ToString
ViewState["txtSNAME"] = valObj.SNAME;
txtRNAME.Value = Convert.ToString(valObj.RNAME); //Convert.ToString
txtEXP1.Value = Convert.ToString(valObj.EXP1); //Convert.ToString
txtEXP2.Value = Convert.ToString(valObj.EXP2); //Convert.ToString
txtEXP3.Value = Convert.ToString(valObj.EXP3); //Convert.ToString
//valObj.ORG_ID
}
else
{
if (pid != "" && pid != "0")
{
deptid = BLLTable <HR_STAFF> .Factory(conn).GetOneValue(HR_STAFF.Attribute.STAFF_ID, pid, HR_STAFF.Attribute.DEPT_ID);
}
if (deptid != "")
{
wucSelDept1.DEPT_ID = deptid;
//wucSelDept1.Enabled = false;
//txtDEPT_ID.Value = deptid;
//txtDEPT_Name.Value = BLLTable<HR_DEPT>.Factory(conn).GetOneValue(HR_DEPT.Attribute.DEPT_ID, deptid, HR_DEPT.Attribute.DEPT_NAME);
}
}
LoadOtherDevice(keyid);//载入其他设备的员工信息，并提供编辑
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
private void UpdateStff(OleDbConnection conn2, string fangan)
{
if (conn2 == null)
{
return;
}
Dictionary <string, string> userFields = GetFieldsByFangAn(fangan, "USERINFO");
if (!userFields.ContainsKey("*USERINFO"))
{
Response.Write("同步方案不完整，请修改方案！");
Response.End();
return;
}
string sql = "select ";
foreach (string field in userFields.Keys)
{
if (field.Contains("*"))
{
continue;
}
sql += " " + userFields[field] + ",";
}
sql = sql.TrimEnd(',');
sql += " from " + userFields["*USERINFO"];
OleDbCommand com = new OleDbCommand(sql, conn2);
OleDbDataReader dr = com.ExecuteReader();
HR_CK_USERINFO hruser = new HR_CK_USERINFO();
List <HR_CK_USERINFO> hrusers = new List <HR_CK_USERINFO>();
Dictionary <string, HR_CK_USERINFO> userDic = new Dictionary <string, HR_CK_USERINFO>();
List <HR_CK_USERINFO> chongfuUser = new List <HR_CK_USERINFO>();
while (dr.Read())
{
try
{
hruser = new HR_CK_USERINFO();
foreach (AttributeItem ai in hruser.af_AttributeItemList)
{
if (userFields.ContainsKey("USERINFO_" + ai.FieldName))
{
object val = dr[userFields["USERINFO_" + ai.FieldName]];
if (val != null && !string.IsNullOrEmpty(val.ToString()))
{
hruser.SetValue(ai, val.ToString().Replace("?粀", "").Replace("\0", "").Replace("?", "").Replace("粀", ""));
}
}
}
hruser.Remove(new AttributeItem[] { HR_CK_USERINFO.Attribute.STAFF_ID });
if (!userDic.ContainsKey(hruser.NAME))
{
userDic.Add(hruser.NAME, hruser);
}
else
{
chongfuUser.Add(hruser);
}
hrusers.Add(hruser);
}
catch { }
}
foreach (HR_CK_USERINFO user in chongfuUser)
{
if (userDic.ContainsKey(user.NAME))
{
userDic.Remove(hruser.NAME);
}
}
HR_STAFF stfVal = new HR_STAFF();
stfVal.STAFF_NAME = "";
stfVal.STAFF_ID = 0;
HR_STAFF stfCon = new HR_STAFF();
List <HR_STAFF> stfList = BLLTable <HR_STAFF> .Factory(conn).Select(stfVal, stfCon);
Dictionary <string, HR_STAFF> stfDic = new Dictionary <string, HR_STAFF>();
List <HR_STAFF> chongfuStf = new List <HR_STAFF>();
foreach (HR_STAFF stf in stfList)
{
if (!stfDic.ContainsKey(stf.STAFF_NAME))
{
stfDic.Add(stf.STAFF_NAME, stf);
}
else
{
chongfuStf.Add(stf);
}
}
foreach (HR_STAFF stf in chongfuStf)
{
if (stfDic.ContainsKey(stf.STAFF_NAME))
{
stfDic.Remove(stf.STAFF_NAME);
}
}
foreach (string name in userDic.Keys)
{
if (stfDic.ContainsKey(name))
{
HR_CK_USERINFO stfidcon = new HR_CK_USERINFO();//wcp考虑优化新能
stfidcon.STAFF_ID = stfDic[name].STAFF_ID;
if (!BLLTable <HR_CK_USERINFO> .Exists(stfidcon))
{
userDic[name].STAFF_ID = stfDic[name].STAFF_ID;
}
}
}
int countok = 0;
int countfi = 0;
int counter = 0;
foreach (HR_CK_USERINFO user in hrusers)
{
try
{
int count = 0;
count = BLLTable <HR_CK_USERINFO> .SaveOrUpdate(user, HR_CK_USERINFO.Attribute.USERID);
if (count > 0)
{
countok++;
}
else
{
countfi++;
}
}
catch { counter++; }
}
Response.Write("同步员工信息数:" + hrusers.Count + "条" + "\n成功:" + countok + "条\n失败:" + countfi + "条\n出错:" + counter + "条");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["SetToStep"] != null)
{
string ids = Request["SetToStep"];
int stepid = int.Parse(Request["StepID"]);
WF_STEP_TPL step = BLLTable <WF_STEP_TPL> .Factory(conn).GetRowData(WF_STEP_TPL.Attribute.STEP_ID, stepid);
HR_STAFF cond = new HR_STAFF();
cond.In(HR_STAFF.Attribute.STAFF_ID, ids);
List <HR_STAFF> lst = BLLTable <HR_STAFF> .Factory(conn).Select(new HR_STAFF(), cond);
for (int i = 0; i < lst.Count; i++)
{
WF_NOTIFIER_TPL val = new WF_NOTIFIER_TPL();
val.WFID = step.WFID;
val.PROCID = step.PROCID;
val.STEP_ID = stepid;
val.STAFF_ID = lst[i].STAFF_ID.ToString();
if (!BLLTable <WF_NOTIFIER_TPL> .Exists(val))
{
val.NOTIFIER_TYPE = "1";
val.CONDITION = "";
val.FORMULAR = "";
val.STAFF_NAME = lst[i].STAFF_NAME;
val.STATUS = "1";
BLLTable <WF_NOTIFIER_TPL> .Factory(conn).Insert(val, WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID);
}
}
WF_NOTIFIER_TPL delObj1 = new WF_NOTIFIER_TPL();
delObj1.WFID = step.WFID;
delObj1.PROCID = step.PROCID;
delObj1.STEP_ID = stepid;
delObj1.STEP_ID = stepid;
if (BLLTable <WF_NOTIFIER_TPL> .Count(delObj1) > lst.Count)
{
WF_NOTIFIER_TPL delOld = new WF_NOTIFIER_TPL();
delOld.WFID = step.WFID;
delOld.PROCID = step.PROCID;
delOld.STEP_ID = stepid;
delOld.NOTIFIER_TYPE = "1";
delOld.Where("STAFF_ID not in(" + ids + ")");
BLLTable <WF_NOTIFIER_TPL> .Factory(conn).Delete(delOld);
}
}
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelNOTIFIER_ID"] != null)
{
int re = BLLTable <WF_NOTIFIER_TPL> .Factory(conn).Delete(WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID, Request["DelNOTIFIER_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
WF_NOTIFIER_TPL cond = new WF_NOTIFIER_TPL();
cond.In(WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID, Request["DelKeyIDS"]);
int re = BLLTable <WF_NOTIFIER_TPL> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
WF_NOTIFIER_TPL val = new WF_NOTIFIER_TPL();
val.NOTIFIER_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 <WF_NOTIFIER_TPL> .Factory(conn).Update(val, WF_NOTIFIER_TPL.Attribute.NOTIFIER_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (ViewState["txtSNAME"] == null || ViewState["txtSNAME"].ToString() != txtSNAME.Value)
{
HR_STAFF hadCond = new HR_STAFF();
hadCond.SNAME = txtSNAME.Value;
if (BLLTable <HR_STAFF> .Exists(hadCond))
{
litWarn.Text = "此员工已经存在，请重新输入！或换个简称。";
return;
}
}
try
{
HR_STAFF valObj = new HR_STAFF();
if (txtSTAFF_ID.Value != "")
{
valObj.STAFF_ID = Convert.ToDecimal(txtSTAFF_ID.Value);
}
valObj.STAFF_NO = txtSTAFF_NO.Value;
valObj.STAFF_NAME = Convert.ToString(txtNAME.Value);
valObj.DEPT_ID = wucSelDept1.DEPT_ID;
HR_DEPT dept = BLLTable <HR_DEPT> .Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, valObj.DEPT_ID);
valObj.ORG_ID = dept.ORG_ID;
valObj.GENDER = Convert.ToString(txtGENDER.Value);
valObj.PHOTO = Convert.ToString(txtPHOTO.Value);
valObj.POS_NAME = Convert.ToString(txtPOS_NAME.Value);
valObj.STATION_CODE = wucSelStation1.STATION_ID;// Convert.ToString(txtSTATION_CODE.Value);
valObj.WORK_TYPE_CODE = Convert.ToString(txtWORK_TYPE_CODE.Value);
valObj.TECH_LEVEL_CODE = Convert.ToString(txtTECH_LEVEL_CODE.Value);
valObj.YMD = txtYMD.Value;
valObj.MOBILE = Convert.ToString(txtMOBILE.Value);
valObj.OFFICE_TEL = Convert.ToString(txtOFFICE_TEL.Value);
valObj.CERT_FLAG = Convert.ToString(txtCERT_FLAG.Value);
valObj.FIXED_FLAG = Convert.ToString(txtFIXED_FLAG.Value);
valObj.ON_POS_FLAG = Convert.ToString(txtON_POS_FLAG.Value);
valObj.PROFESSION_CODE = Convert.ToString(txtPROFESSION_CODE.Value);
valObj.PROFESSION_BGN_DATE = Convert.ToDateTime(txtPROFESSION_BGN_DATE.Value);
valObj.JOIN_DATE = Convert.ToDateTime(txtJOIN_DATE.Value);
valObj.POLITICAL_STATUS_CODE = Convert.ToString(txtPOLITICAL_STATUS_CODE.Value);
valObj.TITLE_CODE = Convert.ToString(txtTITLE_CODE.Value);
valObj.STATUS_CODE = Convert.ToString(txtSTATUS_CODE.Value);
valObj.ADDR = Convert.ToString(txtADDR.Value);
valObj.EMAIL = Convert.ToString(txtEMAIL.Value);
valObj.NATION = Convert.ToString(txtNATION.Value);
valObj.NATIVE_PLACE = Convert.ToString(txtNATIVE_PLACE.Value);
valObj.POST_NO = Convert.ToString(txtPOST_NO.Value);
valObj.DEGREE_CODE = Convert.ToString(txtDEGREE_CODE.Value);
valObj.GRAD_SCHOOL = Convert.ToString(txtGRAD_SCHOOL.Value);
valObj.GRAD_DATE = Convert.ToDateTime(txtGRAD_DATE.Value);
valObj.MAJOR = Convert.ToString(txtMAJOR.Value);
valObj.REMARK = Convert.ToString(txtREMARK.Value);
if (txtUSER_ID.Value != "")
{
valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value);
}
valObj.SNAME = Convert.ToString(txtSNAME.Value);
valObj.RNAME = Convert.ToString(txtRNAME.Value);
valObj.EXP1 = Convert.ToString(txtEXP1.Value);
valObj.EXP2 = Convert.ToString(txtEXP2.Value);
valObj.EXP3 = Convert.ToString(txtEXP3.Value);
if (keyid != "")
{
valObj.STAFF_ID = Convert.ToDecimal(keyid);
count = StaffHelper.EditStaff(valObj);// BLLTable<HR_STAFF>.Factory(conn).Update(valObj, HR_STAFF.Attribute.STAFF_ID);
}
else
{
keyid = StaffHelper.AddStaff(valObj, pid);
count = keyid != "" ? 1 : 0;
//count = BLLTable<HR_STAFF>.Factory(conn).Insert(valObj, HR_STAFF.Attribute.STAFF_ID);
//keyid = valObj.STAFF_ID.ToString();
}
if (count > 0)
{
SYS_USER user = BLLTable <SYS_USER> .Factory(conn).GetRowData(SYS_USER.Attribute.STAFF_ID, valObj.STAFF_ID);
if (user != null && user.IsNotNull())
{
if (txtUSER_NAME.Value != "")
{
user.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
}
if (txtPASS.Value != "")
{
user.PASS = StringHelperExd.StringToMD5(txtPASS.Value);
}
user.EDITTIME = DateTime.Now;
int count2 = BLLTable <SYS_USER> .Factory(conn).Update(user, SYS_USER.Attribute.USER_ID);
}
else
{
user = new SYS_USER();
if (txtUSER_NAME.Value != "")
{
user.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
}
if (txtPASS.Value != "")
{
user.PASS = Convert.ToString(txtPASS.Value);
}
else
{
user.PASS = StringHelperExd.StringToMD5("123456");
}
user.STAFF_ID = valObj.STAFF_ID;
user.USER_TYPE = EnumInfo.SYS_UserType.Common.ToString("d");
user.USE_FLAG = "1";
user.EDITTIME = DateTime.Now;
user.ADDTIME = DateTime.Now;
user.REAL_NAME = valObj.STAFF_NAME;
user.RNAME = user.USER_NAME;
user.SNAME = user.USER_NAME;
int count2 = BLLTable <SYS_USER> .Factory(conn).Insert(user, SYS_USER.Attribute.USER_ID);
}
//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("})");
string re = "re";
if (pid != "")
{
//re = "STAFFManage.aspx?PID="+pid;
}
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + re + "';}else{window.returnValue = '" + re + "';}window.close();", true);
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
HR_STAFF stfVal = new HR_STAFF();
stfVal.STAFF_ID = 0;
List <HR_STAFF> stffs = BLLTable <HR_STAFF> .Factory(conn).Select(stfVal, new HR_STAFF());
string[] schidstr = hidSelBanciId.Value.TrimEnd(',').Split(',');
List <int> schids = new List <int>();
for (int i = 0; i < schidstr.Length; i++)
{
int sid = -1;
if (int.TryParse(schidstr[i], out sid))
{
schids.Add(sid);
}
}
int stfCount = 0;
int stfSch = 0;
DateTime sDate = DateTime.Parse(txtStartTime.Value);
DateTime eDate = DateTime.Parse(txtEndTime.Value);
DateTime dt = sDate;
List <HR_Scheduling> schList = new List <HR_Scheduling>();
foreach (HR_STAFF stf in stffs)
{
stfCount++;
dt = sDate;
while (dt.Date <= eDate.Date)
{
foreach (int schid in schids)
{
HR_Scheduling sch = new HR_Scheduling();
sch._SchYear = dt.Date.Year;
sch._SchMonth = Convert.ToInt16(dt.Date.Month);
sch._SchDay = Convert.ToInt16(dt.Date.Day);
sch._STAFF_ID = Convert.ToInt32(stf.STAFF_ID);
sch._SchType = Convert.ToInt32(txtType.Value);
sch._SchClassid = schid;
schList.Add(sch);
}
dt = dt.AddDays(1);
stfSch++;
}
}
int buildCount = 0;
HR_Scheduling delCon = new HR_Scheduling();
delCon.Top(500);
string wher = " CAST(CAST({0} AS char(4)) + '-' + CAST({1} AS char(2)) + '-' + CAST({2} AS char(2)) as datetime) >= '{3}-{4}-{5}' and CAST(CAST({6} AS char(4)) + '-' + CAST({7} AS char(2)) + '-' + CAST({8} AS char(2)) as datetime) <= '{9}-{10}-{11}' ";
delCon.Where(wher, HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
sDate.Year, sDate.Month, sDate.Day,
HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
eDate.Year, eDate.Month, eDate.Day);
while (BLLTable <HR_Scheduling> .Factory(conn).Delete(delCon) > 0)
{
continue;
}
DataTable dataTable = BLLTable <HR_Scheduling> .qDataTable("select * from " + HR_Scheduling.Attribute.SchDay.TableName + " where 1=2");
List <DataRow> dataList = new List <DataRow>();
foreach (HR_Scheduling sch in schList)
{
DataRow dr = dataTable.NewRow();
foreach (DataColumn dc in dataTable.Columns)
{
dr[dc] = sch.GetValue(new AttributeItem(HR_Scheduling.Attribute.STAFF_ID.TableName, dc.ColumnName));
}
dataList.Add(dr);
}
try
{
//将电量数据批量插入数据库
SqlBulkCopy sbc = new SqlBulkCopy(MyConfigurationSettings.GetValue("conn"));
sbc.BatchSize = 1000;
sbc.BulkCopyTimeout = (((dataList.Count) / 1000) + 1) * 3;
sbc.DestinationTableName = HR_Scheduling.Attribute.STAFF_ID.TableName;
sbc.WriteToServer(dataList.ToArray());
buildCount += dataList.Count;
}
catch { }
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "$('.main').unmask();alert('成功修改" + buildCount + "条记录');", true);
}
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 btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<HR_STAFF>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
valObj = BLLTable <HR_STAFF> .Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, Request["STAFF_ID"]);
if (valObj == null)
{
return;
}
txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal
txtSTAFF_NO.Text = Convert.ToString(valObj.STAFF_NO);//Convert.ToString
txtNAME.Text = Convert.ToString(valObj.STAFF_NAME);//Convert.ToString
txtDEPT_ID.Text = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
txtGENDER.Text = valObj.GENDER.ToString();
txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToString
txtPOS_NAME.Text = Convert.ToString(valObj.POS_NAME);//Convert.ToString
txtSTATION_CODE.Text = Convert.ToString(valObj.STATION_CODE);//Convert.ToString
txtWORK_TYPE_CODE.Text = valObj.WORK_TYPE_CODE.ToString();
txtTECH_LEVEL_CODE.Text = Convert.ToString(valObj.TECH_LEVEL_CODE);//Convert.ToString
txtYMD.Text = Convert.ToString(valObj.YMD);//Convert.ToString
txtMOBILE.Text = Convert.ToString(valObj.MOBILE);//Convert.ToString
txtOFFICE_TEL.Text = Convert.ToString(valObj.OFFICE_TEL);//Convert.ToString
txtCERT_FLAG.Text = Convert.ToString(valObj.CERT_FLAG);//Convert.ToString
txtFIXED_FLAG.Text = Convert.ToString(valObj.FIXED_FLAG);//Convert.ToString
txtON_POS_FLAG.Text = Convert.ToString(valObj.ON_POS_FLAG);//Convert.ToString
txtPROFESSION_CODE.Text = Convert.ToString(valObj.PROFESSION_CODE);//Convert.ToString
txtPROFESSION_BGN_DATE.Text = Convert.ToString(valObj.PROFESSION_BGN_DATE);//Convert.ToString
txtJOIN_DATE.Text = Convert.ToString(valObj.JOIN_DATE);//Convert.ToString
txtPOLITICAL_STATUS_CODE.Text = Convert.ToString(valObj.POLITICAL_STATUS_CODE);//Convert.ToString
txtTITLE_CODE.Text = Convert.ToString(valObj.TITLE_CODE);//Convert.ToString
txtSTATUS_CODE.Text = Convert.ToString(valObj.STATUS_CODE);//Convert.ToString
txtADDR.Text = Convert.ToString(valObj.ADDR);//Convert.ToString
txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtNATION.Text = Convert.ToString(valObj.NATION);//Convert.ToString
txtNATIVE_PLACE.Text = Convert.ToString(valObj.NATIVE_PLACE);//Convert.ToString
txtPOST_NO.Text = Convert.ToString(valObj.POST_NO);//Convert.ToString
txtDEGREE_CODE.Text = Convert.ToString(valObj.DEGREE_CODE);//Convert.ToString
txtGRAD_SCHOOL.Text = Convert.ToString(valObj.GRAD_SCHOOL);//Convert.ToString
txtGRAD_DATE.Text = Convert.ToString(valObj.GRAD_DATE);//Convert.ToString
txtMAJOR.Text = Convert.ToString(valObj.MAJOR);//Convert.ToString
txtADDTIME.Text = (valObj.AF_ADDTIME == DateTime.MinValue) ? "" : valObj.AF_ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtEDITIME.Text = (valObj.AF_EDITTIME == DateTime.MinValue) ? "" : valObj.AF_EDITTIME.ToString("yyyy-MM-dd HH:mm");
txtREMARK.Text = Convert.ToString(valObj.REMARK);//Convert.ToString
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
private void BindList(HR_CK_USERINFO condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(HR_CK_USERINFO.Attribute.USERID, Order.Asc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
HR_STAFF otherVal = new HR_STAFF();
otherVal.STAFF_NAME = "";
Relation r2 = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_CK_USERINFO.Attribute.STAFF_ID, RelationType.RightJoin);
if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value) || !string.IsNullOrEmpty(txtSTAFF_NO.Value))
{
HR_STAFF otherCon = new HR_STAFF();
if (!string.IsNullOrEmpty(txtSTAFF_NAME.Value))
otherCon.Like(HR_STAFF.Attribute.STAFF_NAME, txtSTAFF_NAME.Value);
if (!string.IsNullOrEmpty(txtSTAFF_NO.Value))
otherCon.Like(HR_STAFF.Attribute.STAFF_NO, txtSTAFF_NO.Value);
listObj = BLLTable<HR_CK_USERINFO>.Factory(conn).SelectByPage(valObj, new List<Relation>(new Relation[] { r2 }), new List<ITableImplement>(new ITableImplement[] { otherVal }), new List<ITableImplement>(new ITableImplement[] { condObj, otherCon }), aspPager.PageSize, curPage, ref recount);
}
else
listObj = BLLTable<HR_CK_USERINFO>.Factory(conn).SelectByPage(valObj, r2, otherVal, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "¸ß¼¶Î¬»¤";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
valObj = BLLTable <HR_STAFF> .Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, Request["STAFF_ID"]);
if (valObj == null)
{
return;
}
txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID); //Convert.ToDecimal
txtSTAFF_NO.Text = Convert.ToString(valObj.STAFF_NO); //Convert.ToString
txtNAME.Text = Convert.ToString(valObj.STAFF_NAME); //Convert.ToString
txtDEPT_ID.Text = Convert.ToString(valObj.DEPT_ID); //Convert.ToString
txtGENDER.Text = valObj.GENDER.ToString();
//txtGENDER.Attributes.Add("Items", PageHelper.GetColOptionsText(HR_STAFF.Attribute.GENDER));
txtGENDER.Attributes.Add("Value", valObj.GENDER.ToString());
txtPHOTO.Text = Convert.ToString(valObj.PHOTO); //Convert.ToString
txtPOS_NAME.Text = Convert.ToString(valObj.POS_NAME); //Convert.ToString
txtSTATION_CODE.Text = Convert.ToString(valObj.STATION_CODE); //Convert.ToString
txtWORK_TYPE_CODE.Text = valObj.WORK_TYPE_CODE.ToString();
//txtWORK_TYPE_CODE.Attributes.Add("Items", PageHelper.GetColOptionsText(HR_STAFF.Attribute.WORK_TYPE_CODE));
txtWORK_TYPE_CODE.Attributes.Add("Value", valObj.WORK_TYPE_CODE.ToString());
txtTECH_LEVEL_CODE.Text = Convert.ToString(valObj.TECH_LEVEL_CODE); //Convert.ToString
txtYMD.Text = Convert.ToString(valObj.YMD); //Convert.ToString
txtMOBILE.Text = Convert.ToString(valObj.MOBILE); //Convert.ToString
txtOFFICE_TEL.Text = Convert.ToString(valObj.OFFICE_TEL); //Convert.ToString
txtCERT_FLAG.Text = Convert.ToString(valObj.CERT_FLAG); //Convert.ToString
txtFIXED_FLAG.Text = Convert.ToString(valObj.FIXED_FLAG); //Convert.ToString
txtON_POS_FLAG.Text = Convert.ToString(valObj.ON_POS_FLAG); //Convert.ToString
txtPROFESSION_CODE.Text = Convert.ToString(valObj.PROFESSION_CODE); //Convert.ToString
txtPROFESSION_BGN_DATE.Text = Convert.ToString(valObj.PROFESSION_BGN_DATE); //Convert.ToString
txtJOIN_DATE.Text = Convert.ToString(valObj.JOIN_DATE); //Convert.ToString
txtPOLITICAL_STATUS_CODE.Text = Convert.ToString(valObj.POLITICAL_STATUS_CODE); //Convert.ToString
txtTITLE_CODE.Text = Convert.ToString(valObj.TITLE_CODE); //Convert.ToString
txtSTATUS_CODE.Text = Convert.ToString(valObj.STATUS_CODE); //Convert.ToString
txtADDR.Text = Convert.ToString(valObj.ADDR); //Convert.ToString
txtEMAIL.Text = Convert.ToString(valObj.EMAIL); //Convert.ToString
txtNATION.Text = Convert.ToString(valObj.NATION); //Convert.ToString
txtNATIVE_PLACE.Text = Convert.ToString(valObj.NATIVE_PLACE); //Convert.ToString
txtPOST_NO.Text = Convert.ToString(valObj.POST_NO); //Convert.ToString
txtDEGREE_CODE.Text = Convert.ToString(valObj.DEGREE_CODE); //Convert.ToString
txtGRAD_SCHOOL.Text = Convert.ToString(valObj.GRAD_SCHOOL); //Convert.ToString
txtGRAD_DATE.Text = Convert.ToString(valObj.GRAD_DATE); //Convert.ToString
txtMAJOR.Text = Convert.ToString(valObj.MAJOR); //Convert.ToString
txtADDTIME.Text = (valObj.AF_ADDTIME == DateTime.MinValue) ? "" : valObj.AF_ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtEDITIME.Text = (valObj.AF_EDITTIME == DateTime.MinValue) ? "" : valObj.AF_EDITTIME.ToString("yyyy-MM-dd HH:mm");
txtREMARK.Text = Convert.ToString(valObj.REMARK); //Convert.ToString
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID); //Convert.ToDecimal
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
keyid = Request["STAFF_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["DEPT_ID"]))
{
deptid = Request["DEPT_ID"];
}
if (!string.IsNullOrEmpty(Request["PID"]))
{
pid = Request["PID"];
}
if (!IsPostBack)
{
txtGENDER.Items.AddRange(FormHelper.GetListItem(HR_STAFF.Attribute.GENDER));
txtWORK_TYPE_CODE.Items.AddRange(FormHelper.GetListItem(HR_STAFF.Attribute.WORK_TYPE_CODE));
txtGENDER.SelectedIndex = 2;
try
{
if (keyid != "")
{
Relation rel = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_DEPT_STAFF.Attribute.STAFF_ID);
HR_STAFF cons = new HR_STAFF();
cons.STAFF_ID = Convert.ToInt32(keyid);
List<HR_STAFF> lst = BLLTable<HR_STAFF>.Factory(conn).Select(new HR_STAFF(), rel, new HR_DEPT_STAFF(), cons);
//valObj = BLLTable<HR_STAFF>.Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, keyid);
if (lst.Count == 0) return;
valObj = lst[0];
SYS_USER user = BLLTable<SYS_USER>.Factory(conn).GetRowData(SYS_USER.Attribute.STAFF_ID, valObj.STAFF_ID);
if (user != null && user.IsNotNull())
{
txtUSER_ID.Value = Convert.ToString(user.USER_ID);
txtUSER_NAME.Value = Convert.ToString(user.USER_NAME);
txtUSER_NAME1.Value = Convert.ToString(user.USER_NAME);
txtPASS.Value = Convert.ToString(user.PASS);
}
txtSTAFF_ID.Value = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal
txtSTAFF_NO.Value = Convert.ToString(valObj.STAFF_NO);//Convert.ToString
txtNAME.Value = Convert.ToString(valObj.STAFF_NAME);//Convert.ToString
wucSelDept1.DEPT_ID = Convert.ToString(valObj.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID));
hidDEPT_ID.Value = Convert.ToString(valObj.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID));
//txtDEPT_ID.Value = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
//txtDEPT_Name.Value = BLLTable<HR_DEPT>.Factory(conn).GetOneValue(HR_DEPT.Attribute.DEPT_ID, valObj.DEPT_ID, HR_DEPT.Attribute.DEPT_NAME);
wucSelDept1.Enabled = true;
txtGENDER.Value = valObj.GENDER;
txtPHOTO.Value = Convert.ToString(valObj.PHOTO);//Convert.ToString
txtPOS_NAME.Value = Convert.ToString(valObj.POS_NAME);//Convert.ToString
//txtSTATION_CODE.Value = Convert.ToString(valObj.STATION_CODE);//Convert.ToString
wucSelStation1.STATION_ID = valObj.STATION_CODE;
txtWORK_TYPE_CODE.Value = valObj.WORK_TYPE_CODE;
txtTECH_LEVEL_CODE.Value = Convert.ToString(valObj.TECH_LEVEL_CODE);//Convert.ToString
txtYMD.Value = valObj.YMD;//Convert.ToString
txtMOBILE.Value = Convert.ToString(valObj.MOBILE);//Convert.ToString
txtOFFICE_TEL.Value = Convert.ToString(valObj.OFFICE_TEL);//Convert.ToString
txtCERT_FLAG.Value = Convert.ToString(valObj.CERT_FLAG);//Convert.ToString
txtFIXED_FLAG.Value = Convert.ToString(valObj.FIXED_FLAG);//Convert.ToString
txtON_POS_FLAG.Value = Convert.ToString(valObj.ON_POS_FLAG);//Convert.ToString
txtPROFESSION_CODE.Value = Convert.ToString(valObj.PROFESSION_CODE);//Convert.ToString
txtPROFESSION_BGN_DATE.Value = Convert.ToString(valObj.PROFESSION_BGN_DATE);//Convert.ToString
txtJOIN_DATE.Value = Convert.ToString(valObj.JOIN_DATE);//Convert.ToString
txtPOLITICAL_STATUS_CODE.Value = Convert.ToString(valObj.POLITICAL_STATUS_CODE);//Convert.ToString
txtTITLE_CODE.Value = Convert.ToString(valObj.TITLE_CODE);//Convert.ToString
txtSTATUS_CODE.Value = Convert.ToString(valObj.STATUS_CODE);//Convert.ToString
txtADDR.Value = Convert.ToString(valObj.ADDR);//Convert.ToString
txtEMAIL.Value = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtNATION.Value = Convert.ToString(valObj.NATION);//Convert.ToString
txtNATIVE_PLACE.Value = Convert.ToString(valObj.NATIVE_PLACE);//Convert.ToString
txtPOST_NO.Value = Convert.ToString(valObj.POST_NO);//Convert.ToString
txtDEGREE_CODE.Value = Convert.ToString(valObj.DEGREE_CODE);//Convert.ToString
txtGRAD_SCHOOL.Value = Convert.ToString(valObj.GRAD_SCHOOL);//Convert.ToString
txtGRAD_DATE.Value = Convert.ToString(valObj.GRAD_DATE);//Convert.ToString
txtMAJOR.Value = Convert.ToString(valObj.MAJOR);//Convert.ToString
txtREMARK.Value = Convert.ToString(valObj.REMARK);//Convert.ToString
txtUSER_ID.Value = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
txtSNAME.Value = Convert.ToString(valObj.SNAME);//Convert.ToString
ViewState["txtSNAME"] = valObj.SNAME;
txtRNAME.Value = Convert.ToString(valObj.RNAME);//Convert.ToString
txtEXP1.Value = Convert.ToString(valObj.EXP1);//Convert.ToString
txtEXP2.Value = Convert.ToString(valObj.EXP2);//Convert.ToString
txtEXP3.Value = Convert.ToString(valObj.EXP3);//Convert.ToString
}
else
{
if (pid != "" && pid != "0")
{
//deptid = BLLTable<HR_STAFF>.Factory(conn).GetOneValue(HR_STAFF.Attribute.STAFF_ID, pid, HR_STAFF.Attribute.DEPT_ID);
Relation rel = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_DEPT_STAFF.Attribute.STAFF_ID);
HR_STAFF cons = new HR_STAFF();
cons.STAFF_ID = Convert.ToInt32(pid);
List<HR_STAFF> lst = BLLTable<HR_STAFF>.Factory(conn).Select(new HR_STAFF(), rel, new HR_DEPT_STAFF(), cons);
if (lst.Count > 0)
deptid = Convert.ToString(lst[0].GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID));
}
if (deptid != "")
{
wucSelDept1.DEPT_ID = deptid;
hidDEPT_ID.Value = deptid;
//wucSelDept1.Enabled = false;
//txtDEPT_ID.Value = deptid;
//txtDEPT_Name.Value = BLLTable<HR_DEPT>.Factory(conn).GetOneValue(HR_DEPT.Attribute.DEPT_ID, deptid, HR_DEPT.Attribute.DEPT_NAME);
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new HR_STAFF();
if (txtSTAFF_NO.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STAFF_NO, Convert.ToString(txtSTAFF_NO.Value));
}
if (txtNAME.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STAFF_NAME, Convert.ToString(txtNAME.Value));
}
if (txtDEPT_ID.Value != "")
{
condObj.Like(HR_STAFF.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));
}
if (txtGENDER.Value != "")
{
condObj.GENDER = Convert.ToString(txtGENDER.Value);
}
if (txtPOS_NAME.Value != "")
{
condObj.Like(HR_STAFF.Attribute.POS_NAME, Convert.ToString(txtPOS_NAME.Value));
}
if (txtSTATION_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STATION_CODE, Convert.ToString(txtSTATION_CODE.Value));
}
if (txtWORK_TYPE_CODE.Value != "")
{
condObj.WORK_TYPE_CODE = Convert.ToString(txtWORK_TYPE_CODE.Value);
}
if (txtTECH_LEVEL_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.TECH_LEVEL_CODE, Convert.ToString(txtTECH_LEVEL_CODE.Value));
}
if (txtMOBILE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.MOBILE, Convert.ToString(txtMOBILE.Value));
}
if (txtOFFICE_TEL.Value != "")
{
condObj.Like(HR_STAFF.Attribute.OFFICE_TEL, Convert.ToString(txtOFFICE_TEL.Value));
}
if (txtCERT_FLAG.Value != "")
{
condObj.Like(HR_STAFF.Attribute.CERT_FLAG, Convert.ToString(txtCERT_FLAG.Value));
}
if (txtON_POS_FLAG.Value != "")
{
condObj.Like(HR_STAFF.Attribute.ON_POS_FLAG, Convert.ToString(txtON_POS_FLAG.Value));
}
if (txtJOIN_DATE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.JOIN_DATE, Convert.ToString(txtJOIN_DATE.Value));
}
if (txtTITLE_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.TITLE_CODE, Convert.ToString(txtTITLE_CODE.Value));
}
if (txtSTATUS_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STATUS_CODE, Convert.ToString(txtSTATUS_CODE.Value));
}
if (txtDEGREE_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.DEGREE_CODE, Convert.ToString(txtDEGREE_CODE.Value));
}
if (txtMAJOR.Value != "")
{
condObj.Like(HR_STAFF.Attribute.MAJOR, Convert.ToString(txtMAJOR.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (ViewState["txtSNAME"] == null || ViewState["txtSNAME"].ToString() != txtSNAME.Value)
{
HR_STAFF hadCond = new HR_STAFF();
hadCond.SNAME = txtSNAME.Value;
if (BLLTable<HR_STAFF>.Exists(hadCond))
{
litWarn.Text = "��Ա���Ѿ����ڣ����������룡����ơ�";
return;
}
}
try
{
HR_STAFF valObj = new HR_STAFF();
HR_DEPT_STAFF valdeps = new HR_DEPT_STAFF();
if (txtSTAFF_ID.Value != "")
valObj.STAFF_ID = Convert.ToDecimal(txtSTAFF_ID.Value);
valObj.STAFF_NO = txtSTAFF_NO.Value;
valObj.STAFF_NAME = Convert.ToString(txtNAME.Value);
valObj.DEPT_ID = wucSelDept1.DEPT_ID;
valdeps.DEPT_ID = wucSelDept1.DEPT_ID;
HR_DEPT dept = BLLTable<HR_DEPT>.Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, valObj.DEPT_ID);
valObj.ORG_ID = dept.ORG_ID;
valObj.GENDER = Convert.ToString(txtGENDER.Value);
valObj.PHOTO = Convert.ToString(txtPHOTO.Value);
valObj.POS_NAME = Convert.ToString(txtPOS_NAME.Value);
valObj.STATION_CODE = wucSelStation1.STATION_ID;// Convert.ToString(txtSTATION_CODE.Value);
valObj.WORK_TYPE_CODE = Convert.ToString(txtWORK_TYPE_CODE.Value);
valObj.TECH_LEVEL_CODE = Convert.ToString(txtTECH_LEVEL_CODE.Value);
valObj.YMD = txtYMD.Value;
valObj.MOBILE = Convert.ToString(txtMOBILE.Value);
valObj.OFFICE_TEL = Convert.ToString(txtOFFICE_TEL.Value);
valObj.CERT_FLAG = Convert.ToString(txtCERT_FLAG.Value);
valObj.FIXED_FLAG = Convert.ToString(txtFIXED_FLAG.Value);
valObj.ON_POS_FLAG = Convert.ToString(txtON_POS_FLAG.Value);
valObj.PROFESSION_CODE = Convert.ToString(txtPROFESSION_CODE.Value);
valObj.PROFESSION_BGN_DATE = Convert.ToDateTime(txtPROFESSION_BGN_DATE.Value);
valObj.JOIN_DATE = Convert.ToDateTime(txtJOIN_DATE.Value);
valObj.POLITICAL_STATUS_CODE = Convert.ToString(txtPOLITICAL_STATUS_CODE.Value);
valObj.TITLE_CODE = Convert.ToString(txtTITLE_CODE.Value);
valObj.STATUS_CODE = Convert.ToString(txtSTATUS_CODE.Value);
valObj.ADDR = Convert.ToString(txtADDR.Value);
valObj.EMAIL = Convert.ToString(txtEMAIL.Value);
valObj.NATION = Convert.ToString(txtNATION.Value);
valObj.NATIVE_PLACE = Convert.ToString(txtNATIVE_PLACE.Value);
valObj.POST_NO = Convert.ToString(txtPOST_NO.Value);
valObj.DEGREE_CODE = Convert.ToString(txtDEGREE_CODE.Value);
valObj.GRAD_SCHOOL = Convert.ToString(txtGRAD_SCHOOL.Value);
valObj.GRAD_DATE = Convert.ToDateTime(txtGRAD_DATE.Value);
valObj.MAJOR = Convert.ToString(txtMAJOR.Value);
valObj.REMARK = Convert.ToString(txtREMARK.Value);
if (txtUSER_ID.Value != "")
valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value);
valObj.SNAME = Convert.ToString(txtSNAME.Value);
valObj.RNAME = Convert.ToString(txtRNAME.Value);
valObj.EXP1 = Convert.ToString(txtEXP1.Value);
valObj.EXP2 = Convert.ToString(txtEXP2.Value);
valObj.EXP3 = Convert.ToString(txtEXP3.Value);
if (keyid != "")
{
valObj.STAFF_ID = Convert.ToDecimal(keyid);
count = StaffHelper.EditStaff(valObj);// BLLTable<HR_STAFF>.Factory(conn).Update(valObj, HR_STAFF.Attribute.STAFF_ID);
valdeps.STAFF_ID = Convert.ToDecimal(keyid);
//���²���Ա����ϵ
HR_DEPT_STAFF conds = new HR_DEPT_STAFF();
conds.STAFF_ID = Convert.ToInt32(keyid);
conds.DEPT_ID = hidDEPT_ID.Value;
if (BLLTable<HR_DEPT_STAFF>.Exists(conds))
{
BLLTable<HR_DEPT_STAFF>.Update(valdeps, conds);
}
else
{
BLLTable<HR_DEPT_STAFF>.Insert(valdeps);
}
}
else
{
keyid = StaffHelper.AddStaff(valObj, pid);
count = keyid != "" ? 1 : 0;
//count = BLLTable<HR_STAFF>.Factory(conn).Insert(valObj, HR_STAFF.Attribute.STAFF_ID);
//keyid = valObj.STAFF_ID.ToString();
//��Ӳ���Ա����ϵ
valdeps.STAFF_ID = Convert.ToDecimal(keyid);
BLLTable<HR_DEPT_STAFF>.Insert(valdeps);
}
if (count > 0)
{
SYS_USER user = BLLTable<SYS_USER>.Factory(conn).GetRowData(SYS_USER.Attribute.STAFF_ID, valObj.STAFF_ID);
if (user != null && user.IsNotNull())
{
if (txtUSER_NAME.Value != "")
user.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
if (txtPASS.Value != "")
user.PASS = StringHelperExd.StringToMD5(txtPASS.Value);
user.EDITTIME = DateTime.Now;
int count2 = BLLTable<SYS_USER>.Factory(conn).Update(user, SYS_USER.Attribute.USER_ID);
}
else
{
SYS_USER hadCond = new SYS_USER();
hadCond.USER_NAME = txtUSER_NAME.Value;
if (BLLTable<SYS_USER>.Exists(hadCond))
{
litWarn.Text = "���û����Ѿ����ڣ����������룡�����ơ�";
return;
}
user = new SYS_USER();
if (txtUSER_NAME.Value != "")
user.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
if (txtPASS.Value != "")
user.PASS = Convert.ToString(txtPASS.Value);
else
user.PASS =StringHelperExd.StringToMD5("123456");
user.STAFF_ID = valObj.STAFF_ID;
user.USER_TYPE = EnumInfo.SYS_UserType.Common.ToString("d");
user.USE_FLAG = "1";
user.EDITTIME = DateTime.Now;
user.ADDTIME = DateTime.Now;
user.REAL_NAME = valObj.STAFF_NAME;
user.RNAME = user.USER_NAME;
user.SNAME = user.USER_NAME;
int count2 = BLLTable<SYS_USER>.Factory(conn).Insert(user, SYS_USER.Attribute.USER_ID);
}
//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("})");
string re = "re";
if (pid != "") {
//re = "STAFFManage.aspx?PID="+pid;
}
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + re + "';}else{window.returnValue = '" + re + "';}window.close();", true);
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private void BindList(DateTime stime, DateTime etime)
{
m_StaffAndScore = new List<List<string>>();
if (staffid > 0)
{
List<string> sas = GetStaffScore(stime, etime, staffid.ToString(), staffname);
if (sas != null && sas.Count > 0)
m_StaffAndScore.Add(sas);
}
else if (!string.IsNullOrEmpty(deptid))
{
HR_STAFF conObj = new HR_STAFF();
conObj.Where("{0} like '{1}%' ", HR_STAFF.Attribute.DEPT_ID, deptid);
HR_STAFF valObj = new HR_STAFF();
valObj.STAFF_ID = 0;
valObj.STAFF_NAME = "";
List<HR_STAFF> staffs = BLLTable<HR_STAFF>.Factory(conn).Select(valObj, conObj);
foreach (HR_STAFF s in staffs)
{
List<string> sas = GetStaffScore(stime, etime, s.STAFF_ID.ToString(), s.STAFF_NAME);
if (sas != null && sas.Count > 0)
m_StaffAndScore.Add(sas);
}
}
repList.DataSource = m_StaffAndScore;
repList.DataBind();
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
HR_STAFF stfVal = new HR_STAFF();
stfVal.STAFF_ID = 0;
List<HR_STAFF> stffs = BLLTable<HR_STAFF>.Factory(conn).Select(stfVal, new HR_STAFF());
string[] schidstr = hidSelBanciId.Value.TrimEnd(',').Split(',');
List<int> schids = new List<int>();
for (int i = 0; i < schidstr.Length; i++)
{
int sid = -1;
if (int.TryParse(schidstr[i], out sid))
schids.Add(sid);
}
int stfCount = 0;
int stfSch = 0;
DateTime sDate = DateTime.Parse(txtStartTime.Value);
DateTime eDate = DateTime.Parse(txtEndTime.Value);
DateTime dt = sDate;
List<HR_Scheduling> schList = new List<HR_Scheduling>();
foreach (HR_STAFF stf in stffs)
{
stfCount++;
dt = sDate;
while (dt.Date <= eDate.Date)
{
foreach (int schid in schids)
{
HR_Scheduling sch = new HR_Scheduling();
sch._SchYear = dt.Date.Year;
sch._SchMonth = Convert.ToInt16(dt.Date.Month);
sch._SchDay = Convert.ToInt16(dt.Date.Day);
sch._STAFF_ID = Convert.ToInt32(stf.STAFF_ID);
sch._SchType = Convert.ToInt32(txtType.Value);
sch._SchClassid = schid;
schList.Add(sch);
}
dt = dt.AddDays(1);
stfSch++;
}
}
int buildCount = 0;
HR_Scheduling delCon = new HR_Scheduling();
delCon.Top(500);
string wher = " CAST(CAST({0} AS char(4)) + '-' + CAST({1} AS char(2)) + '-' + CAST({2} AS char(2)) as datetime) >= '{3}-{4}-{5}' and CAST(CAST({6} AS char(4)) + '-' + CAST({7} AS char(2)) + '-' + CAST({8} AS char(2)) as datetime) <= '{9}-{10}-{11}' ";
delCon.Where(wher, HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
sDate.Year, sDate.Month, sDate.Day,
HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
eDate.Year, eDate.Month, eDate.Day);
while (BLLTable<HR_Scheduling>.Factory(conn).Delete(delCon) > 0)
{
continue;
}
DataTable dataTable = BLLTable<HR_Scheduling>.qDataTable("select * from " + HR_Scheduling.Attribute.SchDay.TableName + " where 1=2");
List<DataRow> dataList = new List<DataRow>();
foreach (HR_Scheduling sch in schList)
{
DataRow dr = dataTable.NewRow();
foreach (DataColumn dc in dataTable.Columns)
{
dr[dc] = sch.GetValue(new AttributeItem(HR_Scheduling.Attribute.STAFF_ID.TableName, dc.ColumnName));
}
dataList.Add(dr);
}
try
{
//���������������������ݿ�
SqlBulkCopy sbc = new SqlBulkCopy(MyConfigurationSettings.GetValue("conn"));
sbc.BatchSize = 1000;
sbc.BulkCopyTimeout = (((dataList.Count) / 1000) + 1) * 3;
sbc.DestinationTableName = HR_Scheduling.Attribute.STAFF_ID.TableName;
sbc.WriteToServer(dataList.ToArray());
buildCount += dataList.Count;
}
catch { }
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "$('.main').unmask();alert('�ɹ���" + buildCount + "����¼');", true);
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private void BindList(HR_STAFF condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(HR_STAFF.Attribute.STAFF_ID, Order.Desc);
listObj = BLLTable<HR_STAFF>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
lit_ContractedCusCount.Text = "0";
lit_ExpiredUnConCusCount.Text = "0";
lit_todayConCusCount.Text = "0";
lit_WillInHighSeasCusCount.Text = "0";
List <string> SIDList = new List <string>();
//aspPager.PageSize = 20;
HR_STAFF js = userBase.GetStaff();
SIDList.Add(js.STAFF_ID.ToString());
if (HttpContext.Current != null && HttpContext.Current.Request != null && HttpContext.Current.Request.UrlReferrer != null && !string.IsNullOrEmpty(HttpContext.Current.Request.UrlReferrer.OriginalString))
{
PreviousUrlUrl = HttpContext.Current.Request.UrlReferrer.OriginalString;
}
SID = userBase.UserID + "";
ddl_CusStatus.Items.AddRange(FormHelper.GetListItem(AgileFrame.Orm.PersistenceLayer.Model.CRM_STAFF_CUSTOMER.Attribute.CustStatus));
if (ddl_CusStatus.Items.Count > 0)
{
ddl_CusStatus.Items[0].Text = "全部状态";
ddl_CusStatus.Items[0].Value = "0";
}
if (userBase.UserType.ToString() == EnumInfo.SYS_UserType.Admin.ToString("d"))//wcp?
{
ddl_CusStatus.Visible = true;
V_CMR_STAF csVal = new V_CMR_STAF();
csVal.STAFF_ID = 0;
csVal._SNAME = "";
csVal.DEPT_NAME = "";
csVal.USER_ID = 0;
V_CMR_STAF csCon = new V_CMR_STAF();
csCon.DEPT_ID = js.DEPT_ID;
List <V_CMR_STAF> csList = BLLTable <V_CMR_STAF> .Factory(conn).Select(csVal, csCon);
if (csList.Count > 0)
{
ddl_CusStatus.SelectedIndex = 0;
ddl_CusToStf.Items.Add(new ListItem("全部" + csList[0].DEPT_NAME + "员工", "0"));
ddl_CusToStf.Items.Add(new ListItem("自己", js.STAFF_ID.ToString()));
foreach (V_CMR_STAF cs in csList)
{
if (cs.USER_ID == userBase.UserID)
{
continue;
}
else
{
ddl_CusToStf.Items.Add(new ListItem(cs.SNAME, cs.STAFF_ID.ToString()));
SIDList.Add(cs.STAFF_ID.ToString());
}
}
ddl_CusToStf.SelectedIndex = 0;
}
}
else
{
ddl_CusStatus.Visible = true;
ddl_CusToStf.Items.Add(new ListItem(userBase.RealName, userBase.UserID.ToString()));
ddl_CusToStf.SelectedIndex = 0;
}
string[] SIDArr = SIDList.ToArray();
V_CRM_STAFF_CUSTOMER vcrmscCon = new V_CRM_STAFF_CUSTOMER();
vcrmscCon.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr);
vcrmscCon.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc);
BindData(vcrmscCon, 1, aspAllCusPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdToDayCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdToDayCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdToDayCon.Where("{0} <> {1} And {2} Between '{3}' And '{4}'", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.ToString(), DateTime.Now.Date.AddDays(1).AddSeconds(-1).ToString());
vcrmscdToDayCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
//vcrmscdToDayCon.Where("{0} <> {1}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
BindData(vcrmscdToDayCon, 1, aspToDayMustConPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdExpiredCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdExpiredCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdExpiredCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-57).ToString(), DateTime.Now.Date.AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
vcrmscdExpiredCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
BindData(vcrmscdExpiredCon, 1, aspExpiredPager);
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscdWillInHighSeasCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
vcrmscdWillInHighSeasCon.In(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.STAFF_ID, SIDArr);
vcrmscdWillInHighSeasCon.Where("{0} between '{1}' And '{2}' And {3} <> {4}", V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime.FieldName, DateTime.Now.Date.AddDays(-60).ToString(), DateTime.Now.Date.AddDays(-57).AddSeconds(-1).ToString(), V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.CustStatus.FieldName, "5");
vcrmscdWillInHighSeasCon.OrderBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.NextContactTime, Order.Asc);
BindData(vcrmscdWillInHighSeasCon, 1, aspWillInHighSeasPager);
V_CRM_STAFF_CUSTOMER vcrmscContractedCon = new V_CRM_STAFF_CUSTOMER();
vcrmscContractedCon.In(V_CRM_STAFF_CUSTOMER.Attribute.SID, SIDArr);
vcrmscContractedCon._CustStatus = 5;
vcrmscContractedCon.OrderBy(V_CRM_STAFF_CUSTOMER.Attribute.LastContactTime, Order.Asc);
BindData(vcrmscContractedCon, 1, aspContractedPager);
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "��ϸ";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["STAFF_ID"]))
{
valObj = BLLTable<HR_STAFF>.Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, Request["STAFF_ID"]);
if(valObj==null) return ;
txtSTAFF_ID.Text = Convert.ToString(valObj.STAFF_ID);//Convert.ToDecimal
txtSTAFF_NO.Text = Convert.ToString(valObj.STAFF_NO);//Convert.ToString
txtNAME.Text = Convert.ToString(valObj.STAFF_NAME);//Convert.ToString
txtDEPT_ID.Text = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
txtGENDER.Text=valObj.GENDER.ToString();
txtPHOTO.Text = Convert.ToString(valObj.PHOTO);//Convert.ToString
txtPOS_NAME.Text = Convert.ToString(valObj.POS_NAME);//Convert.ToString
txtSTATION_CODE.Text = Convert.ToString(valObj.STATION_CODE);//Convert.ToString
txtWORK_TYPE_CODE.Text=valObj.WORK_TYPE_CODE.ToString();
txtTECH_LEVEL_CODE.Text = Convert.ToString(valObj.TECH_LEVEL_CODE);//Convert.ToString
txtYMD.Text = Convert.ToString(valObj.YMD);//Convert.ToString
txtMOBILE.Text = Convert.ToString(valObj.MOBILE);//Convert.ToString
txtOFFICE_TEL.Text = Convert.ToString(valObj.OFFICE_TEL);//Convert.ToString
txtCERT_FLAG.Text = Convert.ToString(valObj.CERT_FLAG);//Convert.ToString
txtFIXED_FLAG.Text = Convert.ToString(valObj.FIXED_FLAG);//Convert.ToString
txtON_POS_FLAG.Text = Convert.ToString(valObj.ON_POS_FLAG);//Convert.ToString
txtPROFESSION_CODE.Text = Convert.ToString(valObj.PROFESSION_CODE);//Convert.ToString
txtPROFESSION_BGN_DATE.Text = Convert.ToString(valObj.PROFESSION_BGN_DATE);//Convert.ToString
txtJOIN_DATE.Text = Convert.ToString(valObj.JOIN_DATE);//Convert.ToString
txtPOLITICAL_STATUS_CODE.Text = Convert.ToString(valObj.POLITICAL_STATUS_CODE);//Convert.ToString
txtTITLE_CODE.Text = Convert.ToString(valObj.TITLE_CODE);//Convert.ToString
txtSTATUS_CODE.Text = Convert.ToString(valObj.STATUS_CODE);//Convert.ToString
txtADDR.Text = Convert.ToString(valObj.ADDR);//Convert.ToString
txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString
txtNATION.Text = Convert.ToString(valObj.NATION);//Convert.ToString
txtNATIVE_PLACE.Text = Convert.ToString(valObj.NATIVE_PLACE);//Convert.ToString
txtPOST_NO.Text = Convert.ToString(valObj.POST_NO);//Convert.ToString
txtDEGREE_CODE.Text = Convert.ToString(valObj.DEGREE_CODE);//Convert.ToString
txtGRAD_SCHOOL.Text = Convert.ToString(valObj.GRAD_SCHOOL);//Convert.ToString
txtGRAD_DATE.Text = Convert.ToString(valObj.GRAD_DATE);//Convert.ToString
txtMAJOR.Text = Convert.ToString(valObj.MAJOR);//Convert.ToString
txtADDTIME.Text = (valObj.AF_ADDTIME == DateTime.MinValue) ? "" : valObj.AF_ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtEDITIME.Text = (valObj.AF_EDITTIME == DateTime.MinValue) ? "" : valObj.AF_EDITTIME.ToString("yyyy-MM-dd HH:mm");
txtREMARK.Text = Convert.ToString(valObj.REMARK);//Convert.ToString
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//�����������������
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region �ⲿ���� ����������
if (Request["PID"] != null)
{
pid = Request["PID"];
}
title = valObj._ZhName + "ѡ��";
Page.Title = title;
#endregion
if (!IsPostBack)
{
txtGENDER.Items.AddRange(FormHelper.GetListItem(HR_STAFF.Attribute.GENDER));
if (pid == "" || pid == "0")
{
a_top.Visible = false;
}
if (!string.IsNullOrEmpty(Request["ids"]))
{
HR_STAFF roleOld = new HR_STAFF();
roleOld.Where(HR_STAFF.Attribute.STAFF_ID, Request["ids"].ToString());
listObj = BLLTable<HR_STAFF>.Factory(conn).Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].STAFF_ID + "',Name:'" + listObj[i].STAFF_NAME + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].STAFF_ID;
}
}
btn_Find.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
Page.Title = title + LanguageService.GetLanguageString("Choose", "ѡ��");
aspPager.PageSize = 15;
condObj.PID = decimal.Parse(pid);
BindList(condObj, 1);
aspPager.CurrentPageIndex = 1;
}
}
private void UpdateStff(OleDbConnection conn2, string fangan)
{
if (conn2 == null)
return;
Dictionary<string, string> userFields = GetFieldsByFangAn(fangan, "USERINFO");
if (!userFields.ContainsKey("*USERINFO"))
{
Response.Write("同步方案不完整，请修改方案！");
Response.End();
return;
}
string sql = "select ";
foreach (string field in userFields.Keys)
{
if (field.Contains("*"))
continue;
sql += " " + userFields[field] + ",";
}
sql = sql.TrimEnd(',');
sql += " from " + userFields["*USERINFO"];
OleDbCommand com = new OleDbCommand(sql, conn2);
OleDbDataReader dr = com.ExecuteReader();
HR_CK_USERINFO hruser = new HR_CK_USERINFO();
List<HR_CK_USERINFO> hrusers = new List<HR_CK_USERINFO>();
Dictionary<string, HR_CK_USERINFO> userDic = new Dictionary<string, HR_CK_USERINFO>();
List<HR_CK_USERINFO> chongfuUser = new List<HR_CK_USERINFO>();
while (dr.Read())
{
try
{
hruser = new HR_CK_USERINFO();
foreach (AttributeItem ai in hruser.af_AttributeItemList)
{
if (userFields.ContainsKey("USERINFO_" + ai.FieldName))
{
object val = dr[userFields["USERINFO_" + ai.FieldName]];
if (val != null && !string.IsNullOrEmpty(val.ToString()))
hruser.SetValue(ai, val.ToString().Replace("?粀", "").Replace("\0", "").Replace("?", "").Replace("粀", ""));
}
}
hruser.Remove(new AttributeItem[] { HR_CK_USERINFO.Attribute.STAFF_ID });
if (!userDic.ContainsKey(hruser.NAME))
userDic.Add(hruser.NAME, hruser);
else
chongfuUser.Add(hruser);
hrusers.Add(hruser);
}
catch { }
}
foreach (HR_CK_USERINFO user in chongfuUser)
{
if (userDic.ContainsKey(user.NAME))
userDic.Remove(hruser.NAME);
}
HR_STAFF stfVal = new HR_STAFF();
stfVal.STAFF_NAME = "";
stfVal.STAFF_ID = 0;
HR_STAFF stfCon = new HR_STAFF();
List<HR_STAFF> stfList = BLLTable<HR_STAFF>.Factory(conn).Select(stfVal, stfCon);
Dictionary<string, HR_STAFF> stfDic = new Dictionary<string, HR_STAFF>();
List<HR_STAFF> chongfuStf = new List<HR_STAFF>();
foreach (HR_STAFF stf in stfList)
{
if (!stfDic.ContainsKey(stf.STAFF_NAME))
stfDic.Add(stf.STAFF_NAME, stf);
else
chongfuStf.Add(stf);
}
foreach (HR_STAFF stf in chongfuStf)
{
if (stfDic.ContainsKey(stf.STAFF_NAME))
stfDic.Remove(stf.STAFF_NAME);
}
foreach (string name in userDic.Keys)
{
if (stfDic.ContainsKey(name))
{
HR_CK_USERINFO stfidcon = new HR_CK_USERINFO();//wcp考虑优化新能
stfidcon.STAFF_ID = stfDic[name].STAFF_ID;
if (!BLLTable<HR_CK_USERINFO>.Exists(stfidcon))
userDic[name].STAFF_ID = stfDic[name].STAFF_ID;
}
}
int countok = 0;
int countfi = 0;
int counter = 0;
foreach (HR_CK_USERINFO user in hrusers)
{
try
{
int count = 0;
count = BLLTable<HR_CK_USERINFO>.SaveOrUpdate(user, HR_CK_USERINFO.Attribute.USERID);
if (count > 0)
countok++;
else
countfi++;
}
catch { counter++; }
}
Response.Write("同步员工信息数:" + hrusers.Count + "条" + "\n成功:" + countok + "条\n失败:" + countfi + "条\n出错:" + counter + "条");
}
private void BindList(DateTime stime, DateTime etime)
{
m_StaffAndScore = new List<List<string>>();
if (selStaff.Staff_ID > 0)
{
List<string> sas = GetStaffScore(stime, etime, selStaff.Staff_ID.ToString(), selStaff.Staff_NAME);
if (sas != null && sas.Count > 0)
m_StaffAndScore.Add(sas);
}
else if (!string.IsNullOrEmpty(selDept.DEPT_ID))
{
HR_STAFF conObj = new HR_STAFF();
conObj.Where("{0} like '{1}%' ", HR_STAFF.Attribute.DEPT_ID, selDept.DEPT_ID);
HR_STAFF valObj = new HR_STAFF();
valObj.STAFF_ID = 0;
valObj.STAFF_NAME = "";
List<HR_STAFF> staffs = BLLTable<HR_STAFF>.Factory(conn).Select(valObj, conObj);
foreach (HR_STAFF s in staffs)
{
List<string> sas = GetStaffScore(stime, etime, s.STAFF_ID.ToString(), s.STAFF_NAME);
if (sas != null && sas.Count > 0)
m_StaffAndScore.Add(sas);
}
}
aspPager.RecordCount = m_StaffAndScore.Count;
List<List<string>> sass = m_StaffAndScore.Count > 0 ? (m_StaffAndScore.GetRange(0, aspPager.CurrentPageIndex == aspPager.PageCount ? (m_StaffAndScore.Count) : aspPager.PageSize)) : new List<List<string>>();
repList.DataSource = sass;
repList.DataBind();
ViewState["StaffAndScore"] = m_StaffAndScore;
litScript.Text = "<script>$('.main').unmask();</script>";
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new HR_STAFF();
condObj.PID = decimal.Parse(pid);
if (txtSNAME.Value != "")
{
condObj.Like(HR_STAFF.Attribute.SNAME, Convert.ToDecimal(txtSNAME.Value));
}
if (txtRNAME.Value != "")
{
condObj.Like(HR_STAFF.Attribute.RNAME, Convert.ToDecimal(txtRNAME.Value));
}
if (txtSTAFF_NO.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STAFF_NO, Convert.ToString(txtSTAFF_NO.Value));
}
if (txtNAME.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STAFF_NAME, Convert.ToString(txtNAME.Value));
}
if (txtDEPT_ID.Value != "")
{
condObj.Like(HR_STAFF.Attribute.DEPT_ID, Convert.ToString(txtDEPT_ID.Value));
}
if (txtGENDER.Value != "")
{
condObj.GENDER = Convert.ToString(txtGENDER.Value);
}
if (txtSTATION_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.STATION_CODE, Convert.ToString(txtSTATION_CODE.Value));
}
if (txtMOBILE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.MOBILE, Convert.ToString(txtMOBILE.Value));
}
if (txtOFFICE_TEL.Value != "")
{
condObj.Like(HR_STAFF.Attribute.OFFICE_TEL, Convert.ToString(txtOFFICE_TEL.Value));
}
if (txtON_POS_FLAG.Value != "")
{
condObj.Like(HR_STAFF.Attribute.ON_POS_FLAG, Convert.ToString(txtON_POS_FLAG.Value));
}
if (txtTITLE_CODE.Value != "")
{
condObj.Like(HR_STAFF.Attribute.TITLE_CODE, Convert.ToString(txtTITLE_CODE.Value));
}
if (txtEMAIL.Value != "")
{
condObj.Like(HR_STAFF.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value));
}
listObj = BLLTable <HR_STAFF> .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 Page_Load(object sender, EventArgs e)
{
#region//必须的参数信息初始化
if (!string.IsNullOrEmpty(Request["RECID"]))
{
recid = decimal.Parse(Request["RECID"]);
}
if (!string.IsNullOrEmpty(Request["WFID"]))
{
wf_obj_id = int.Parse(Request["WFID"]);
if (wf_obj_id <= 0)
{
if (recid <= 0)
{
Response.Redirect("SelWFID.aspx");
}
if (ViewState["WFID"] != null)
{
wf_obj_id = Convert.ToInt32(ViewState["WFID"]);
}
}
if (ViewState["WFCNAME"] == null)
{
wfcname = BLLTable <WF_WFOBJECT> .Factory(conn).GetOneValue(WF_WFOBJECT.Attribute.WF_OBJ_ID, wf_obj_id, WF_WFOBJECT.Attribute.WF_OBJ_NAME);
ViewState["WFCNAME"] = wfcname;
}
else
{
wfcname = ViewState["WFCNAME"].ToString();
}
}
else
{
if (recid <= 0)
{
Response.Redirect("SelWFID.aspx");
}
if (ViewState["WFID"] != null)
{
wf_obj_id = Convert.ToInt32(ViewState["WFID"]);
}
}
#endregion
theme = WebHelper.GetAppPath() + "Themes/" + BasePage._ThemeName;
backUrl = WebHelper.GetAppPath() + "WF/FORMList.aspx?mime=1&WFID=" + wf_obj_id;
if (preUrl != "")
{
backUrl = preUrl;
}
title = wfcname + title;
if (!IsPostBack)
{
Form.Enctype = "multipart/form-data";
UpFilesBfSubmit1.ShowPathPre = "../";
UpFilesBfSubmit1.SavePath = "UploadFiles/WF/Rec/";
txtDEPT_ID.ORG_ID = "7";
#region//默认信息初始化
HR_STAFF staff = userBase.GetStaff();
//如果账户没有员工对应
if (staff != null && !staff.IsNull())
{
txtCSTAFF_ID.Value = staff.STAFF_ID.ToString();
txtCSTAFF_NAME.Value = staff.STAFF_NAME;
txtDEPT_ID.DEPT_ID = Convert.ToString(staff.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID));
txtSTAFF_ID.Staff_NAME = staff.STAFF_NAME;
txtSTAFF_ID.Staff_ID = staff.STAFF_ID;
txtRECNO.Value = WFRecordInfo.GetRECNO(Convert.ToString(staff.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID)));
HR_DEPT dept = BLLTable <HR_DEPT> .Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, Convert.ToString(staff.GetValue(HR_DEPT_STAFF.Attribute.DEPT_ID)));
if (dept != null && !dept.IsNull())
{
txtCDEPT_ID.Value = dept.DEPT_ID;
txtCDEPT_NAME.Value = dept.DEPT_NAME;
}
else
{
litWarn.Text = "您的账户未设置所属部门";
}
}
else
{
litWarn.Text = "您的账户未有对应员工";
}
#endregion
ViewState["CHECK_INFO"] = "";
WFOBJECT_BLL wfobj = new WFOBJECT_BLL(wf_obj_id);
//WFINFO_EXD wfexd = new WFINFO_EXD(wfid,0);
FORM_BLL formexd = wfobj.FORM_BLL;
if (recid > 0)
{
#region//单据信息编辑
WF_FORMBASE baseVal = BLLTable <WF_FORMBASE> .Factory(conn).GetRowData(WF_FORMBASE.Attribute.RECID, recid);
WFRecordInfo recObj = new WFRecordInfo(baseVal, true);
if (recObj.HadRecord == false)
{
ScriptHelper.AlertAndGo(Page, "您要编辑的申请记录不存在！", backUrl);
return;
}
if (wf_obj_id <= 0)
{
ViewState["WFID"] = baseVal.WFID;//记录下当前工作流ID
wf_obj_id = baseVal.WFID;
}
Dictionary <string, WFieldInfo> dicMore = recObj.ExdFields;
//zlg关键-构建表单
litFormMore.Text = formexd.WF_HtmlEditForm(recObj);// WFHtml.ShowMoreFormHtml(wfid, dicMore, ref sbDetail);
hadDetail = formexd.HadSubForm;
ViewState["STATUS"] = baseVal.STATUS;
if (!string.IsNullOrEmpty(baseVal.CHECK_INFO))
{
ViewState["CHECK_INFO"] = baseVal.CHECK_INFO;
}
if (recObj.Base.STATUS == WFEnum.RecStatus.Checking.ToString("d") ||
recObj.Base.STATUS == WFEnum.RecStatus.ReCheck.ToString("d") ||
recObj.Base.STATUS == WFEnum.RecStatus.Accepted.ToString("d"))
{
ScriptHelper.AlertAndGo(Page, "该记录已经进入审批流程，不允许修改！", backUrl);
}
else
{
if (recObj.Base.STATUS == WFEnum.RecStatus.NoAccept.ToString("d"))
{
btnOK.Text = "重新提交";
}
WF_FORMBASE valObj = recObj.Base;
#region
txtDEPT_ID.DEPT_NAME = Convert.ToString(valObj.DEPT_NAME);
txtDEPT_ID.DEPT_ID = Convert.ToString(valObj.DEPT_ID);//Convert.ToString
txtSTAFF_ID.Staff_ID = valObj.STAFF_ID;
txtCSTAFF_ID.Value = Convert.ToString(valObj.CSTAFF_ID); //Convert.ToString
txtCSTAFF_NAME.Value = Convert.ToString(valObj.CSTAFF_NAME); //Convert.ToString
txtNOTE.Value = Convert.ToString(valObj.NOTE); //Convert.ToString
#endregion
if (valObj.STAFF_ID != userBase.StaffID &&
valObj.CSTAFF_ID != userBase.StaffID)
{
//不是自己提交的申请不能修改或提交审批
btnSave.Enabled = false;
}
}
UpFilesBfSubmit1.ShowOldFiles(baseVal.ANNEX_FILE);
#endregion
}
else
{
litFormMore.Text = formexd.WF_HtmlEditForm();// WFHtml.ShowMoreFormHtml(wfid, null, ref sbDetail);
hadDetail = formexd.HadSubForm;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
string wran = "";
litWarn.Visible = false;
//值班类型设置
string wdTypeHtml = tbyWorkDayType.InnerHtml;
string[] wdTypeStrs = wdTypeHtml.ToLower().Contains("<tr>") ? wdTypeHtml.ToLower().Substring(wdTypeHtml.ToLower().IndexOf("<tr>")).Split(new string[] { "<tr>" }, StringSplitOptions.RemoveEmptyEntries) : new string[0];
Dictionary <DateTime, int> dicWdType = new Dictionary <DateTime, int>();
foreach (string wdTStr in wdTypeStrs)
{
string[] tds = wdTStr.ToLower().Substring(wdTStr.ToLower().IndexOf("<td>")).Split(new string[] { "<td>" }, StringSplitOptions.RemoveEmptyEntries);
if (tds.Length < 3)
{
continue;
}
DateTime sd = DateTime.MinValue;
DateTime ed = DateTime.MinValue;
int ty = -1;
if (!DateTime.TryParse(tds[0].Remove(tds[0].IndexOf('<'), tds[0].Length - tds[0].IndexOf('<')), out sd) || !DateTime.TryParse(tds[1].Remove(tds[1].IndexOf('<'), tds[1].Length - tds[1].IndexOf('<')), out ed) || !int.TryParse(tds[2].Remove(tds[2].IndexOf('<'), tds[2].Length - tds[2].IndexOf('<')), out ty))
{
continue;
}
sd = sd.Date;
ed = ed.Date;
while (sd <= ed)
{
if (!dicWdType.ContainsKey(sd))
{
dicWdType.Add(sd, ty);
}
else
{
dicWdType[sd] = ty;
}
sd = sd.AddDays(1);
}
}
//休息日设置
string[] weekStr = txtXiuXi.Value.Split(new char[] { ',', '，', ' ', ' ' }, StringSplitOptions.RemoveEmptyEntries);
//是否 周一到周7之间
bool isAllRight = true;
int[] week = new int[weekStr.Length];
for (int i = 0; i < weekStr.Length; i++)
{
if (!int.TryParse(weekStr[i].Replace(" ", ""), out week[i]))
{
isAllRight = false;
}
else if (week[i] < 1 || week[i] > 7)
{
isAllRight = false;
}
}
HR_Scheduling_IniProject proj = new HR_Scheduling_IniProject();
proj.WorkDayType = wdTypeHtml;
proj.XiuXi = txtXiuXi.Value;
proj.ProjectName = txtProjectName.Value;
if (chkFuGai.Checked)
{
proj.FuGaiOrZengBu = 1;
}
else
{
proj.FuGaiOrZengBu = 2;
}
if (isAllRight)
{
string delschWhere = " 1=1 ";
HR_STAFF stfVal = new HR_STAFF();
stfVal.STAFF_ID = 0;
HR_STAFF stfCon = new HR_STAFF();
if (!string.IsNullOrEmpty(hidstaffid.Value.Trim()))
{
stfCon.STAFF_ID = decimal.Parse(hidstaffid.Value);
delschWhere += " and HR_STAFF.STAFF_ID = " + stfCon.STAFF_ID;
proj.StaffID = stfCon.STAFF_ID.ToString();
}
else if (!string.IsNullOrEmpty(hiddeptid.Value.Trim()))
{
stfCon.Like(HR_STAFF.Attribute.DEPT_ID, hiddeptid.Value);
delschWhere += " and HR_STAFF.DEPT_ID like '" + hiddeptid.Value + "%'";
proj.DeptID = stfCon.DEPT_ID;
}
else if (!string.IsNullOrEmpty(hidorgid.Value.Trim()))
{
stfCon.Like(HR_STAFF.Attribute.ORG_ID, hidorgid.Value);
delschWhere += " and HR_STAFF.ORG_ID like '" + hidorgid.Value + "%'";
proj.OrgID = stfCon.ORG_ID;
}
else
{
stfCon.STAFF_ID = userBase.StaffID;
delschWhere += " and HR_STAFF.STAFF_ID = " + userBase.StaffID;
proj.StaffID = stfCon.STAFF_ID.ToString();
}
List <HR_STAFF> stffs = BLLTable <HR_STAFF> .Factory(conn).Select(stfVal, stfCon);
//外部传入选中的班次id
string[] schidstr = hidSelBanciId.Value.TrimEnd(',').Split(',');
proj.SelBanciId = hidSelBanciId.Value;
List <int> schids = new List <int>();
for (int i = 0; i < schidstr.Length; i++)
{
int sid = -1;
if (int.TryParse(schidstr[i], out sid))
{
schids.Add(sid);
}
}
int stfCount = 0;
int stfSch = 0;
//开始时间
DateTime sDate = DateTime.Parse(txtStartTime.Value);
proj.StartTime = sDate;
//结束时间
DateTime eDate = DateTime.Parse(txtEndTime.Value);
proj.EndTime = eDate;
DateTime dt = sDate;
//找出班次
List <HR_Scheduling> schList = new List <HR_Scheduling>();
foreach (HR_STAFF stf in stffs)
{
stfCount++;
dt = sDate;
while (dt.Date <= eDate.Date)
{
foreach (int schid in schids)
{
HR_Scheduling sch = new HR_Scheduling();
sch._SchYear = dt.Date.Year;
sch._SchMonth = Convert.ToInt16(dt.Date.Month);
sch._SchDay = Convert.ToInt16(dt.Date.Day);
sch._STAFF_ID = Convert.ToInt32(stf.STAFF_ID);
sch._SchType = week.Contains(CheckInOutHelper.IndexOfWeekByEnWeek(dt)) ? 3 : 1;
if (dicWdType.ContainsKey(dt.Date))
{
sch._SchType = dicWdType[dt.Date];
}
sch._SchClassid = schid;
schList.Add(sch);
}
dt = dt.AddDays(1);
stfSch++;
}
}
int buildCount = 0;
int delsCount = 0;
if (chkFuGai.Checked)
{
//HR_Scheduling delCon = new HR_Scheduling();
//delCon.Top(1000);
//string wher = " CAST(CAST({0} AS char(4)) + '-' + CAST({1} AS char(2)) + '-' + CAST({2} AS char(2)) as datetime) >= '{3}-{4}-{5}' and CAST(CAST({6} AS char(4)) + '-' + CAST({7} AS char(2)) + '-' + CAST({8} AS char(2)) as datetime) <= '{9}-{10}-{11}' ";
//delCon.Where(wher, HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
// sDate.Year, sDate.Month, sDate.Day,
// HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
// eDate.Year, eDate.Month, eDate.Day);
//Relation rt = new Relation(HR_STAFF.Attribute.STAFF_ID, HR_Scheduling.Attribute.STAFF_ID);
//rt.AddCondition(stfCon);
//while (BLLTable<HR_Scheduling>.Factory(conn).Delete(delCon, rt) > 0)
//{
// continue;
//}
string wher = " delete top(1000) " +
" from HR_Scheduling " +
" where CAST(CAST({0} AS char(4)) + '-' + CAST({1} AS char(2)) + '-' + CAST({2} AS char(2)) as datetime) >= '{3}-{4}-{5}' and CAST(CAST({6} AS char(4)) + '-' + CAST({7} AS char(2)) + '-' + CAST({8} AS char(2)) as datetime) <= '{9}-{10}-{11}' " +
" and HR_Scheduling.staff_id in (select hr_staff.staff_id from hr_staff where " + delschWhere + ")";
wher = string.Format(wher, HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
sDate.Year, sDate.Month, sDate.Day,
HR_Scheduling.Attribute.SchYear, HR_Scheduling.Attribute.SchMonth, HR_Scheduling.Attribute.SchDay,
eDate.Year, eDate.Month, eDate.Day);
int delCount = BLLTable.ExecSQL(new HR_Scheduling(), wher, CommandType.Text);
while (delCount > 0)
{
delsCount += delCount;
delCount = BLLTable.ExecSQL(new HR_Scheduling(), wher, CommandType.Text);
continue;
}
DataTable dataTable = BLLTable <HR_Scheduling> .qDataTable("select * from " + HR_Scheduling.Attribute.SchDay.TableName + " where 1=2");
List <DataRow> dataList = new List <DataRow>();
foreach (HR_Scheduling sch in schList)
{
DataRow dr = dataTable.NewRow();
foreach (DataColumn dc in dataTable.Columns)
{
dr[dc] = sch.GetValue(new AttributeItem(HR_Scheduling.Attribute.STAFF_ID.TableName, dc.ColumnName));
}
dataList.Add(dr);
}
try
{
//将电量数据批量插入数据库
SqlBulkCopy sbc = new SqlBulkCopy(MyConfigurationSettings.GetValue("conn"));
sbc.BatchSize = 1000;
sbc.BulkCopyTimeout = (((dataList.Count) / 1000) + 1) * 3;
sbc.DestinationTableName = HR_Scheduling.Attribute.STAFF_ID.TableName;
sbc.WriteToServer(dataList.ToArray());
buildCount += dataList.Count;
}
catch { }
}
else
{
foreach (HR_Scheduling sch in schList)
{
if (!BLLTable <HR_Scheduling> .Exists(sch))
{
buildCount += BLLTable <HR_Scheduling> .Factory(conn).Insert(sch, HR_Scheduling.Attribute.ID);
}
}
}
int ret2 = BLLTable <HR_Scheduling_IniProject> .Factory(conn).Insert(proj, HR_Scheduling_IniProject.Attribute.ID);
litScript.Text = "<script>alert('生成成功!" + (chkFuGai.Checked ? "覆盖" : "增补") + "生成" + buildCount + "条记录！删除" + delsCount
+ "条记录，保存" + ret2 + "个配置方案"
+ "');$('.main').unmask();</script>";
}
else
{
wran = "休息日输入有误！请参考提示输入。";
}
if (!string.IsNullOrEmpty(wran))
{
litWarn.Text = wran;
litWarn.Visible = true;
litScript.Text = "<script>alert('" + wran + "');$('.main').unmask();</script>";
}
}
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();
}
