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