protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_Scheduling_IniProject>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_Scheduling_IniProject>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_Scheduling_IniProject>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { title = "排班生成管理"; if (Request["staffid"] != null) { hidstaffid.Value = Request["staffid"]; conIni.StaffID = Request["staffid"]; } if (Request["deptid"] != null) { hiddeptid.Value = Request["deptid"]; conIni.DeptID = Request["deptid"]; } if (Request["orgid"] != null) { hidorgid.Value = Request["orgid"]; conIni.OrgID = Request["orgid"]; } if (Request["name"] != null) { title += "--" + System.Uri.UnescapeDataString(Request["name"]); hidname.Value = System.Uri.UnescapeDataString(Request["name"]); } else if (hidname.Value != "") { title += "--" + System.Uri.UnescapeDataString(hidname.Value); } else { title += "--" + userBase.StaffName; } tbyWorkDayType.InnerHtml = System.Uri.UnescapeDataString(hidwdtype.Value); if (!IsPostBack) { DateTime dt = DateTime.Now; txtStartTime.Value = new DateTime(dt.Year, dt.Month, 1).ToString("yyyy-MM-dd"); txtEndTime.Value = new DateTime(dt.Year + 2, dt.Month, 1).ToString("yyyy-MM-dd"); //new DateTime(dt.Year, dt.Month, 1).AddYears(2).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); txtXiuXi.Value = "6,7"; dll_Type.Items.AddRange(FormHelper.GetListItem(HR_Scheduling.Attribute.SchType)); LoadSCH(); //加载配置方案 HR_Scheduling_IniProject val = new HR_Scheduling_IniProject(); val.Top(3); val.OrderBy(HR_Scheduling_IniProject.Attribute.ID, Order.Desc); List <HR_Scheduling_IniProject> listIni = BLLTable <HR_Scheduling_IniProject> .Factory(conn).Select(val, conIni); if (listIni.Count > 0) { rptIniProject.DataSource = listIni; rptIniProject.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP1); //hideTableColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP2); //hideTableColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP1); //hideFindColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP2); //hideFindColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP3); #endregion condObj.OrderBy(HR_Scheduling_IniProject.Attribute.ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { HR_Scheduling_IniProject roleOld = new HR_Scheduling_IniProject(); roleOld.Where(HR_Scheduling_IniProject.Attribute.ID, Request["ids"].ToString()); listObj = BLLTable <HR_Scheduling_IniProject> .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].ID + "',Name:'" + listObj[i].ID + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].ID; } } try { listObj = BLLTable <HR_Scheduling_IniProject> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelID"] != null) { int re = BLLTable <HR_Scheduling_IniProject> .Factory(conn).Delete(HR_Scheduling_IniProject.Attribute.ID, Request["DelID"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { HR_Scheduling_IniProject cond = new HR_Scheduling_IniProject(); cond.In(HR_Scheduling_IniProject.Attribute.ID, Request["DelKeyIDS"]); int re = BLLTable <HR_Scheduling_IniProject> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { HR_Scheduling_IniProject val = new HR_Scheduling_IniProject(); val.ID = 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_Scheduling_IniProject> .Factory(conn).Update(val, HR_Scheduling_IniProject.Attribute.ID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelID"] != null) { int re = BLLTable<HR_Scheduling_IniProject>.Factory(conn).Delete(HR_Scheduling_IniProject.Attribute.ID, Request["DelID"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { HR_Scheduling_IniProject cond = new HR_Scheduling_IniProject(); cond.In(HR_Scheduling_IniProject.Attribute.ID, Request["DelKeyIDS"]); int re = BLLTable<HR_Scheduling_IniProject>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { HR_Scheduling_IniProject val = new HR_Scheduling_IniProject(); val.ID = 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_Scheduling_IniProject>.Factory(conn).Update(val, HR_Scheduling_IniProject.Attribute.ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new HR_Scheduling_IniProject(); if(txtID.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.ID, Convert.ToString(txtID.Value)); if(txtSelBanciId.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.SelBanciId, Convert.ToString(txtSelBanciId.Value)); if(txtXiuXi.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.XiuXi, Convert.ToString(txtXiuXi.Value)); if(txtWorkDayType.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.WorkDayType, Convert.ToString(txtWorkDayType.Value)); if(txtStartTime.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.StartTime, Convert.ToDateTime(txtStartTime.Value)); if(txtEndTime.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.EndTime, Convert.ToDateTime(txtEndTime.Value)); if(txtFuGaiOrZengBu.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.FuGaiOrZengBu, Convert.ToInt32(txtFuGaiOrZengBu.Value)); if(txtStaffID.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.StaffID, Convert.ToString(txtStaffID.Value)); if(txtDeptID.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.DeptID, Convert.ToString(txtDeptID.Value)); if(txtOrgID.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.OrgID, Convert.ToString(txtOrgID.Value)); if(txtProjectName.Value !="" ) condObj.Like_OR(HR_Scheduling_IniProject.Attribute.ProjectName, Convert.ToString(txtProjectName.Value)); try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable<HR_Scheduling_IniProject>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <HR_Scheduling_IniProject>(hidCondition.Value); } listObj = BLLTable <HR_Scheduling_IniProject> .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(HR_Scheduling_IniProject condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(HR_Scheduling_IniProject.Attribute.ID, Order.Desc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable <HR_Scheduling_IniProject> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_Scheduling_IniProject>(hidCondition.Value); } listObj = BLLTable<HR_Scheduling_IniProject>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new HR_Scheduling_IniProject(); if(txtID.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.ID, Convert.ToString(txtID.Value)); if(txtSelBanciId.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.SelBanciId, Convert.ToString(txtSelBanciId.Value)); if(txtXiuXi.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.XiuXi, Convert.ToString(txtXiuXi.Value)); if(txtWorkDayType.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.WorkDayType, Convert.ToString(txtWorkDayType.Value)); if(txtStartTime.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.StartTime, Convert.ToDateTime(txtStartTime.Value)); if(txtEndTime.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.EndTime, Convert.ToDateTime(txtEndTime.Value)); if(txtFuGaiOrZengBu.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.FuGaiOrZengBu, Convert.ToInt32(txtFuGaiOrZengBu.Value)); if(txtStaffID.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.StaffID, Convert.ToString(txtStaffID.Value)); if(txtDeptID.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.DeptID, Convert.ToString(txtDeptID.Value)); if(txtOrgID.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.OrgID, Convert.ToString(txtOrgID.Value)); if(txtProjectName.Value !="" ) condObj.Like(HR_Scheduling_IniProject.Attribute.ProjectName, Convert.ToString(txtProjectName.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<HR_Scheduling_IniProject>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnOK_Click(object sender, EventArgs e) { try { HR_Scheduling_IniProject valObj = new HR_Scheduling_IniProject(); if(txtID.Value !="" ) valObj.ID = Convert.ToString(txtID.Value); if(txtSelBanciId.Value !="" ) valObj.SelBanciId = Convert.ToString(txtSelBanciId.Value); if(txtXiuXi.Value !="" ) valObj.XiuXi = Convert.ToString(txtXiuXi.Value); if(txtWorkDayType.Value !="" ) valObj.WorkDayType = Convert.ToString(txtWorkDayType.Value); if(txtStartTime.Value !="" ) valObj.StartTime = Convert.ToDateTime(txtStartTime.Value); if(txtEndTime.Value !="" ) valObj.EndTime = Convert.ToDateTime(txtEndTime.Value); if(txtFuGaiOrZengBu.Value !="" ) valObj.FuGaiOrZengBu = Convert.ToInt32(txtFuGaiOrZengBu.Value); if(txtStaffID.Value !="" ) valObj.StaffID = Convert.ToString(txtStaffID.Value); if(txtDeptID.Value !="" ) valObj.DeptID = Convert.ToString(txtDeptID.Value); if(txtOrgID.Value !="" ) valObj.OrgID = Convert.ToString(txtOrgID.Value); if(txtProjectName.Value !="" ) valObj.ProjectName = Convert.ToString(txtProjectName.Value); if (keyid != "") { valObj.ID =keyid; count = BLLTable<HR_Scheduling_IniProject>.Factory(conn).Update(valObj, HR_Scheduling_IniProject.Attribute.ID); } else { count = BLLTable<HR_Scheduling_IniProject>.Factory(conn).Insert(valObj, HR_Scheduling_IniProject.Attribute.ID); keyid = valObj.ID.ToString(); } if (count > 0) { StringBuilder sbData = new StringBuilder("{valObj:''"); List<AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valObj.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } sbData.Append("}"); if (ViewState["sbData"] == null) { ViewState["sbData"] = sbData.ToString(); } else { ViewState["sbData"] += ","+sbData.ToString(); } Button btn = (Button)sender; if (btn.ID.IndexOf("btnOK")!=-1) { if (ViewState["sbData"] == null) { string dataStr = "[" + ViewState["sbData"] .ToString()+ "]"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } } else { txtID.Value =""; txtSelBanciId.Value =""; txtXiuXi.Value =""; txtWorkDayType.Value =""; txtStartTime.Value =""; txtEndTime.Value =""; txtFuGaiOrZengBu.Value =""; txtStaffID.Value =""; txtDeptID.Value =""; txtOrgID.Value =""; txtProjectName.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
private void BindList(HR_Scheduling_IniProject condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(HR_Scheduling_IniProject.Attribute.ID, Order.Desc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable<HR_Scheduling_IniProject>.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) { title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["ID"])) { valObj = BLLTable<HR_Scheduling_IniProject>.Factory(conn).GetRowData(HR_Scheduling_IniProject.Attribute.ID, Request["ID"]); if(valObj==null) return ; txtID.Text = Convert.ToString(valObj.ID);//Convert.ToString txtSelBanciId.Text = Convert.ToString(valObj.SelBanciId);//Convert.ToString txtXiuXi.Text = Convert.ToString(valObj.XiuXi);//Convert.ToString txtWorkDayType.Text = Convert.ToString(valObj.WorkDayType);//Convert.ToString txtStartTime.Text = (valObj.StartTime == DateTime.MinValue) ? "" : valObj.StartTime.ToString("yyyy-MM-dd HH:mm"); txtEndTime.Text = (valObj.EndTime == DateTime.MinValue) ? "" : valObj.EndTime.ToString("yyyy-MM-dd HH:mm"); txtFuGaiOrZengBu.Text = Convert.ToString(valObj.FuGaiOrZengBu);//Convert.ToInt32 txtStaffID.Text = Convert.ToString(valObj.StaffID);//Convert.ToString txtDeptID.Text = Convert.ToString(valObj.DeptID);//Convert.ToString txtOrgID.Text = Convert.ToString(valObj.OrgID);//Convert.ToString txtProjectName.Text = Convert.ToString(valObj.ProjectName);//Convert.ToString } } 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) { title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["ID"])) { keyid = Request["ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtStartTime.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtEndTime.Value = (DateTime.Now).ToString("yyyy-MM-dd"); this.txtID.Disabled = true; this.txtID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable <HR_Scheduling_IniProject> .Factory(conn).GetRowData(HR_Scheduling_IniProject.Attribute.ID, keyid); if (valObj == null) { return; } txtID.Value = Convert.ToString(valObj.ID); //Convert.ToString txtSelBanciId.Value = Convert.ToString(valObj.SelBanciId); //Convert.ToString txtXiuXi.Value = Convert.ToString(valObj.XiuXi); //Convert.ToString txtWorkDayType.Value = Convert.ToString(valObj.WorkDayType); //Convert.ToString txtStartTime.Value = (valObj.StartTime == DateTime.MinValue) ? "" : valObj.StartTime.ToString("yyyy-MM-dd"); txtEndTime.Value = (valObj.EndTime == DateTime.MinValue) ? "" : valObj.EndTime.ToString("yyyy-MM-dd"); txtFuGaiOrZengBu.Value = Convert.ToString(valObj.FuGaiOrZengBu); //Convert.ToInt32 txtStaffID.Value = Convert.ToString(valObj.StaffID); //Convert.ToString txtDeptID.Value = Convert.ToString(valObj.DeptID); //Convert.ToString txtOrgID.Value = Convert.ToString(valObj.OrgID); //Convert.ToString txtProjectName.Value = Convert.ToString(valObj.ProjectName); //Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new HR_Scheduling_IniProject(); if (txtID.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.ID, Convert.ToString(txtID.Value)); } if (txtSelBanciId.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.SelBanciId, Convert.ToString(txtSelBanciId.Value)); } if (txtXiuXi.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.XiuXi, Convert.ToString(txtXiuXi.Value)); } if (txtWorkDayType.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.WorkDayType, Convert.ToString(txtWorkDayType.Value)); } if (txtStartTime.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.StartTime, Convert.ToDateTime(txtStartTime.Value)); } if (txtEndTime.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.EndTime, Convert.ToDateTime(txtEndTime.Value)); } if (txtFuGaiOrZengBu.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.FuGaiOrZengBu, Convert.ToInt32(txtFuGaiOrZengBu.Value)); } if (txtStaffID.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.StaffID, Convert.ToString(txtStaffID.Value)); } if (txtDeptID.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.DeptID, Convert.ToString(txtDeptID.Value)); } if (txtOrgID.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.OrgID, Convert.ToString(txtOrgID.Value)); } if (txtProjectName.Value != "") { condObj.Like_OR(HR_Scheduling_IniProject.Attribute.ProjectName, Convert.ToString(txtProjectName.Value)); } try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable <HR_Scheduling_IniProject> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
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) { title = "排班生成管理"; if (Request["staffid"] != null) { hidstaffid.Value = Request["staffid"]; conIni.StaffID = Request["staffid"]; } if (Request["deptid"] != null) { hiddeptid.Value = Request["deptid"]; conIni.DeptID = Request["deptid"]; } if (Request["orgid"] != null) { hidorgid.Value = Request["orgid"]; conIni.OrgID = Request["orgid"]; } if (Request["name"] != null) { title += "--" + System.Uri.UnescapeDataString(Request["name"]); hidname.Value = System.Uri.UnescapeDataString(Request["name"]); } else if (hidname.Value != "") title += "--" + System.Uri.UnescapeDataString(hidname.Value); else title += "--" + userBase.StaffName; tbyWorkDayType.InnerHtml = System.Uri.UnescapeDataString(hidwdtype.Value); if (!IsPostBack) { DateTime dt = DateTime.Now; txtStartTime.Value = new DateTime(dt.Year, dt.Month, 1).ToString("yyyy-MM-dd"); txtEndTime.Value = new DateTime(dt.Year+2, dt.Month, 1).ToString("yyyy-MM-dd"); //new DateTime(dt.Year, dt.Month, 1).AddYears(2).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); txtXiuXi.Value = "6,7"; dll_Type.Items.AddRange(FormHelper.GetListItem(HR_Scheduling.Attribute.SchType)); LoadSCH(); //加载配置方案 HR_Scheduling_IniProject val = new HR_Scheduling_IniProject(); val.Top(3); val.OrderBy(HR_Scheduling_IniProject.Attribute.ID, Order.Desc); List<HR_Scheduling_IniProject> listIni = BLLTable<HR_Scheduling_IniProject>.Factory(conn).Select(val, conIni); if (listIni.Count > 0) { rptIniProject.DataSource = listIni; rptIniProject.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["ID"])) { keyid = Request["ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { txtStartTime.Value = (DateTime.Now).ToString("yyyy-MM-dd"); txtEndTime.Value = (DateTime.Now).ToString("yyyy-MM-dd"); this.txtID.Disabled = true; this.txtID.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable<HR_Scheduling_IniProject>.Factory(conn).GetRowData(HR_Scheduling_IniProject.Attribute.ID, keyid); if(valObj==null) return ; txtID.Value = Convert.ToString(valObj.ID);//Convert.ToString txtSelBanciId.Value = Convert.ToString(valObj.SelBanciId);//Convert.ToString txtXiuXi.Value = Convert.ToString(valObj.XiuXi);//Convert.ToString txtWorkDayType.Value = Convert.ToString(valObj.WorkDayType);//Convert.ToString txtStartTime.Value = (valObj.StartTime == DateTime.MinValue) ? "" : valObj.StartTime.ToString("yyyy-MM-dd"); txtEndTime.Value = (valObj.EndTime == DateTime.MinValue) ? "" : valObj.EndTime.ToString("yyyy-MM-dd"); txtFuGaiOrZengBu.Value = Convert.ToString(valObj.FuGaiOrZengBu);//Convert.ToInt32 txtStaffID.Value = Convert.ToString(valObj.StaffID);//Convert.ToString txtDeptID.Value = Convert.ToString(valObj.DeptID);//Convert.ToString txtOrgID.Value = Convert.ToString(valObj.OrgID);//Convert.ToString txtProjectName.Value = Convert.ToString(valObj.ProjectName);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnOK_Click(object sender, EventArgs e) { try { HR_Scheduling_IniProject valObj = new HR_Scheduling_IniProject(); if (txtID.Value != "") { valObj.ID = Convert.ToString(txtID.Value); } if (txtSelBanciId.Value != "") { valObj.SelBanciId = Convert.ToString(txtSelBanciId.Value); } if (txtXiuXi.Value != "") { valObj.XiuXi = Convert.ToString(txtXiuXi.Value); } if (txtWorkDayType.Value != "") { valObj.WorkDayType = Convert.ToString(txtWorkDayType.Value); } if (txtStartTime.Value != "") { valObj.StartTime = Convert.ToDateTime(txtStartTime.Value); } if (txtEndTime.Value != "") { valObj.EndTime = Convert.ToDateTime(txtEndTime.Value); } if (txtFuGaiOrZengBu.Value != "") { valObj.FuGaiOrZengBu = Convert.ToInt32(txtFuGaiOrZengBu.Value); } if (txtStaffID.Value != "") { valObj.StaffID = Convert.ToString(txtStaffID.Value); } if (txtDeptID.Value != "") { valObj.DeptID = Convert.ToString(txtDeptID.Value); } if (txtOrgID.Value != "") { valObj.OrgID = Convert.ToString(txtOrgID.Value); } if (txtProjectName.Value != "") { valObj.ProjectName = Convert.ToString(txtProjectName.Value); } if (keyid != "") { valObj.ID = keyid; count = BLLTable <HR_Scheduling_IniProject> .Factory(conn).Update(valObj, HR_Scheduling_IniProject.Attribute.ID); } else { count = BLLTable <HR_Scheduling_IniProject> .Factory(conn).Insert(valObj, HR_Scheduling_IniProject.Attribute.ID); keyid = valObj.ID.ToString(); } if (count > 0) { StringBuilder sbData = new StringBuilder("{valObj:''"); List <AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { object val = valObj.GetValue(lstCol[i]); if (val != null) { sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'"); } } sbData.Append("}"); if (ViewState["sbData"] == null) { ViewState["sbData"] = sbData.ToString(); } else { ViewState["sbData"] += "," + sbData.ToString(); } Button btn = (Button)sender; if (btn.ID.IndexOf("btnOK") != -1) { if (ViewState["sbData"] == null) { string dataStr = "[" + ViewState["sbData"].ToString() + "]"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true); } } else { txtID.Value = ""; txtSelBanciId.Value = ""; txtXiuXi.Value = ""; txtWorkDayType.Value = ""; txtStartTime.Value = ""; txtEndTime.Value = ""; txtFuGaiOrZengBu.Value = ""; txtStaffID.Value = ""; txtDeptID.Value = ""; txtOrgID.Value = ""; txtProjectName.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP1); //hideTableColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP2); //hideTableColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP1); //hideFindColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP2); //hideFindColumnList.Add(HR_Scheduling_IniProject.Attribute.EXP3); #endregion condObj.OrderBy(HR_Scheduling_IniProject.Attribute.ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { HR_Scheduling_IniProject roleOld = new HR_Scheduling_IniProject(); roleOld.Where(HR_Scheduling_IniProject.Attribute.ID, Request["ids"].ToString()); listObj = BLLTable<HR_Scheduling_IniProject>.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].ID + "',Name:'" + listObj[i].ID + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].ID; } } try { listObj = BLLTable<HR_Scheduling_IniProject>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new HR_Scheduling_IniProject(); if (txtID.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.ID, Convert.ToString(txtID.Value)); } if (txtSelBanciId.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.SelBanciId, Convert.ToString(txtSelBanciId.Value)); } if (txtXiuXi.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.XiuXi, Convert.ToString(txtXiuXi.Value)); } if (txtWorkDayType.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.WorkDayType, Convert.ToString(txtWorkDayType.Value)); } if (txtStartTime.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.StartTime, Convert.ToDateTime(txtStartTime.Value)); } if (txtEndTime.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.EndTime, Convert.ToDateTime(txtEndTime.Value)); } if (txtFuGaiOrZengBu.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.FuGaiOrZengBu, Convert.ToInt32(txtFuGaiOrZengBu.Value)); } if (txtStaffID.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.StaffID, Convert.ToString(txtStaffID.Value)); } if (txtDeptID.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.DeptID, Convert.ToString(txtDeptID.Value)); } if (txtOrgID.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.OrgID, Convert.ToString(txtOrgID.Value)); } if (txtProjectName.Value != "") { condObj.Like(HR_Scheduling_IniProject.Attribute.ProjectName, Convert.ToString(txtProjectName.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
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) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["ID"])) { valObj = BLLTable <HR_Scheduling_IniProject> .Factory(conn).GetRowData(HR_Scheduling_IniProject.Attribute.ID, Request["ID"]); if (valObj == null) { return; } txtID.Text = Convert.ToString(valObj.ID);//Convert.ToString txtSelBanciId.Text = Convert.ToString(valObj.SelBanciId);//Convert.ToString txtXiuXi.Text = Convert.ToString(valObj.XiuXi);//Convert.ToString txtWorkDayType.Text = Convert.ToString(valObj.WorkDayType);//Convert.ToString txtStartTime.Text = (valObj.StartTime == DateTime.MinValue) ? "" : valObj.StartTime.ToString("yyyy-MM-dd HH:mm"); txtEndTime.Text = (valObj.EndTime == DateTime.MinValue) ? "" : valObj.EndTime.ToString("yyyy-MM-dd HH:mm"); txtFuGaiOrZengBu.Text = Convert.ToString(valObj.FuGaiOrZengBu);//Convert.ToInt32 txtStaffID.Text = Convert.ToString(valObj.StaffID);//Convert.ToString txtDeptID.Text = Convert.ToString(valObj.DeptID);//Convert.ToString txtOrgID.Text = Convert.ToString(valObj.OrgID);//Convert.ToString txtProjectName.Text = Convert.ToString(valObj.ProjectName);//Convert.ToString } } 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(); } } }