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