protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new V_SchedulingSchClass();
if (wucSelStaff1.Staff_ID > 0)
{
condObj.STAFF_ID = (int)wucSelStaff1.Staff_ID;
}
if (dll_Year.SelectedIndex >= 1)
{
condObj._SchYear = Convert.ToInt32(dll_Year.Text);
}
if (dll_Month.SelectedIndex >= 1)
{
condObj.SchMonth = Convert.ToInt16(dll_Month.Text);
}
if (dll_Day.SelectedIndex >= 1)
{
condObj.SchDay = Convert.ToInt16(dll_Day.Text);
}
if (dll_Type.SelectedIndex >= 1)
{
condObj.SchType = Convert.ToInt16(dll_Type.SelectedValue);
}
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchDay, Order.Asc);
BindList(condObj);
}
protected void dll_SelectedIndexChanged(object sender, EventArgs e)
{
if (!IsPostBack)
{
return;
}
if (ischange)
{
return;
}
ischange = true;
DropDownList dll = sender as DropDownList;
if (dll == null)
{
return;
}
condObj = new V_SchedulingSchClass();
condObj.SchYear = Convert.ToInt32(dll_Year.Text);
if (dll_Month.SelectedIndex >= 1)
{
condObj.SchMonth = Convert.ToInt16(dll_Month.Text);
}
if (dll.ID == "dll_Year" || dll.ID == "dll_Month")
{
int index = dll_Day.SelectedIndex;
DateTime ddt = new DateTime(condObj.SchYear, condObj.SchMonth < 1 ? 1 : (condObj.SchMonth > 12 ? 12 : condObj.SchMonth), 1);
dll_Day.Items.Clear();
dll_Day.Items.Add(new ListItem("未选择", "0"));
int maxDay = 0;
int mon = ddt.Month;
while (ddt.Month == mon)
{
dll_Day.Items.Add(new ListItem(ddt.Day.ToString(), ddt.Day.ToString()));
ddt = ddt.AddDays(1);
maxDay++;
}
if (index > maxDay)
{
dll_Day.SelectedIndex = maxDay;
}
else
{
dll_Day.SelectedIndex = index;
}
}
if (dll_Day.SelectedIndex >= 1)
{
condObj.SchDay = Convert.ToInt16(dll_Day.Text);
}
if (dll_Type.SelectedIndex >= 1)
{
condObj.SchType = Convert.ToInt16(dll_Type.SelectedValue);
}
BindList(condObj);
ischange = false;
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelSchName"] != null)
{
int re = BLLTable <V_SchedulingSchClass> .Factory(conn).Delete(V_SchedulingSchClass.Attribute.SchName, Request["DelSchName"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
V_SchedulingSchClass cond = new V_SchedulingSchClass();
cond.In(V_SchedulingSchClass.Attribute.SchName, Request["DelKeyIDS"]);
int re = BLLTable <V_SchedulingSchClass> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
V_SchedulingSchClass val = new V_SchedulingSchClass();
val.SchName = 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 <V_SchedulingSchClass> .Factory(conn).Update(val, V_SchedulingSchClass.Attribute.SchName);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
#endregion
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchName, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
V_SchedulingSchClass roleOld = new V_SchedulingSchClass();
roleOld.Where(V_SchedulingSchClass.Attribute.SchName, Request["ids"].ToString());
listObj = BLLTable <V_SchedulingSchClass> .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].SchName + "',Name:'" + listObj[i].SchName + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].SchName;
}
}
try
{
listObj = BLLTable <V_SchedulingSchClass> .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["DelSchName"] != null)
{
int re = BLLTable<V_SchedulingSchClass>.Factory(conn).Delete(V_SchedulingSchClass.Attribute.SchName, Request["DelSchName"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
V_SchedulingSchClass cond = new V_SchedulingSchClass();
cond.In(V_SchedulingSchClass.Attribute.SchName, Request["DelKeyIDS"]);
int re = BLLTable<V_SchedulingSchClass>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
V_SchedulingSchClass val = new V_SchedulingSchClass();
val.SchName = 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<V_SchedulingSchClass>.Factory(conn).Update(val, V_SchedulingSchClass.Attribute.SchName);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void btnReset_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
dll_Year.Text = dt.Year.ToString();
dll_Month.Text = dt.Month.ToString();
dll_Type.SelectedIndex = 0;
dll_Day.SelectedIndex = 0;
wucSelStaff1.Staff_NAME = "";
wucSelStaff1.Staff_ID = 0;
condObj = new V_SchedulingSchClass();
condObj._SchYear = Convert.ToInt32(dll_Year.Text);
condObj._SchMonth = Convert.ToInt16(dll_Month.Text);
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchDay, Order.Asc);
BindList(condObj);
}
protected void btnReset_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.Now;
dll_Year.Text = dt.Year.ToString();
dll_Month.Text = dt.Month.ToString();
dll_Type.SelectedIndex = 0;
dll_Day.SelectedIndex = 0;
wucSelStaff1.Staff_NAME = "";
wucSelStaff1.Staff_ID = 0;
condObj = new V_SchedulingSchClass();
condObj._SchYear = Convert.ToInt32(dll_Year.Text);
condObj._SchMonth = Convert.ToInt16(dll_Month.Text);
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchDay, Order.Asc);
BindList(condObj);
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new V_SchedulingSchClass();
if (wucSelStaff1.Staff_ID > 0)
condObj.STAFF_ID = (int)wucSelStaff1.Staff_ID;
if(dll_Year.SelectedIndex >= 1)
condObj._SchYear = Convert.ToInt32(dll_Year.Text);
if (dll_Month.SelectedIndex >= 1)
condObj.SchMonth = Convert.ToInt16(dll_Month.Text);
if (dll_Day.SelectedIndex >= 1)
condObj.SchDay = Convert.ToInt16(dll_Day.Text);
if (dll_Type.SelectedIndex >= 1)
condObj.SchType = Convert.ToInt16(dll_Type.SelectedValue);
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchDay, Order.Asc);
BindList(condObj);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <V_SchedulingSchClass>(hidCondition.Value);
}
listObj = BLLTable <V_SchedulingSchClass> .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<V_SchedulingSchClass>(hidCondition.Value);
}
listObj = BLLTable<V_SchedulingSchClass>.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(V_SchedulingSchClass condObj)
{
List<V_SchedulingSchClass> vssList = BLLTable<V_SchedulingSchClass>.Factory(conn).Select(new V_SchedulingSchClass(), condObj);
DataTable data = GetWorkViewHeadTable();
repHead.DataSource = data.Columns;
repHead.DataBind();
Dictionary<string, DataRow> dic = new Dictionary<string, DataRow>();
Dictionary<string, int> rigDic = new Dictionary<string, int>();
data = GetWorkViewBodyTable();
DateTime nowDt = DateTime.Now;
foreach (V_SchedulingSchClass vs in vssList)
{
string date = vs._SchYear + "-" + vs._SchMonth.ToString().PadLeft(2, '0') + "-" + vs._SchDay.ToString().PadLeft(2, '0');
if (!dic.ContainsKey(date))
dic.Add(date, data.NewRow());
if (!rigDic.ContainsKey(date))
rigDic.Add(date, 0);
DateTime curDate = new DateTime(vs._SchYear, vs._SchMonth, vs._SchDay);
dic[date][0] = vs.STAFF_ID + spl;
dic[date][1] = vs.STAFF_NAME + spl;
dic[date][2] = date + spl + (curDate == new DateTime(nowDt.Year, nowDt.Month, nowDt.Day) ? "style='background-color:#eeeeaa;'" : "");
dic[date][3] = CheckInOutHelper.ChineseByEnWeek(curDate) + spl + " style='text-align:center;text-indent:0px;'";
dic[date][4] = dll_Type.Items[vs._SchType].Text + spl;
DateTime otime = new DateTime(nowDt.Year, nowDt.Month, nowDt.Day, 0, 0, 0);
DateTime stime = new DateTime(nowDt.Year, nowDt.Month, nowDt.Day, vs.StartHour, vs.StartMin, 0);
DateTime etime = new DateTime(nowDt.Year, nowDt.Month, nowDt.Day, vs.EndHour, vs.EndMin, 0);
int left = ((int)((stime - otime).TotalMinutes / 2.00 + 0.5));
int wid = ((int)((etime - stime).TotalMinutes / 2.00 + 0.5)) - 1;
left = left - rigDic[date];
rigDic[date] = ((int)((stime - otime).TotalMinutes / 2 + 0.5)) + wid + 3;
string sty = "style='float:left;clear:right;display:inline-block;margin-left:" + left + "px; width:" + wid + "px;height:20px; background-color:" + vs.Color + "'";
string tit = "tag='";
tit += "�������:" + vs.SchName + "<br />";
tit += "ʱ��:" + vs.StartHour + ":" + vs.StartMin + "-" + vs.EndHour + ":" + vs.EndMin + "<br />";
tit += "������ֵ:" + vs.SchNumber + "<br />";
tit += "��ֵ��λ:" + formhelper.GetOptionText(HR_SchClass.Attribute.SchUnit, vs.SchUnit) + "<br />";
tit += "�Ƿ����Ϊ�Ӱ�:" + (vs.IsOverTime ? "��" : "��") + "<br />";
tit += "ǩ��ʱ��:" + (!vs.CheckIn?"��ǩ��":(vs.CheckInHour1 + ":" + vs.CheckInMin1 + "-" + vs.CheckInHour2 + ":" + vs.CheckInMin2)) + "<br />";
tit += "ǩ��ʱ��:" + (!vs.CheckOut ? "��ǩ��" : (vs.CheckOutHour1 + ":" + vs.CheckOutMin1 + "-" + vs.CheckOutHour2 + ":" + vs.CheckOutMin2)) + "<br />";
tit += "�Ƴٵ�/���˷�����:" + vs.LateMinutes + "/" + vs.EarlyMinutes + "<br />";
tit += "'";
string a = "<a " + tit + " " + sty + " onmousemove='showatooltip(\"tableatooltip\",this)' onmouseout='hideatooltip(\"tableatooltip\")'></a>";
dic[date][5] += a;
}
foreach (string vs in dic.Keys)
{
dic[vs][5] += spl + " colspan='24' style='text-indent:0px;' ";
data.Rows.Add(dic[vs]);
}
repList.DataSource = data.Rows;
repList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
#endregion
title = "排版管理";
repHead.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
repList.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
Page.Title = title;
if (Request["PID"] != null)
{
pid = Request["PID"];
}
if (!IsPostBack)
{
#region//默认属性初始化
dll_Year.Items.Clear();
dll_Month.Items.Clear();
dll_Day.Items.Clear();
DateTime dt = DateTime.Now;
for (int y = dt.Year - 25; y < dt.Year + 25; y++)
{
dll_Year.Items.Add(new ListItem(y.ToString(), y.ToString()));
}
dll_Year.Text = dt.Year.ToString();
dll_Month.Items.Add(new ListItem("未选择", "0"));
for (int y = 1; y < 13; y++)
{
dll_Month.Items.Add(new ListItem(y.ToString(), y.ToString()));
}
dll_Month.Text = dt.Month.ToString();
DateTime ddt = new DateTime(dt.Year, dt.Month, 1);
dll_Day.Items.Add(new ListItem("未选择", "0"));
while (ddt.Month == dt.Month)
{
dll_Day.Items.Add(new ListItem(ddt.Day.ToString(), ddt.Day.ToString()));
ddt = ddt.AddDays(1);
}
//dll_Day.Text = dt.Day.ToString();
dll_Type.Items.AddRange(FormHelper.GetListItem(HR_Scheduling.Attribute.SchType));
#endregion
#region//数据初始化
#endregion
condObj = new V_SchedulingSchClass();
condObj._SchYear = Convert.ToInt32(dll_Year.Text);
condObj._SchMonth = Convert.ToInt16(dll_Month.Text);
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchDay, Order.Asc);
BindList(condObj);
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
#endregion
title = "�����";
repHead.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
repList.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
Page.Title = title;
if (Request["PID"] != null)
{
pid = Request["PID"];
}
if (!IsPostBack)
{
#region//Ĭ�����Գ�ʼ��
dll_Year.Items.Clear();
dll_Month.Items.Clear();
dll_Day.Items.Clear();
DateTime dt = DateTime.Now;
for (int y = dt.Year - 25; y < dt.Year + 25; y++)
{
dll_Year.Items.Add(new ListItem(y.ToString(), y.ToString()));
}
dll_Year.Text = dt.Year.ToString();
dll_Month.Items.Add(new ListItem("δѡ��", "0"));
for (int y = 1; y < 13; y++)
{
dll_Month.Items.Add(new ListItem(y.ToString(), y.ToString()));
}
dll_Month.Text = dt.Month.ToString();
DateTime ddt = new DateTime(dt.Year, dt.Month, 1);
dll_Day.Items.Add(new ListItem("δѡ��", "0"));
while (ddt.Month == dt.Month)
{
dll_Day.Items.Add(new ListItem(ddt.Day.ToString(), ddt.Day.ToString()));
ddt = ddt.AddDays(1);
}
//dll_Day.Text = dt.Day.ToString();
dll_Type.Items.AddRange(FormHelper.GetListItem(HR_Scheduling.Attribute.SchType));
#endregion
#region//���ݳ�ʼ��
#endregion
condObj = new V_SchedulingSchClass();
condObj._SchYear = Convert.ToInt32(dll_Year.Text);
condObj._SchMonth = Convert.ToInt16(dll_Month.Text);
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchDay, Order.Asc);
BindList(condObj);
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "��ϸ";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["SchName"]))
{
valObj = BLLTable<V_SchedulingSchClass>.Factory(conn).GetRowData(V_SchedulingSchClass.Attribute.SchName, Request["SchName"]);
if(valObj==null) return ;
txtSchName.Text = Convert.ToString(valObj.SchName);//Convert.ToString
txtLateMinutes.Text = Convert.ToString(valObj.LateMinutes);//Convert.ToInt32
txtEarlyMinutes.Text = Convert.ToString(valObj.EarlyMinutes);//Convert.ToInt32
txtCheckIn.Checked = valObj.CheckIn;
txtCheckOut.Checked = valObj.CheckOut;
txtColor.Text = Convert.ToString(valObj.Color);//Convert.ToInt32
txtIsOvertime.Checked = valObj.IsOverTime;
txtYear.Text = Convert.ToString(valObj.SchYear);//Convert.ToInt32
txtMonth.Text = Convert.ToString(valObj.SchMonth);//Convert.ToInt16
txtDay.Text = Convert.ToString(valObj.SchDay);//Convert.ToInt16
txtType.Text = Convert.ToString(valObj.SchType);//Convert.ToInt32
txtSchClassid.Text = Convert.ToString(valObj.SchClassid);//Convert.ToInt32
txtStartHour.Text = Convert.ToString(valObj.StartHour);//Convert.ToInt32
txtStartMin.Text = Convert.ToString(valObj.StartMin);//Convert.ToInt32
txtEndHour.Text = Convert.ToString(valObj.EndHour);//Convert.ToInt32
txtEndMin.Text = Convert.ToString(valObj.EndMin);//Convert.ToInt32
txtCheckInHour1.Text = Convert.ToString(valObj.CheckInHour1);//Convert.ToInt32
txtCheckInMin1.Text = Convert.ToString(valObj.CheckInMin1);//Convert.ToInt32
txtCheckInHour2.Text = Convert.ToString(valObj.CheckInHour2);//Convert.ToInt32
txtCheckInMin2.Text = Convert.ToString(valObj.CheckInMin2);//Convert.ToInt32
txtCheckOutHour1.Text = Convert.ToString(valObj.CheckOutHour1);//Convert.ToInt32
txtCheckOutMin1.Text = Convert.ToString(valObj.CheckOutMin1);//Convert.ToInt32
txtCheckOutMin2.Text = Convert.ToString(valObj.CheckOutMin2);//Convert.ToInt32
txtCheckOutHour2.Text = Convert.ToString(valObj.CheckOutHour2);//Convert.ToInt32
}
}
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 Dictionary <DateTime, List <V_SchedulingSchClass> > GetScheduling(DateTime startTime, DateTime endTime, int type)
{
Dictionary <DateTime, List <V_SchedulingSchClass> > vsDic = new Dictionary <DateTime, List <V_SchedulingSchClass> >();
Dictionary <DateTime, List <int> > vsidDic = new Dictionary <DateTime, List <int> >();
V_SchedulingSchClass val = new V_SchedulingSchClass();
val.SchYear = 0;
val.SchMonth = 0;
val.SchDay = 0;
val.SchClassid = 0;
val.SchType = 0;
val.SchName = ""; //(50) Unchecked
val.StartHour = 0; // Unchecked
val.StartMin = 0; // Unchecked
val.EndHour = 0; // Unchecked
val.EndMin = 0; // Unchecked
val.LateMinutes = 0; // Checked
val.EarlyMinutes = 0; // Checked
val.CheckIn = false; // Checked
val.CheckOut = false; // Checked
val.CheckInHour1 = 0; // Checked
val.CheckInMin1 = 0; // Checked
val.CheckInHour2 = 0; // Checked
val.CheckInMin2 = 0; // Checked
val.CheckOutHour1 = 0; // Checked
val.CheckOutMin1 = 0; // Checked
val.CheckOutHour2 = 0; // Checked
val.CheckOutMin2 = 0; // Checked
val.Color = ""; //(10) Checked
val.IsOverTime = false; // Unchecked
val.SchNumber = 0; // Unchecked
val.SchUnit = 0; // Unchecked
V_SchedulingSchClass con = new V_SchedulingSchClass();
if (type > 0)
{
con.SchType = type;
}
int staffidd = -1;
if (staffid.Trim() != "" && int.TryParse(staffid, out staffidd))
{
con.STAFF_ID = staffidd;
}
else if (deptid.Trim() != "")
{
con.Like(V_SchedulingSchClass.Attribute.DEPT_ID, deptid);
}
else if (orgid.Trim() != "")
{
con.Like(V_SchedulingSchClass.Attribute.ORG_ID, orgid);
}
else
{
con.STAFF_ID = (int)userBase.StaffID;
}
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}' ";
con.Where(wher, V_SchedulingSchClass.Attribute.SchYear, V_SchedulingSchClass.Attribute.SchMonth, V_SchedulingSchClass.Attribute.SchDay,
startTime.Year, startTime.Month, startTime.Day,
V_SchedulingSchClass.Attribute.SchYear, V_SchedulingSchClass.Attribute.SchMonth, V_SchedulingSchClass.Attribute.SchDay,
endTime.Year, endTime.Month, endTime.Day);
val.Distinct = true;
con.Distinct = true;
con.OrderBy(new List <OrderByItem>(new OrderByItem[] {
new OrderByItem(V_SchedulingSchClass.Attribute.StartHour, Order.Asc),
new OrderByItem(V_SchedulingSchClass.Attribute.StartMin, Order.Asc),
new OrderByItem(V_SchedulingSchClass.Attribute.EndHour, Order.Asc),
new OrderByItem(V_SchedulingSchClass.Attribute.EndMin, Order.Asc)
}));
List <V_SchedulingSchClass> vsList = BLLTable <V_SchedulingSchClass> .Factory(conn).Select(val, con);
foreach (V_SchedulingSchClass vs in vsList)
{
DateTime date = new DateTime(vs.SchYear, vs.SchMonth, vs.SchDay);
if (!vsDic.ContainsKey(date))
{
vsDic.Add(date, new List <V_SchedulingSchClass>());
}
if (!vsidDic.ContainsKey(date))
{
vsidDic.Add(date, new List <int>());
}
if (!vsidDic[date].Contains(vs.SchClassid))
{
vsidDic[date].Add(vs.SchClassid);
vsDic[date].Add(vs);
}
}
return(vsDic);
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["SchName"]))
{
valObj = BLLTable <V_SchedulingSchClass> .Factory(conn).GetRowData(V_SchedulingSchClass.Attribute.SchName, Request["SchName"]);
if (valObj == null)
{
return;
}
txtSchName.Text = Convert.ToString(valObj.SchName);//Convert.ToString
txtLateMinutes.Text = Convert.ToString(valObj.LateMinutes);//Convert.ToInt32
txtEarlyMinutes.Text = Convert.ToString(valObj.EarlyMinutes);//Convert.ToInt32
txtCheckIn.Checked = valObj.CheckIn;
txtCheckOut.Checked = valObj.CheckOut;
txtColor.Text = Convert.ToString(valObj.Color);//Convert.ToInt32
txtIsOvertime.Checked = valObj.IsOverTime;
txtYear.Text = Convert.ToString(valObj.SchYear);//Convert.ToInt32
txtMonth.Text = Convert.ToString(valObj.SchMonth);//Convert.ToInt16
txtDay.Text = Convert.ToString(valObj.SchDay);//Convert.ToInt16
txtType.Text = Convert.ToString(valObj.SchType);//Convert.ToInt32
txtSchClassid.Text = Convert.ToString(valObj.SchClassid);//Convert.ToInt32
txtStartHour.Text = Convert.ToString(valObj.StartHour);//Convert.ToInt32
txtStartMin.Text = Convert.ToString(valObj.StartMin);//Convert.ToInt32
txtEndHour.Text = Convert.ToString(valObj.EndHour);//Convert.ToInt32
txtEndMin.Text = Convert.ToString(valObj.EndMin);//Convert.ToInt32
txtCheckInHour1.Text = Convert.ToString(valObj.CheckInHour1);//Convert.ToInt32
txtCheckInMin1.Text = Convert.ToString(valObj.CheckInMin1);//Convert.ToInt32
txtCheckInHour2.Text = Convert.ToString(valObj.CheckInHour2);//Convert.ToInt32
txtCheckInMin2.Text = Convert.ToString(valObj.CheckInMin2);//Convert.ToInt32
txtCheckOutHour1.Text = Convert.ToString(valObj.CheckOutHour1);//Convert.ToInt32
txtCheckOutMin1.Text = Convert.ToString(valObj.CheckOutMin1);//Convert.ToInt32
txtCheckOutMin2.Text = Convert.ToString(valObj.CheckOutMin2);//Convert.ToInt32
txtCheckOutHour2.Text = Convert.ToString(valObj.CheckOutHour2);//Convert.ToInt32
}
}
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 btnOK_Click(object sender, EventArgs e)
{
try
{
V_SchedulingSchClass valObj = new V_SchedulingSchClass();
if(txtSchName.Value !="" )
valObj.SchName = Convert.ToString(txtSchName.Value);
if(txtLateMinutes.Value !="" )
valObj.LateMinutes = Convert.ToInt32(txtLateMinutes.Value);
if(txtEarlyMinutes.Value !="" )
valObj.EarlyMinutes = Convert.ToInt32(txtEarlyMinutes.Value);
valObj.CheckIn = Convert.ToBoolean(txtCheckIn.Checked);
valObj.CheckOut = Convert.ToBoolean(txtCheckOut.Checked);
if(txtColor.Value !="" )
valObj.Color = Convert.ToString(txtColor.Value);
valObj.IsOverTime = Convert.ToBoolean(txtIsOvertime.Checked);
if(txtYear.Value !="" )
valObj.SchYear = Convert.ToInt32(txtYear.Value);
if(txtMonth.Value !="" )
valObj.SchMonth = Convert.ToInt16(txtMonth.Value);
if(txtDay.Value !="" )
valObj.SchDay = Convert.ToInt16(txtDay.Value);
if(txtType.Value !="" )
valObj.SchType = Convert.ToInt32(txtType.Value);
if(txtSchClassid.Value !="" )
valObj.SchClassid = Convert.ToInt32(txtSchClassid.Value);
if(txtStartHour.Value !="" )
valObj.StartHour = Convert.ToInt32(txtStartHour.Value);
if(txtStartMin.Value !="" )
valObj.StartMin = Convert.ToInt32(txtStartMin.Value);
if(txtEndHour.Value !="" )
valObj.EndHour = Convert.ToInt32(txtEndHour.Value);
if(txtEndMin.Value !="" )
valObj.EndMin = Convert.ToInt32(txtEndMin.Value);
if(txtCheckInHour1.Value !="" )
valObj.CheckInHour1 = Convert.ToInt32(txtCheckInHour1.Value);
if(txtCheckInMin1.Value !="" )
valObj.CheckInMin1 = Convert.ToInt32(txtCheckInMin1.Value);
if(txtCheckInHour2.Value !="" )
valObj.CheckInHour2 = Convert.ToInt32(txtCheckInHour2.Value);
if(txtCheckInMin2.Value !="" )
valObj.CheckInMin2 = Convert.ToInt32(txtCheckInMin2.Value);
if(txtCheckOutHour1.Value !="" )
valObj.CheckOutHour1 = Convert.ToInt32(txtCheckOutHour1.Value);
if(txtCheckOutMin1.Value !="" )
valObj.CheckOutMin1 = Convert.ToInt32(txtCheckOutMin1.Value);
if(txtCheckOutMin2.Value !="" )
valObj.CheckOutMin2 = Convert.ToInt32(txtCheckOutMin2.Value);
if(txtCheckOutHour2.Value !="" )
valObj.CheckOutHour2 = Convert.ToInt32(txtCheckOutHour2.Value);
if (keyid != "")
{
valObj.SchName = Convert.ToString(keyid);
count = BLLTable<V_SchedulingSchClass>.Factory(conn).Update(valObj, V_SchedulingSchClass.Attribute.SchName);
}
else
{
count = BLLTable<V_SchedulingSchClass>.Factory(conn).Insert(valObj, V_SchedulingSchClass.Attribute.SchName);
keyid = valObj.SchName.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("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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
{
txtSchName.Value ="";
txtLateMinutes.Value ="";
txtEarlyMinutes.Value ="";
txtCheckIn.Checked=false;
txtCheckOut.Checked=false;
txtColor.Value ="";
txtIsOvertime.Checked=false;
txtYear.Value ="";
txtMonth.Value ="";
txtDay.Value ="";
txtType.Value ="";
txtSchClassid.Value ="";
txtStartHour.Value ="";
txtStartMin.Value ="";
txtEndHour.Value ="";
txtEndMin.Value ="";
txtCheckInHour1.Value ="";
txtCheckInMin1.Value ="";
txtCheckInHour2.Value ="";
txtCheckInMin2.Value ="";
txtCheckOutHour1.Value ="";
txtCheckOutMin1.Value ="";
txtCheckOutMin2.Value ="";
txtCheckOutHour2.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
V_SchedulingSchClass valObj = new V_SchedulingSchClass();
if (txtSchName.Value != "")
{
valObj.SchName = Convert.ToString(txtSchName.Value);
}
if (txtLateMinutes.Value != "")
{
valObj.LateMinutes = Convert.ToInt32(txtLateMinutes.Value);
}
if (txtEarlyMinutes.Value != "")
{
valObj.EarlyMinutes = Convert.ToInt32(txtEarlyMinutes.Value);
}
valObj.CheckIn = Convert.ToBoolean(txtCheckIn.Checked);
valObj.CheckOut = Convert.ToBoolean(txtCheckOut.Checked);
if (txtColor.Value != "")
{
valObj.Color = Convert.ToString(txtColor.Value);
}
valObj.IsOverTime = Convert.ToBoolean(txtIsOvertime.Checked);
if (txtYear.Value != "")
{
valObj.SchYear = Convert.ToInt32(txtYear.Value);
}
if (txtMonth.Value != "")
{
valObj.SchMonth = Convert.ToInt16(txtMonth.Value);
}
if (txtDay.Value != "")
{
valObj.SchDay = Convert.ToInt16(txtDay.Value);
}
if (txtType.Value != "")
{
valObj.SchType = Convert.ToInt32(txtType.Value);
}
if (txtSchClassid.Value != "")
{
valObj.SchClassid = Convert.ToInt32(txtSchClassid.Value);
}
if (txtStartHour.Value != "")
{
valObj.StartHour = Convert.ToInt32(txtStartHour.Value);
}
if (txtStartMin.Value != "")
{
valObj.StartMin = Convert.ToInt32(txtStartMin.Value);
}
if (txtEndHour.Value != "")
{
valObj.EndHour = Convert.ToInt32(txtEndHour.Value);
}
if (txtEndMin.Value != "")
{
valObj.EndMin = Convert.ToInt32(txtEndMin.Value);
}
if (txtCheckInHour1.Value != "")
{
valObj.CheckInHour1 = Convert.ToInt32(txtCheckInHour1.Value);
}
if (txtCheckInMin1.Value != "")
{
valObj.CheckInMin1 = Convert.ToInt32(txtCheckInMin1.Value);
}
if (txtCheckInHour2.Value != "")
{
valObj.CheckInHour2 = Convert.ToInt32(txtCheckInHour2.Value);
}
if (txtCheckInMin2.Value != "")
{
valObj.CheckInMin2 = Convert.ToInt32(txtCheckInMin2.Value);
}
if (txtCheckOutHour1.Value != "")
{
valObj.CheckOutHour1 = Convert.ToInt32(txtCheckOutHour1.Value);
}
if (txtCheckOutMin1.Value != "")
{
valObj.CheckOutMin1 = Convert.ToInt32(txtCheckOutMin1.Value);
}
if (txtCheckOutMin2.Value != "")
{
valObj.CheckOutMin2 = Convert.ToInt32(txtCheckOutMin2.Value);
}
if (txtCheckOutHour2.Value != "")
{
valObj.CheckOutHour2 = Convert.ToInt32(txtCheckOutHour2.Value);
}
if (keyid != "")
{
valObj.SchName = Convert.ToString(keyid);
count = BLLTable <V_SchedulingSchClass> .Factory(conn).Update(valObj, V_SchedulingSchClass.Attribute.SchName);
}
else
{
count = BLLTable <V_SchedulingSchClass> .Factory(conn).Insert(valObj, V_SchedulingSchClass.Attribute.SchName);
keyid = valObj.SchName.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("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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
{
txtSchName.Value = "";
txtLateMinutes.Value = "";
txtEarlyMinutes.Value = "";
txtCheckIn.Checked = false;
txtCheckOut.Checked = false;
txtColor.Value = "";
txtIsOvertime.Checked = false;
txtYear.Value = "";
txtMonth.Value = "";
txtDay.Value = "";
txtType.Value = "";
txtSchClassid.Value = "";
txtStartHour.Value = "";
txtStartMin.Value = "";
txtEndHour.Value = "";
txtEndMin.Value = "";
txtCheckInHour1.Value = "";
txtCheckInMin1.Value = "";
txtCheckInHour2.Value = "";
txtCheckInMin2.Value = "";
txtCheckOutHour1.Value = "";
txtCheckOutMin1.Value = "";
txtCheckOutMin2.Value = "";
txtCheckOutHour2.Value = "";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private Dictionary<DateTime, List<V_SchedulingSchClass>> GetScheduling(DateTime startTime, DateTime endTime, int type)
{
Dictionary<DateTime, List<V_SchedulingSchClass>> vsDic = new Dictionary<DateTime, List<V_SchedulingSchClass>>();
Dictionary<DateTime, List<int>> vsidDic = new Dictionary<DateTime, List<int>>();
V_SchedulingSchClass val = new V_SchedulingSchClass();
val.SchYear = 0;
val.SchMonth = 0;
val.SchDay = 0;
val.SchClassid = 0;
val.SchType = 0;
val.SchName = "";//(50) Unchecked
val.StartHour = 0;// Unchecked
val.StartMin = 0;// Unchecked
val.EndHour = 0;// Unchecked
val.EndMin = 0;// Unchecked
val.LateMinutes = 0;// Checked
val.EarlyMinutes = 0;// Checked
val.CheckIn = false;// Checked
val.CheckOut = false;// Checked
val.CheckInHour1 = 0;// Checked
val.CheckInMin1 = 0;// Checked
val.CheckInHour2 = 0;// Checked
val.CheckInMin2 = 0;// Checked
val.CheckOutHour1 = 0;// Checked
val.CheckOutMin1 = 0;// Checked
val.CheckOutHour2 = 0;// Checked
val.CheckOutMin2 = 0;// Checked
val.Color = "";//(10) Checked
val.IsOverTime = false;// Unchecked
val.SchNumber = 0;// Unchecked
val.SchUnit = 0;// Unchecked
V_SchedulingSchClass con = new V_SchedulingSchClass();
if (type > 0)
con.SchType = type;
int staffidd = -1;
if (staffid.Trim() != "" && int.TryParse(staffid, out staffidd))
con.STAFF_ID = staffidd;
else if (deptid.Trim() != "")
con.Like(V_SchedulingSchClass.Attribute.DEPT_ID, deptid);
else if (orgid.Trim() != "")
con.Like(V_SchedulingSchClass.Attribute.ORG_ID, orgid);
else
con.STAFF_ID = (int)userBase.StaffID;
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}' ";
con.Where(wher, V_SchedulingSchClass.Attribute.SchYear, V_SchedulingSchClass.Attribute.SchMonth, V_SchedulingSchClass.Attribute.SchDay,
startTime.Year, startTime.Month, startTime.Day,
V_SchedulingSchClass.Attribute.SchYear, V_SchedulingSchClass.Attribute.SchMonth, V_SchedulingSchClass.Attribute.SchDay,
endTime.Year, endTime.Month, endTime.Day);
val.Distinct = true;
con.Distinct = true;
con.OrderBy(new List<OrderByItem>(new OrderByItem[] {
new OrderByItem(V_SchedulingSchClass.Attribute.StartHour, Order.Asc),
new OrderByItem(V_SchedulingSchClass.Attribute.StartMin, Order.Asc),
new OrderByItem(V_SchedulingSchClass.Attribute.EndHour, Order.Asc),
new OrderByItem(V_SchedulingSchClass.Attribute.EndMin, Order.Asc)
}));
List<V_SchedulingSchClass> vsList = BLLTable<V_SchedulingSchClass>.Factory(conn).Select(val, con);
foreach (V_SchedulingSchClass vs in vsList)
{
DateTime date = new DateTime(vs.SchYear, vs.SchMonth, vs.SchDay);
if (!vsDic.ContainsKey(date))
vsDic.Add(date, new List<V_SchedulingSchClass>());
if (!vsidDic.ContainsKey(date))
vsidDic.Add(date, new List<int>());
if (!vsidDic[date].Contains(vs.SchClassid))
{
vsidDic[date].Add(vs.SchClassid);
vsDic[date].Add(vs);
}
}
return vsDic;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["SchName"]))
{
keyid = Request["SchName"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
this.txtSchName.Disabled = true;
this.txtSchName.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable <V_SchedulingSchClass> .Factory(conn).GetRowData(V_SchedulingSchClass.Attribute.SchName, keyid);
if (valObj == null)
{
return;
}
txtSchName.Value = Convert.ToString(valObj.SchName); //Convert.ToString
txtLateMinutes.Value = Convert.ToString(valObj.LateMinutes); //Convert.ToInt32
txtEarlyMinutes.Value = Convert.ToString(valObj.EarlyMinutes); //Convert.ToInt32
txtCheckIn.Checked = valObj.CheckIn;
txtCheckOut.Checked = valObj.CheckOut;
txtColor.Value = Convert.ToString(valObj.Color);//Convert.ToInt32
txtIsOvertime.Checked = valObj.IsOverTime;
txtYear.Value = Convert.ToString(valObj.SchYear); //Convert.ToInt32
txtMonth.Value = Convert.ToString(valObj.SchMonth); //Convert.ToInt16
txtDay.Value = Convert.ToString(valObj.SchDay); //Convert.ToInt16
txtType.Value = Convert.ToString(valObj.SchType); //Convert.ToInt32
txtSchClassid.Value = Convert.ToString(valObj.SchClassid); //Convert.ToInt32
txtStartHour.Value = Convert.ToString(valObj.StartHour); //Convert.ToInt32
txtStartMin.Value = Convert.ToString(valObj.StartMin); //Convert.ToInt32
txtEndHour.Value = Convert.ToString(valObj.EndHour); //Convert.ToInt32
txtEndMin.Value = Convert.ToString(valObj.EndMin); //Convert.ToInt32
txtCheckInHour1.Value = Convert.ToString(valObj.CheckInHour1); //Convert.ToInt32
txtCheckInMin1.Value = Convert.ToString(valObj.CheckInMin1); //Convert.ToInt32
txtCheckInHour2.Value = Convert.ToString(valObj.CheckInHour2); //Convert.ToInt32
txtCheckInMin2.Value = Convert.ToString(valObj.CheckInMin2); //Convert.ToInt32
txtCheckOutHour1.Value = Convert.ToString(valObj.CheckOutHour1); //Convert.ToInt32
txtCheckOutMin1.Value = Convert.ToString(valObj.CheckOutMin1); //Convert.ToInt32
txtCheckOutMin2.Value = Convert.ToString(valObj.CheckOutMin2); //Convert.ToInt32
txtCheckOutHour2.Value = Convert.ToString(valObj.CheckOutHour2); //Convert.ToInt32
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void dll_SelectedIndexChanged(object sender, EventArgs e)
{
if (!IsPostBack)
return;
if(ischange)
return;
ischange = true;
DropDownList dll = sender as DropDownList;
if (dll == null)
return;
condObj = new V_SchedulingSchClass();
condObj.SchYear = Convert.ToInt32(dll_Year.Text);
if (dll_Month.SelectedIndex >= 1)
condObj.SchMonth = Convert.ToInt16(dll_Month.Text);
if (dll.ID == "dll_Year" || dll.ID == "dll_Month")
{
int index = dll_Day.SelectedIndex;
DateTime ddt = new DateTime(condObj.SchYear, condObj.SchMonth < 1 ? 1 : (condObj.SchMonth > 12 ? 12 : condObj.SchMonth), 1);
dll_Day.Items.Clear();
dll_Day.Items.Add(new ListItem("δѡ��", "0"));
int maxDay = 0;
int mon = ddt.Month;
while (ddt.Month == mon)
{
dll_Day.Items.Add(new ListItem(ddt.Day.ToString(), ddt.Day.ToString()));
ddt = ddt.AddDays(1);
maxDay++;
}
if (index > maxDay)
dll_Day.SelectedIndex = maxDay;
else
dll_Day.SelectedIndex = index;
}
if (dll_Day.SelectedIndex >= 1)
condObj.SchDay = Convert.ToInt16(dll_Day.Text);
if (dll_Type.SelectedIndex >= 1)
condObj.SchType = Convert.ToInt16(dll_Type.SelectedValue);
BindList(condObj);
ischange = false;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["SchName"]))
{
keyid = Request["SchName"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
this.txtSchName.Disabled = true;
this.txtSchName.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable<V_SchedulingSchClass>.Factory(conn).GetRowData(V_SchedulingSchClass.Attribute.SchName, keyid);
if(valObj==null) return ;
txtSchName.Value = Convert.ToString(valObj.SchName);//Convert.ToString
txtLateMinutes.Value = Convert.ToString(valObj.LateMinutes);//Convert.ToInt32
txtEarlyMinutes.Value = Convert.ToString(valObj.EarlyMinutes);//Convert.ToInt32
txtCheckIn.Checked = valObj.CheckIn;
txtCheckOut.Checked = valObj.CheckOut;
txtColor.Value = Convert.ToString(valObj.Color);//Convert.ToInt32
txtIsOvertime.Checked = valObj.IsOverTime;
txtYear.Value = Convert.ToString(valObj.SchYear);//Convert.ToInt32
txtMonth.Value = Convert.ToString(valObj.SchMonth);//Convert.ToInt16
txtDay.Value = Convert.ToString(valObj.SchDay);//Convert.ToInt16
txtType.Value = Convert.ToString(valObj.SchType);//Convert.ToInt32
txtSchClassid.Value = Convert.ToString(valObj.SchClassid);//Convert.ToInt32
txtStartHour.Value = Convert.ToString(valObj.StartHour);//Convert.ToInt32
txtStartMin.Value = Convert.ToString(valObj.StartMin);//Convert.ToInt32
txtEndHour.Value = Convert.ToString(valObj.EndHour);//Convert.ToInt32
txtEndMin.Value = Convert.ToString(valObj.EndMin);//Convert.ToInt32
txtCheckInHour1.Value = Convert.ToString(valObj.CheckInHour1);//Convert.ToInt32
txtCheckInMin1.Value = Convert.ToString(valObj.CheckInMin1);//Convert.ToInt32
txtCheckInHour2.Value = Convert.ToString(valObj.CheckInHour2);//Convert.ToInt32
txtCheckInMin2.Value = Convert.ToString(valObj.CheckInMin2);//Convert.ToInt32
txtCheckOutHour1.Value = Convert.ToString(valObj.CheckOutHour1);//Convert.ToInt32
txtCheckOutMin1.Value = Convert.ToString(valObj.CheckOutMin1);//Convert.ToInt32
txtCheckOutMin2.Value = Convert.ToString(valObj.CheckOutMin2);//Convert.ToInt32
txtCheckOutHour2.Value = Convert.ToString(valObj.CheckOutHour2);//Convert.ToInt32
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new V_SchedulingSchClass();
if (txtSchName.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.SchName, Convert.ToString(txtSchName.Value));
}
if (txtLateMinutes.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.LateMinutes, Convert.ToInt32(txtLateMinutes.Value));
}
if (txtEarlyMinutes.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.EarlyMinutes, Convert.ToInt32(txtEarlyMinutes.Value));
}
if (txtCheckIn.Value != "")
{
condObj.CheckIn = Convert.ToBoolean(txtCheckIn.Checked);
}
if (txtCheckOut.Value != "")
{
condObj.CheckOut = Convert.ToBoolean(txtCheckOut.Checked);
}
if (txtColor.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.Color, Convert.ToInt32(txtColor.Value));
}
if (txtIsOvertime.Value != "")
{
condObj.IsOverTime = Convert.ToBoolean(txtIsOvertime.Checked);
}
if (txtYear.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.SchYear, Convert.ToInt32(txtYear.Value));
}
if (txtMonth.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.SchMonth, Convert.ToInt16(txtMonth.Value));
}
if (txtDay.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.SchDay, Convert.ToInt16(txtDay.Value));
}
if (txtType.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.SchType, Convert.ToInt32(txtType.Value));
}
if (txtSchClassid.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.SchClassid, Convert.ToInt32(txtSchClassid.Value));
}
if (txtStartHour.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.StartHour, Convert.ToInt32(txtStartHour.Value));
}
if (txtStartMin.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.StartMin, Convert.ToInt32(txtStartMin.Value));
}
if (txtEndHour.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.EndHour, Convert.ToInt32(txtEndHour.Value));
}
if (txtEndMin.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.EndMin, Convert.ToInt32(txtEndMin.Value));
}
if (txtCheckInHour1.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckInHour1, Convert.ToInt32(txtCheckInHour1.Value));
}
if (txtCheckInMin1.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckInMin1, Convert.ToInt32(txtCheckInMin1.Value));
}
if (txtCheckInHour2.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckInHour2, Convert.ToInt32(txtCheckInHour2.Value));
}
if (txtCheckInMin2.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckInMin2, Convert.ToInt32(txtCheckInMin2.Value));
}
if (txtCheckOutHour1.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutHour1, Convert.ToInt32(txtCheckOutHour1.Value));
}
if (txtCheckOutMin1.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutMin1, Convert.ToInt32(txtCheckOutMin1.Value));
}
if (txtCheckOutMin2.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutMin2, Convert.ToInt32(txtCheckOutMin2.Value));
}
if (txtCheckOutHour2.Value != "")
{
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutHour2, Convert.ToInt32(txtCheckOutHour2.Value));
}
listObj = BLLTable <V_SchedulingSchClass> .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(V_SchedulingSchClass condObj)
{
List <V_SchedulingSchClass> vssList = BLLTable <V_SchedulingSchClass> .Factory(conn).Select(new V_SchedulingSchClass(), condObj);
DataTable data = GetWorkViewHeadTable();
repHead.DataSource = data.Columns;
repHead.DataBind();
Dictionary <string, DataRow> dic = new Dictionary <string, DataRow>();
Dictionary <string, int> rigDic = new Dictionary <string, int>();
data = GetWorkViewBodyTable();
DateTime nowDt = DateTime.Now;
foreach (V_SchedulingSchClass vs in vssList)
{
string date = vs._SchYear + "-" + vs._SchMonth.ToString().PadLeft(2, '0') + "-" + vs._SchDay.ToString().PadLeft(2, '0');
if (!dic.ContainsKey(date))
{
dic.Add(date, data.NewRow());
}
if (!rigDic.ContainsKey(date))
{
rigDic.Add(date, 0);
}
DateTime curDate = new DateTime(vs._SchYear, vs._SchMonth, vs._SchDay);
dic[date][0] = vs.STAFF_ID + spl;
dic[date][1] = vs.STAFF_NAME + spl;
dic[date][2] = date + spl + (curDate == new DateTime(nowDt.Year, nowDt.Month, nowDt.Day) ? "style='background-color:#eeeeaa;'" : "");
dic[date][3] = CheckInOutHelper.ChineseByEnWeek(curDate) + spl + " style='text-align:center;text-indent:0px;'";
dic[date][4] = dll_Type.Items[vs._SchType].Text + spl;
DateTime otime = new DateTime(nowDt.Year, nowDt.Month, nowDt.Day, 0, 0, 0);
DateTime stime = new DateTime(nowDt.Year, nowDt.Month, nowDt.Day, vs.StartHour, vs.StartMin, 0);
DateTime etime = new DateTime(nowDt.Year, nowDt.Month, nowDt.Day, vs.EndHour, vs.EndMin, 0);
int left = ((int)((stime - otime).TotalMinutes / 2.00 + 0.5));
int wid = ((int)((etime - stime).TotalMinutes / 2.00 + 0.5)) - 1;
left = left - rigDic[date];
rigDic[date] = ((int)((stime - otime).TotalMinutes / 2 + 0.5)) + wid + 3;
string sty = "style='float:left;clear:right;display:inline-block;margin-left:" + left + "px; width:" + wid + "px;height:20px; background-color:" + vs.Color + "'";
string tit = "tag='";
tit += "班次名称:" + vs.SchName + "<br />";
tit += "时段:" + vs.StartHour + ":" + vs.StartMin + "-" + vs.EndHour + ":" + vs.EndMin + "<br />";
tit += "计算量值:" + vs.SchNumber + "<br />";
tit += "量值单位:" + formhelper.GetOptionText(HR_SchClass.Attribute.SchUnit, vs.SchUnit) + "<br />";
tit += "是否计算为加班:" + (vs.IsOverTime ? "是" : "否") + "<br />";
tit += "签到时间:" + (!vs.CheckIn?"不签到":(vs.CheckInHour1 + ":" + vs.CheckInMin1 + "-" + vs.CheckInHour2 + ":" + vs.CheckInMin2)) + "<br />";
tit += "签退时间:" + (!vs.CheckOut ? "不签退" : (vs.CheckOutHour1 + ":" + vs.CheckOutMin1 + "-" + vs.CheckOutHour2 + ":" + vs.CheckOutMin2)) + "<br />";
tit += "计迟到/早退分钟数:" + vs.LateMinutes + "/" + vs.EarlyMinutes + "<br />";
tit += "'";
string a = "<a " + tit + " " + sty + " onmousemove='showatooltip(\"tableatooltip\",this)' onmouseout='hideatooltip(\"tableatooltip\")'></a>";
dic[date][5] += a;
}
foreach (string vs in dic.Keys)
{
dic[vs][5] += spl + " colspan='24' style='text-indent:0px;' ";
data.Rows.Add(dic[vs]);
}
repList.DataSource = data.Rows;
repList.DataBind();
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new V_SchedulingSchClass();
if(txtSchName.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.SchName, Convert.ToString(txtSchName.Value));
if(txtLateMinutes.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.LateMinutes, Convert.ToInt32(txtLateMinutes.Value));
if(txtEarlyMinutes.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.EarlyMinutes, Convert.ToInt32(txtEarlyMinutes.Value));
if(txtCheckIn.Value !="" )
condObj.CheckIn = Convert.ToBoolean(txtCheckIn.Checked);
if(txtCheckOut.Value !="" )
condObj.CheckOut = Convert.ToBoolean(txtCheckOut.Checked);
if(txtColor.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.Color, Convert.ToInt32(txtColor.Value));
if(txtIsOvertime.Value !="" )
condObj.IsOverTime = Convert.ToBoolean(txtIsOvertime.Checked);
if(txtYear.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.SchYear, Convert.ToInt32(txtYear.Value));
if(txtMonth.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.SchMonth, Convert.ToInt16(txtMonth.Value));
if(txtDay.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.SchDay, Convert.ToInt16(txtDay.Value));
if(txtType.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.SchType, Convert.ToInt32(txtType.Value));
if(txtSchClassid.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.SchClassid, Convert.ToInt32(txtSchClassid.Value));
if(txtStartHour.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.StartHour, Convert.ToInt32(txtStartHour.Value));
if(txtStartMin.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.StartMin, Convert.ToInt32(txtStartMin.Value));
if(txtEndHour.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.EndHour, Convert.ToInt32(txtEndHour.Value));
if(txtEndMin.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.EndMin, Convert.ToInt32(txtEndMin.Value));
if(txtCheckInHour1.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckInHour1, Convert.ToInt32(txtCheckInHour1.Value));
if(txtCheckInMin1.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckInMin1, Convert.ToInt32(txtCheckInMin1.Value));
if(txtCheckInHour2.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckInHour2, Convert.ToInt32(txtCheckInHour2.Value));
if(txtCheckInMin2.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckInMin2, Convert.ToInt32(txtCheckInMin2.Value));
if(txtCheckOutHour1.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutHour1, Convert.ToInt32(txtCheckOutHour1.Value));
if(txtCheckOutMin1.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutMin1, Convert.ToInt32(txtCheckOutMin1.Value));
if(txtCheckOutMin2.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutMin2, Convert.ToInt32(txtCheckOutMin2.Value));
if(txtCheckOutHour2.Value !="" )
condObj.Like(V_SchedulingSchClass.Attribute.CheckOutHour2, Convert.ToInt32(txtCheckOutHour2.Value));
listObj = BLLTable<V_SchedulingSchClass>.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//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideTableColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP1);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP2);
//hideFindColumnList.Add(V_SchedulingSchClass.Attribute.EXP3);
#endregion
condObj.OrderBy(V_SchedulingSchClass.Attribute.SchName, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
V_SchedulingSchClass roleOld = new V_SchedulingSchClass();
roleOld.Where(V_SchedulingSchClass.Attribute.SchName, Request["ids"].ToString());
listObj = BLLTable<V_SchedulingSchClass>.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].SchName + "',Name:'" + listObj[i].SchName + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].SchName;
}
}
try
{
listObj = BLLTable<V_SchedulingSchClass>.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;
}
}
}
