public static void Create(WeekRecord week) { SimpleOrmOperator.Create(week); string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); YuyueLimitOperator.Save(week, 1, 1, datestr, week.Week1km1fp); YuyueLimitOperator.Save(week, 1, 2, datestr, week.Week1km2fp); YuyueLimitOperator.Save(week, 1, 3, datestr, week.Week1km3fp); YuyueLimitOperator.Save(week, 2, 1, datestr, week.Week2km1fp); YuyueLimitOperator.Save(week, 2, 2, datestr, week.Week2km2fp); YuyueLimitOperator.Save(week, 2, 3, datestr, week.Week2km3fp); YuyueLimitOperator.Save(week, 3, 1, datestr, week.Week3km1fp); YuyueLimitOperator.Save(week, 3, 2, datestr, week.Week3km2fp); YuyueLimitOperator.Save(week, 3, 3, datestr, week.Week3km3fp); YuyueLimitOperator.Save(week, 4, 1, datestr, week.Week4km1fp); YuyueLimitOperator.Save(week, 4, 2, datestr, week.Week4km2fp); YuyueLimitOperator.Save(week, 4, 3, datestr, week.Week4km3fp); YuyueLimitOperator.Save(week, 5, 1, datestr, week.Week5km1fp); YuyueLimitOperator.Save(week, 5, 2, datestr, week.Week5km2fp); YuyueLimitOperator.Save(week, 5, 3, datestr, week.Week5km3fp); YuyueLimitOperator.Save(week, 6, 1, datestr, week.Week6km1fp); YuyueLimitOperator.Save(week, 6, 2, datestr, week.Week6km2fp); YuyueLimitOperator.Save(week, 6, 3, datestr, week.Week6km3fp); YuyueLimitOperator.Save(week, 7, 1, datestr, week.Week7km1fp); YuyueLimitOperator.Save(week, 7, 2, datestr, week.Week7km2fp); YuyueLimitOperator.Save(week, 7, 3, datestr, week.Week7km3fp); }
private void UpdateWeekRecord(TagItem tagItem) { UpdateRecordsByTag(tagItem); var weekRecords = new ObservableCollection <WeekRecord>(); var startDateOfSelectedWeek = SelectedWeek; var startDateOfWeek = new DateTime(startDateOfSelectedWeek.Year, startDateOfSelectedWeek.Month, startDateOfSelectedWeek.Day, 0, 0, 0); while (startDateOfWeek.Date.DayOfWeek != DayOfWeek.Monday) { startDateOfWeek = startDateOfWeek.AddDays(-1); } var startDateOfMonth = startDateOfWeek; var RecordsOfWeek = RecordsByTag.FindAll((r) => r.DateTime.Ticks > startDateOfWeek.Ticks && r.DateTime.Ticks <= startDateOfWeek.AddDays(7).Ticks); var weekRecord = new WeekRecord() { StartDateOfWeek = startDateOfWeek, DayRecords = RecordsOfWeek }; WeekRecord = weekRecord; SetDayRecords(); OnPropertyChanged(nameof(HasRecord)); OnPropertyChanged(nameof(HasNoRecord)); }
private string ComputeLink(WeekRecord week, int dayofweek, int km) { if (week.Id <= 0) { return string.Empty; } string sql = "select id,i_total,i_used_num,i_checked_num,c_kscc,c_kscc_code,c_ksdd,c_ksdd_code,c_school_name,c_school_code,date_ksrq from table_yuyue_limit " +" where date_ksrq like '"+System.DateTime.Now.Year.ToString()+"%' and i_week_num="+week.WeekNum+" and i_dayofweek="+dayofweek+" and i_km="+km; DataTable dt = DataAccessFactory.GetDataAccess().SelectDataTable(sql,"tmp"); string depcode=this.Operator.Desp3; StringBuilder sb = new StringBuilder(); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append(dt.Rows[i][6].ToString() + ";" + dt.Rows[i][4].ToString()); if (dt.Rows[i][9].ToString() == depcode) { sb.Append(";" + "<a href='SchoolCommitUser.aspx?id="+dt.Rows[i][0].ToString()+"' target='_blank'>" + dt.Rows[i][8].ToString() + "</a>"); } else { sb.Append(";" + dt.Rows[i][8].ToString()); } sb.Append("(" + dt.Rows[i][2].ToString() + "/" + dt.Rows[i][3].ToString() + ")"); sb.Append("/" + dt.Rows[i][1].ToString()); sb.Append("<br/>"); } return sb.ToString(); }
private string ComputeLink(WeekRecord week, int dayofweek, int km) { if (week.Id <= 0) { return string.Empty; } string sql = "select id,i_total,i_used_num,i_checked_num,c_kscc,c_kscc_code,c_ksdd,c_ksdd_code,c_school_name,c_school_code,date_ksrq from table_yuyue_limit " + " where i_week_num=" + week.WeekNum + " and i_dayofweek=" + dayofweek + " and i_km=" + km; DataTable dt = DataAccessFactory.GetDataAccess().SelectDataTable(sql, "tmp"); string depcode = "social"; StringBuilder sb = new StringBuilder(); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append(dt.Rows[i][6].ToString() + ";" + dt.Rows[i][4].ToString()); if (dt.Rows[i][9].ToString() == depcode) { sb.Append(";" + "<a href='SocialCommitUser.aspx?id=" + dt.Rows[i][0].ToString() + "' target='_blank'>" + dt.Rows[i][8].ToString() + "</a>"); } else { sb.Append(";" + dt.Rows[i][8].ToString()); } sb.Append("(" + dt.Rows[i][2].ToString() + "/" + dt.Rows[i][3].ToString() + ")"); sb.Append("/" + dt.Rows[i][1].ToString()); sb.Append("<br/>"); } return sb.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { DateTime date = Convert.ToDateTime(this.txtDate.Value); DateTime begin = DateTimeHelper.GetMonday(date); WeekRecord week = WeekRecordOperator.GetByWeekNum(DateTimeHelper.GetWeekOfYear(date), begin.ToShortDateString()); if (week.Id <= 0) { WebTools.Alert("没有" + this.txtDate.Value + "本期的排班!"); return; } if (week.Id > 0 && week.Checked == 0) { week.Checked = 1; week.CheckOperator = this.Operator.OperatorName; SimpleOrmOperator.Update(week); //WeekRecordOperator.Update(week); WebTools.Alert("审核通过!"); } else { WebTools.Alert("已审核的记录无法审核!"); } }
private void ChangeWeekRecord(WeekRecord weekRecord) { foreach (var _weekRecord in WeekRecords.ToList()) { if (_weekRecord.StartDateOfWeek.Date == weekRecord.StartDateOfWeek.Date) { _weekRecord.DayRecords = weekRecord.DayRecords; } } }
public static void Create(WeekRecord week, ArrayList limits) { SimpleOrmOperator.Create(week); string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); foreach (object obj in limits) { YuyueLimit limit = obj as YuyueLimit; YuyueLimitOperator.Save(week, limit, begin); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.InitTableControls(); if (Request.Params["id"] != null) { WeekRecord entity = WeekRecordOperator.Get(Convert.ToInt32(Request.Params["id"])); this.InitWeekRecord(entity); } } }
public static Hashtable GetWeekLimits(WeekRecord week) { int weekNum = week.WeekNum; //String weekRang = week.WeekRange; //String year = weekRang.Substring(0,4); Hashtable dictWeekLimits = new Hashtable(); ArrayList listWeekLimits = new ArrayList(); string querySql = string.Format("where I_WEEK_NUM={0}",weekNum); listWeekLimits=SimpleOrmOperator.QueryConditionList<YuyueLimit>(querySql); foreach (YuyueLimit limit in listWeekLimits) { String key = genLimitKey(limit); dictWeekLimits.Add(key,limit); } return dictWeekLimits; }
public static void Update(WeekRecord week, ArrayList limits) { SimpleOrmOperator.Update(week); string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); string deleteSql = "delete from table_yuyue_limit where i_week_num=" + week.WeekNum + " and date_ksrq like '" + begin.Year.ToString() + "%'"; DataAccessFactory.GetDataAccess().ExecuteSql(deleteSql); foreach (object obj in limits) { YuyueLimit limit = obj as YuyueLimit; YuyueLimitOperator.Save(week, limit, begin); } }
public static WeekRecord GetByWeekNum(int num, string shortdate) { WeekRecord week = new WeekRecord(); ArrayList lists = SimpleOrmOperator.QueryConditionList <WeekRecord>(" where i_week_num=" + num + " and c_week_range like '" + shortdate + "%'"); if (lists.Count == 1) { week = lists[0] as WeekRecord; } else { week.WeekNum = num; } return(week); // SimpleOrmOperator.Delete<WeekRecord>(id); }
public RecordDetailViewModel(INavigation navigation, WeekRecord weekRecord, IEnumerable <Record> allRecords, IMessageBoxService messageBoxService) : base(navigation) { ConstructCommand(); MessageBoxService = messageBoxService; Records = allRecords.ToList(); WeekRecord = weekRecord; CreateTagItems(); SetDayRecords(); InitRecordsForSearch(); }
public static Hashtable GetWeekLimits(WeekRecord week) { int weekNum = week.WeekNum; //String weekRang = week.WeekRange; //String year = weekRang.Substring(0,4); Hashtable dictWeekLimits = new Hashtable(); ArrayList listWeekLimits = new ArrayList(); string querySql = string.Format("where I_WEEK_NUM={0}", weekNum); listWeekLimits = SimpleOrmOperator.QueryConditionList <YuyueLimit>(querySql); foreach (YuyueLimit limit in listWeekLimits) { String key = genLimitKey(limit); dictWeekLimits.Add(key, limit); } return(dictWeekLimits); }
private void UpdateWeekRecords(TagItem tagItem) { UpdateMonthRecordsByTag(tagItem); var weekRecords = new ObservableCollection <WeekRecord>(); var startDateOfSelectedMonth = SelectedMonth; var startDateOfWeek = new DateTime(startDateOfSelectedMonth.Year, startDateOfSelectedMonth.Month, 1, 0, 0, 0); while (startDateOfWeek.Date.DayOfWeek != DayOfWeek.Monday) { startDateOfWeek = startDateOfWeek.AddDays(-1); } var startDateOfMonth = startDateOfWeek; while (startDateOfMonth.Ticks <= startDateOfSelectedMonth.Ticks) { var RecordsOfWeek = MonthRecordsByTag.FindAll(r => startDateOfWeek.Ticks < r.DateTime.Ticks && r.DateTime.Ticks <= startDateOfWeek.AddDays(7).Ticks); var weekRecord = new WeekRecord() { StartDateOfWeek = startDateOfWeek, DayRecords = RecordsOfWeek }; if (weekRecord.HasRecord) { weekRecords.Add(weekRecord); } startDateOfWeek = startDateOfWeek.AddDays(7); startDateOfMonth = new DateTime(startDateOfWeek.Year, startDateOfWeek.Month, 1, 0, 0, 0); } // 여기에 태그 관련 리스트 뽑아내게 수정해야 함 WeekRecords.Clear(); WeekRecords = weekRecords; RefreshRecordChart(); OnPropertyChanged(nameof(SuccessChart)); OnPropertyChanged(nameof(HasNoWeekRecords)); }
public static void Save(WeekRecord week, int dayofweek, int km, string begindate, string desc) { if (desc == null || desc.Length == 0) { return; } int weeknum = week.WeekNum; DateTime begin = DateTime.Parse(begindate); ArrayList lists = new ArrayList(); string[] array1 = desc.Trim("<br/>".ToCharArray()).Split(new string[] { "<br/>" }, StringSplitOptions.RemoveEmptyEntries); string[] array2 = null; string[] array3 = null; YuyueLimit limit; for (int i = 0; i < array1.Length; i++) { limit = new YuyueLimit(); limit.WeekNum = weeknum; limit.Operator = week.CheckOperator; limit.Ksrq = begin.AddDays(dayofweek - 1).ToString("yyyy-MM-dd"); limit.DayOfWeek = dayofweek; array2 = array1[i].Split(';'); array3 = array2[0].Split(':'); limit.KsddCode = array3[0]; limit.Ksdd = array3[1]; array3 = array2[1].Split(':'); limit.KsccCode = array3[0]; limit.Kscc = array3[1]; array3 = array2[2].Split(':'); limit.SchoolCode = array3[0]; limit.SchoolName = array3[1]; limit.Km = km; limit.Total = Int32.Parse(array2[3]); SimpleOrmOperator.Create(limit); } // SimpleOrmOperator.Delete<YuyueLimit>(id); }
protected void btnSubmit_Click(object sender, EventArgs e) { string date = this.txtDate.Value.Trim(); if (date.Length > 0) { DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(date)); for (int i = 0; i < 7; i++) { this.Table1.Rows[i + 2].Cells[0].Text = this.GetChineseXq(i + 1) + "(" + begin.AddDays(i).ToString("yyyy-MM-dd") + ")"; } WeekRecord week = WeekRecordOperator.GetByWeekNum(DateTimeHelper.GetWeekOfYear(begin),begin.ToShortDateString()); if (week.Id <= 0||week.Checked!=1) { WebTools.Alert("找不到"+date+"的周排班表!"); return; } this.InitWeekRecord(week); } }
public static void Save(WeekRecord week,int dayofweek,int km,string begindate,string desc) { if (desc == null || desc.Length == 0) { return; } int weeknum = week.WeekNum; DateTime begin = DateTime.Parse(begindate); ArrayList lists = new ArrayList(); string[] array1 = desc.Trim("<br/>".ToCharArray()).Split(new string[]{"<br/>"},StringSplitOptions.RemoveEmptyEntries); string[] array2 = null; string[] array3 = null; YuyueLimit limit; for (int i = 0; i < array1.Length; i++) { limit = new YuyueLimit(); limit.WeekNum = weeknum; limit.Operator = week.CheckOperator; limit.Ksrq = begin.AddDays(dayofweek-1).ToString("yyyy-MM-dd"); limit.DayOfWeek = dayofweek; array2 = array1[i].Split(';'); array3 = array2[0].Split(':'); limit.KsddCode = array3[0]; limit.Ksdd = array3[1]; array3 = array2[1].Split(':'); limit.KsccCode = array3[0]; limit.Kscc = array3[1]; array3 = array2[2].Split(':'); limit.SchoolCode = array3[0]; limit.SchoolName = array3[1]; limit.Km = km; limit.Total =Int32.Parse(array2[3]); SimpleOrmOperator.Create(limit); } // SimpleOrmOperator.Delete<YuyueLimit>(id); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // ViewState DictOperator.BindDropDownList("考试地点", this.cbKsdd); DictOperator.BindDropDownList("考试场次", this.cbKscc); DepartMentOperator.BindNick(this.cbSchool, "驾校"); this.InitTableControls(); if (Request.Params["id"] != null) { WeekRecord entity = WeekRecordOperator.Get(Convert.ToInt32(Request.Params["id"])); //weekRocord = WeekRecordOperator.Get(Convert.ToInt32(Request.Params["id"])); this.InitWeekRecord(entity); string querySql = string.Format("where I_WEEK_NUM={0}", entity.WeekNum); ArrayList listLimits = SimpleOrmOperator.QueryConditionList <YuyueLimit>(querySql); ViewState[VIEWSTATUE_LIMITS] = listLimits; ViewState[VIEWSTATUE_WEEKRECORD] = entity; } } }
private void UpdateWeekRecords() { var weekRecords = new List <WeekRecord>(); var startDateOfSelectedMonth = SelectedMonth; var startDateOfWeek = new DateTime(startDateOfSelectedMonth.Year, startDateOfSelectedMonth.Month, 1, 0, 0, 0); while (startDateOfWeek.Date.DayOfWeek != DayOfWeek.Sunday) { startDateOfWeek = startDateOfWeek.AddDays(-1); } var startDateOfMonth = startDateOfWeek; while (startDateOfMonth.Ticks <= startDateOfSelectedMonth.Ticks) { var RecordsOfWeek = Records.FindAll(r => startDateOfWeek.Ticks <= r.RecordTime.Ticks && r.RecordTime.Ticks < startDateOfWeek.AddDays(7).Ticks); var weekRecord = new WeekRecord() { SelectedMonth = SelectedMonth.Month, StartDateOfWeek = startDateOfWeek, DayRecords = RecordsOfWeek.OrderBy(r => r.RecordTime).ToList() }; weekRecords.Add(weekRecord); startDateOfWeek = startDateOfWeek.AddDays(7); startDateOfMonth = new DateTime(startDateOfWeek.Year, startDateOfWeek.Month, 1, 0, 0, 0); } ResetSuccessRate(); WeekRecords.Clear(); WeekRecords = weekRecords; OnPropertyChanged(nameof(WeekRecords)); OnPropertyChanged(nameof(RoutineNumOfThisMonth)); OnPropertyChanged(nameof(SuccessRoutineNumOfThisMonth)); }
protected void lbtn_Click(object sender, EventArgs e) { if (this.hidRowOld.Value != "-1" && this.hidColOld.Value != "-1") { int j = int.Parse(this.hidColOld.Value); int m = int.Parse(this.hidRowOld.Value); if (this.GetSl(this.txtNum) > 0) { // this.Table1.Rows[m].Cells[j + 2].Text += "<br/>" + this.cbKsdd.SelectedItem.Value + ":" + // this.cbKsdd.SelectedItem.Text + ";" + this.cbKscc.SelectedItem.Value // + ":" + this.cbKscc.SelectedItem.Text + ";" // + this.cbSchool.SelectedItem.Value + ":" + this.cbSchool.SelectedItem.Text + ";" + this.txtNum.Text.Trim(); string context = string.Format("<br/>{0}({1})", this.cbSchool.SelectedItem.Text, this.txtNum.Text.Trim()); this.Table1.Rows[m].Cells[j + 2].Text += context; int km = (j + 2) / 2; int datyOfWeek = m - 1; WeekRecord weekRecord = ViewState[VIEWSTATUE_WEEKRECORD] as WeekRecord; ArrayList limits = ViewState[VIEWSTATUE_LIMITS] as ArrayList; YuyueLimit tempLimit = new YuyueLimit(); tempLimit.DayOfWeek = datyOfWeek; tempLimit.Km = km; tempLimit.WeekNum = weekRecord.WeekNum; tempLimit.Ksdd = this.cbKsdd.SelectedItem.Text; tempLimit.KsddCode = this.cbKsdd.SelectedItem.Value; tempLimit.Kscc = this.cbKscc.SelectedItem.Text; tempLimit.KsccCode = this.cbKscc.SelectedItem.Value; tempLimit.SchoolName = this.cbSchool.SelectedItem.Text; tempLimit.SchoolCode = this.cbSchool.SelectedItem.Value; tempLimit.Total = int.Parse(this.txtNum.Text.Trim()); limits.Add(tempLimit); ViewState[VIEWSTATUE_LIMITS] = limits; } else { WebTools.Alert("分配的数量不得为0!"); } } }
protected void DataGrid1_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "Delete") { int id = Convert.ToInt32(e.CommandArgument); WeekRecord record = WeekRecordOperator.Get(id); if (record != null && record.Checked == 1) { WebTools.Alert(this, "已审核过的数据无法删除!"); } else { WeekRecordOperator.Delete(id); WebTools.Alert(this, "删除成功!"); this.ProcedurePager1.Changed = true; } } else if (e.CommandName == "Detail") { int id = Convert.ToInt32(e.CommandArgument); this.Pop(id); } }
public static void Update(WeekRecord week) { SimpleOrmOperator.Update(week); string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); DataAccessFactory.GetDataAccess().ExecuteSql("delete from table_yuyue_limit where i_week_num=" + week.WeekNum + " and date_ksrq like '" + begin.Year.ToString() + "%'"); YuyueLimitOperator.Save(week, 1, 1, datestr, week.Week1km1fp); YuyueLimitOperator.Save(week, 1, 2, datestr, week.Week1km2fp); YuyueLimitOperator.Save(week, 1, 3, datestr, week.Week1km3fp); YuyueLimitOperator.Save(week, 2, 1, datestr, week.Week2km1fp); YuyueLimitOperator.Save(week, 2, 2, datestr, week.Week2km2fp); YuyueLimitOperator.Save(week, 2, 3, datestr, week.Week2km3fp); YuyueLimitOperator.Save(week, 3, 1, datestr, week.Week3km1fp); YuyueLimitOperator.Save(week, 3, 2, datestr, week.Week3km2fp); YuyueLimitOperator.Save(week, 3, 3, datestr, week.Week3km3fp); YuyueLimitOperator.Save(week, 4, 1, datestr, week.Week4km1fp); YuyueLimitOperator.Save(week, 4, 2, datestr, week.Week4km2fp); YuyueLimitOperator.Save(week, 4, 3, datestr, week.Week4km3fp); YuyueLimitOperator.Save(week, 5, 1, datestr, week.Week5km1fp); YuyueLimitOperator.Save(week, 5, 2, datestr, week.Week5km2fp); YuyueLimitOperator.Save(week, 5, 3, datestr, week.Week5km3fp); YuyueLimitOperator.Save(week, 6, 1, datestr, week.Week6km1fp); YuyueLimitOperator.Save(week, 6, 2, datestr, week.Week6km2fp); YuyueLimitOperator.Save(week, 6, 3, datestr, week.Week6km3fp); YuyueLimitOperator.Save(week, 7, 1, datestr, week.Week7km1fp); YuyueLimitOperator.Save(week, 7, 2, datestr, week.Week7km2fp); YuyueLimitOperator.Save(week, 7, 3, datestr, week.Week7km3fp); }
private void InitWeekRecord(WeekRecord week) { string datestr = ""; if (week.Id <= 0) { datestr = this.txtDate.Value; ViewState[VIEWSTATUE_LIMITS] = new ArrayList(); // WeekRecord record=new WeekRecord(); // record. ViewState[VIEWSTATUE_WEEKRECORD] = week; // return; } else { datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); } DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); this.txtDate.Value = datestr; for (int i = 0; i < 7; i++) { this.Table1.Rows[i + 2].Cells[0].Text = this.GetChineseXq(i + 1) + "(" + begin.AddDays(i).ToString("yyyy-MM-dd") + ")"; } this.txtxq1km1zs.Text = week.Week1km1Num.ToString(); this.Table1.Rows[2].Cells[2].Text=week.Week1km1fp == null ? " " : week.Week1km1fp.ToString(); this.txtxq1km2zs.Text=week.Week1km2Num.ToString(); this.Table1.Rows[2].Cells[4].Text = week.Week1km2fp == null ? " " : week.Week1km2fp.ToString(); this.txtxq1km3zs.Text = week.Week1km3Num .ToString(); this.Table1.Rows[2].Cells[6].Text = week.Week1km3fp == null ? " " : week.Week1km3fp.ToString(); this.txtxq2km1zs.Text = week.Week2km1Num.ToString(); this.Table1.Rows[3].Cells[2].Text = week.Week2km1fp == null ? " " : week.Week2km1fp.ToString(); this.txtxq2km2zs.Text = week.Week2km2Num.ToString(); this.Table1.Rows[3].Cells[4].Text = week.Week2km2fp == null ? " " : week.Week2km2fp.ToString(); this.txtxq2km3zs.Text = week.Week2km3Num.ToString(); this.Table1.Rows[3].Cells[6].Text = week.Week2km3fp == null ? " " : week.Week2km3fp.ToString(); this.txtxq3km1zs.Text = week.Week3km1Num.ToString(); this.Table1.Rows[4].Cells[2].Text = week.Week3km1fp == null ? " " : week.Week3km1fp.ToString(); this.txtxq3km2zs.Text = week.Week3km2Num.ToString(); this.Table1.Rows[4].Cells[4].Text = week.Week3km2fp == null ? " " : week.Week3km2fp.ToString(); this.txtxq3km3zs.Text = week.Week3km3Num.ToString(); this.Table1.Rows[4].Cells[6].Text = week.Week3km3fp == null ? " " : week.Week3km3fp.ToString(); this.txtxq4km1zs.Text = week.Week4km1Num.ToString(); this.Table1.Rows[5].Cells[2].Text = week.Week4km1fp == null ? " " : week.Week4km1fp.ToString(); this.txtxq4km2zs.Text = week.Week4km2Num.ToString(); this.Table1.Rows[5].Cells[4].Text = week.Week4km2fp == null ? " " : week.Week4km2fp.ToString(); this.txtxq4km3zs.Text = week.Week4km3Num.ToString(); this.Table1.Rows[5].Cells[6].Text = week.Week4km3fp == null ? " " : week.Week4km3fp.ToString(); this.txtxq5km1zs.Text = week.Week5km1Num.ToString(); this.Table1.Rows[6].Cells[2].Text = week.Week5km1fp == null ? " " : week.Week5km1fp.ToString(); this.txtxq5km2zs.Text = week.Week5km2Num.ToString(); this.Table1.Rows[6].Cells[4].Text = week.Week5km2fp == null ? " " : week.Week5km2fp.ToString(); this.txtxq5km3zs.Text = week.Week5km3Num.ToString(); this.Table1.Rows[6].Cells[6].Text = week.Week5km3fp == null ? " " : week.Week5km3fp.ToString(); this.txtxq6km1zs.Text = week.Week6km1Num.ToString(); this.Table1.Rows[7].Cells[2].Text = week.Week6km1fp == null ? " " : week.Week6km1fp.ToString(); this.txtxq6km2zs.Text = week.Week6km2Num.ToString(); this.Table1.Rows[7].Cells[4].Text = week.Week6km2fp == null ? " " : week.Week6km2fp.ToString(); this.txtxq6km3zs.Text = week.Week6km3Num.ToString(); this.Table1.Rows[7].Cells[6].Text = week.Week6km3fp == null ? " " : week.Week6km3fp.ToString(); this.txtxq7km1zs.Text = week.Week7km1Num.ToString(); this.Table1.Rows[8].Cells[2].Text = week.Week7km1fp == null ? " " : week.Week7km1fp.ToString(); this.txtxq7km2zs.Text = week.Week7km2Num.ToString(); this.Table1.Rows[8].Cells[4].Text = week.Week7km2fp == null ? " " : week.Week7km2fp.ToString(); this.txtxq7km3zs.Text = week.Week7km3Num.ToString(); this.Table1.Rows[8].Cells[6].Text = week.Week7km3fp == null ? " " : week.Week7km3fp.ToString(); }
private void InitWeekRecord(WeekRecord week) { string datestr = ""; if (week.Id <= 0) { datestr = this.txtDate.Value; // return; } else { datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); } if (week.Checked != 1) { return; } DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); this.txtDate.Value = datestr; for (int i = 0; i < 7; i++) { this.Table1.Rows[i + 2].Cells[0].Text = this.GetChineseXq(i + 1) + "(" + begin.AddDays(i).ToString("yyyy-MM-dd") + ")"; } this.txtxq1km1zs.Text = week.Week1km1Num.ToString(); this.Table1.Rows[2].Cells[2].Text = this.ComputeLink(week, 1, 1); this.txtxq1km2zs.Text = week.Week1km2Num.ToString(); this.Table1.Rows[2].Cells[4].Text = this.ComputeLink(week, 1, 2); this.txtxq1km3zs.Text = week.Week1km3Num.ToString(); this.Table1.Rows[2].Cells[6].Text = this.ComputeLink(week, 1, 3); this.txtxq2km1zs.Text = week.Week2km1Num.ToString(); this.Table1.Rows[3].Cells[2].Text = this.ComputeLink(week, 2, 1); this.txtxq2km2zs.Text = week.Week2km2Num.ToString(); this.Table1.Rows[3].Cells[4].Text = this.ComputeLink(week, 2, 2); this.txtxq2km3zs.Text = week.Week2km3Num.ToString(); this.Table1.Rows[3].Cells[6].Text = this.ComputeLink(week, 2, 3); this.txtxq3km1zs.Text = week.Week3km1Num.ToString(); this.Table1.Rows[4].Cells[2].Text = this.ComputeLink(week, 3, 1); this.txtxq3km2zs.Text = week.Week3km2Num.ToString(); this.Table1.Rows[4].Cells[4].Text = this.ComputeLink(week, 3, 2); this.txtxq3km3zs.Text = week.Week3km3Num.ToString(); this.Table1.Rows[4].Cells[6].Text = this.ComputeLink(week, 3, 3); this.txtxq4km1zs.Text = week.Week4km1Num.ToString(); this.Table1.Rows[5].Cells[2].Text = this.ComputeLink(week, 4, 1); this.txtxq4km2zs.Text = week.Week4km2Num.ToString(); this.Table1.Rows[5].Cells[4].Text = this.ComputeLink(week, 4, 2); this.txtxq4km3zs.Text = week.Week4km3Num.ToString(); this.Table1.Rows[5].Cells[6].Text = this.ComputeLink(week, 4, 3); this.txtxq5km1zs.Text = week.Week5km1Num.ToString(); this.Table1.Rows[6].Cells[2].Text = this.ComputeLink(week, 5, 1); this.txtxq5km2zs.Text = week.Week5km2Num.ToString(); this.Table1.Rows[6].Cells[4].Text = this.ComputeLink(week, 5, 2); this.txtxq5km3zs.Text = week.Week5km3Num.ToString(); this.Table1.Rows[6].Cells[6].Text = this.ComputeLink(week,5, 3); this.txtxq6km1zs.Text = week.Week6km1Num.ToString(); this.Table1.Rows[7].Cells[2].Text = this.ComputeLink(week, 6, 1); this.txtxq6km2zs.Text = week.Week6km2Num.ToString(); this.Table1.Rows[7].Cells[4].Text = this.ComputeLink(week, 6, 2); this.txtxq6km3zs.Text = week.Week6km3Num.ToString(); this.Table1.Rows[7].Cells[6].Text = this.ComputeLink(week, 6, 3); this.txtxq7km1zs.Text = week.Week7km1Num.ToString(); this.Table1.Rows[8].Cells[2].Text = this.ComputeLink(week, 7, 1); this.txtxq7km2zs.Text = week.Week7km2Num.ToString(); this.Table1.Rows[8].Cells[4].Text = this.ComputeLink(week, 7, 2); this.txtxq7km3zs.Text = week.Week7km3Num.ToString(); this.Table1.Rows[8].Cells[6].Text = this.ComputeLink(week, 7, 3); }
public static void Update(WeekRecord week) { SimpleOrmOperator.Update(week); string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); DataAccessFactory.GetDataAccess().ExecuteSql("delete from table_yuyue_limit where i_week_num="+week.WeekNum+ " and date_ksrq like '"+begin.Year.ToString()+"%'"); YuyueLimitOperator.Save(week, 1, 1, datestr, week.Week1km1fp); YuyueLimitOperator.Save(week, 1, 2, datestr, week.Week1km2fp); YuyueLimitOperator.Save(week, 1, 3, datestr, week.Week1km3fp); YuyueLimitOperator.Save(week, 2, 1, datestr, week.Week2km1fp); YuyueLimitOperator.Save(week, 2, 2, datestr, week.Week2km2fp); YuyueLimitOperator.Save(week, 2, 3, datestr, week.Week2km3fp); YuyueLimitOperator.Save(week, 3, 1, datestr, week.Week3km1fp); YuyueLimitOperator.Save(week, 3, 2, datestr, week.Week3km2fp); YuyueLimitOperator.Save(week, 3, 3, datestr, week.Week3km3fp); YuyueLimitOperator.Save(week, 4, 1, datestr, week.Week4km1fp); YuyueLimitOperator.Save(week, 4, 2, datestr, week.Week4km2fp); YuyueLimitOperator.Save(week, 4, 3, datestr, week.Week4km3fp); YuyueLimitOperator.Save(week, 5, 1, datestr, week.Week5km1fp); YuyueLimitOperator.Save(week, 5, 2, datestr, week.Week5km2fp); YuyueLimitOperator.Save(week, 5, 3, datestr, week.Week5km3fp); YuyueLimitOperator.Save(week, 6, 1, datestr, week.Week6km1fp); YuyueLimitOperator.Save(week, 6, 2, datestr, week.Week6km2fp); YuyueLimitOperator.Save(week, 6, 3, datestr, week.Week6km3fp); YuyueLimitOperator.Save(week, 7, 1, datestr, week.Week7km1fp); YuyueLimitOperator.Save(week, 7, 2, datestr, week.Week7km2fp); YuyueLimitOperator.Save(week, 7, 3, datestr, week.Week7km3fp); }
public static WeekRecord GetByWeekNum(int num,string shortdate) { WeekRecord week = new WeekRecord(); ArrayList lists = SimpleOrmOperator.QueryConditionList<WeekRecord>(" where i_week_num=" + num + " and c_week_range like '"+shortdate+"%'"); if (lists.Count == 1) { week = lists[0] as WeekRecord; } else{ week.WeekNum = num; } return week; // SimpleOrmOperator.Delete<WeekRecord>(id); }
protected void btnSave_Click(object sender, EventArgs e) { //WeekRecord week = new WeekRecord(); WeekRecord week = ViewState[VIEWSTATUE_WEEKRECORD] as WeekRecord; DateTime date = Convert.ToDateTime(this.txtDate.Value); // ArrayList weeks = SimpleOrmOperator.QueryConditionList<WeekRecord>(" where i_week_num="+GetWeekOfYear(date)); //if (weeks.Count > 0) // { // week = weeks[0] as WeekRecord; // } //else // { //week.Checked = 0; // } if (week.Checked == 0) { week.CheckOperator = this.Operator.OperatorName; week.WeekRange = DateTimeHelper.GetMonday(date).ToShortDateString() + "至" + DateTimeHelper.GetSunday(date).ToShortDateString(); week.WeekNum = DateTimeHelper.GetWeekOfYear(date); week.Week1km1Num = GetSl(this.txtxq1km1zs); week.Week1km1fp = this.Table1.Rows[2].Cells[2].Text; week.Week1km2Num = GetSl(this.txtxq1km2zs); week.Week1km2fp = this.Table1.Rows[2].Cells[4].Text; week.Week1km3Num = GetSl(this.txtxq1km3zs); week.Week1km3fp = this.Table1.Rows[2].Cells[6].Text; week.Week2km1Num = GetSl(this.txtxq2km1zs); week.Week2km1fp = this.Table1.Rows[3].Cells[2].Text; week.Week2km2Num = GetSl(this.txtxq2km2zs); week.Week2km2fp = this.Table1.Rows[3].Cells[4].Text; week.Week2km3Num = GetSl(this.txtxq2km3zs); week.Week2km3fp = this.Table1.Rows[3].Cells[6].Text; week.Week3km1Num = GetSl(this.txtxq3km1zs); week.Week3km1fp = this.Table1.Rows[4].Cells[2].Text; week.Week3km2Num = GetSl(this.txtxq3km2zs); week.Week3km2fp = this.Table1.Rows[4].Cells[4].Text; week.Week3km3Num = GetSl(this.txtxq3km3zs); week.Week3km3fp = this.Table1.Rows[4].Cells[6].Text; week.Week4km1Num = GetSl(this.txtxq4km1zs); week.Week4km1fp = this.Table1.Rows[5].Cells[2].Text; week.Week4km2Num = GetSl(this.txtxq4km2zs); week.Week4km2fp = this.Table1.Rows[5].Cells[4].Text; week.Week4km3Num = GetSl(this.txtxq4km3zs); week.Week4km3fp = this.Table1.Rows[5].Cells[6].Text; week.Week5km1Num = GetSl(this.txtxq5km1zs); week.Week5km1fp = this.Table1.Rows[6].Cells[2].Text; week.Week5km2Num = GetSl(this.txtxq5km2zs); week.Week5km2fp = this.Table1.Rows[6].Cells[4].Text; week.Week5km3Num = GetSl(this.txtxq5km3zs); week.Week5km3fp = this.Table1.Rows[6].Cells[6].Text; week.Week6km1Num = GetSl(this.txtxq6km1zs); week.Week6km1fp = this.Table1.Rows[7].Cells[2].Text; week.Week6km2Num = GetSl(this.txtxq6km2zs); week.Week6km2fp = this.Table1.Rows[7].Cells[4].Text; week.Week6km3Num = GetSl(this.txtxq6km3zs); week.Week6km3fp = this.Table1.Rows[7].Cells[6].Text; week.Week7km1Num = GetSl(this.txtxq7km1zs); week.Week7km1fp = this.Table1.Rows[8].Cells[2].Text; week.Week7km2Num = GetSl(this.txtxq7km2zs); week.Week7km2fp = this.Table1.Rows[8].Cells[4].Text; week.Week7km3Num = GetSl(this.txtxq7km3zs); week.Week7km3fp = this.Table1.Rows[8].Cells[6].Text; } ArrayList limits = ViewState[VIEWSTATUE_LIMITS] as ArrayList; if (week.Checked == 0 && week.Id > 0) { //WeekRecordOperator.Update(week); WeekRecordOperator.Update(week, limits); WebTools.Alert("保存成功!"); } else if (week.Id < 1) { WeekRecordOperator.Create(week, limits); WebTools.Alert("保存成功!"); } if (week.Checked == 1 && week.Id > 0) { WebTools.Alert("已审核过的排班无法进行更改!"); } }
public static bool Save(WeekRecord week, YuyueLimit limit, DateTime beginDate) { limit.Operator = week.CheckOperator; limit.Ksrq = beginDate.AddDays(limit.DayOfWeek - 1).ToString("yyyy-MM-dd"); return(SimpleOrmOperator.Create(limit)); }
private void InitWeekRecord(WeekRecord week) { string datestr = ""; if (week.Id <= 0) { datestr = this.txtDate.Value; // return; } else { datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); } DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); this.txtDate.Value = datestr; for (int i = 0; i < 7; i++) { this.Table1.Rows[i + 2].Cells[0].Text = this.GetChineseXq(i + 1) + "(" + begin.AddDays(i).ToString("yyyy-MM-dd") + ")"; } this.txtxq1km1zs.Text = week.Week1km1Num.ToString(); this.Table1.Rows[2].Cells[2].Text = this.ComputeLink(week, 1, 1); this.txtxq1km2zs.Text = week.Week1km2Num.ToString(); this.Table1.Rows[2].Cells[4].Text = this.ComputeLink(week, 1, 2); this.txtxq1km3zs.Text = week.Week1km3Num.ToString(); this.Table1.Rows[2].Cells[6].Text = this.ComputeLink(week, 1, 3); this.txtxq2km1zs.Text = week.Week2km1Num.ToString(); this.Table1.Rows[3].Cells[2].Text = this.ComputeLink(week, 2, 1); this.txtxq2km2zs.Text = week.Week2km2Num.ToString(); this.Table1.Rows[3].Cells[4].Text = this.ComputeLink(week, 2, 2); this.txtxq2km3zs.Text = week.Week2km3Num.ToString(); this.Table1.Rows[3].Cells[6].Text = this.ComputeLink(week, 2, 3); this.txtxq3km1zs.Text = week.Week3km1Num.ToString(); this.Table1.Rows[4].Cells[2].Text = this.ComputeLink(week, 3, 1); this.txtxq3km2zs.Text = week.Week3km2Num.ToString(); this.Table1.Rows[4].Cells[4].Text = this.ComputeLink(week, 3, 2); this.txtxq3km3zs.Text = week.Week3km3Num.ToString(); this.Table1.Rows[4].Cells[6].Text = this.ComputeLink(week, 3, 3); this.txtxq4km1zs.Text = week.Week4km1Num.ToString(); this.Table1.Rows[5].Cells[2].Text = this.ComputeLink(week, 4, 1); this.txtxq4km2zs.Text = week.Week4km2Num.ToString(); this.Table1.Rows[5].Cells[4].Text = this.ComputeLink(week, 4, 2); this.txtxq4km3zs.Text = week.Week4km3Num.ToString(); this.Table1.Rows[5].Cells[6].Text = this.ComputeLink(week, 4, 3); this.txtxq5km1zs.Text = week.Week5km1Num.ToString(); this.Table1.Rows[6].Cells[2].Text = this.ComputeLink(week, 5, 1); this.txtxq5km2zs.Text = week.Week5km2Num.ToString(); this.Table1.Rows[6].Cells[4].Text = this.ComputeLink(week, 5, 2); this.txtxq5km3zs.Text = week.Week5km3Num.ToString(); this.Table1.Rows[6].Cells[6].Text = this.ComputeLink(week, 5, 3); this.txtxq6km1zs.Text = week.Week6km1Num.ToString(); this.Table1.Rows[7].Cells[2].Text = this.ComputeLink(week, 6, 1); this.txtxq6km2zs.Text = week.Week6km2Num.ToString(); this.Table1.Rows[7].Cells[4].Text = this.ComputeLink(week, 6, 2); this.txtxq6km3zs.Text = week.Week6km3Num.ToString(); this.Table1.Rows[7].Cells[6].Text = this.ComputeLink(week, 6, 3); this.txtxq7km1zs.Text = week.Week7km1Num.ToString(); this.Table1.Rows[8].Cells[2].Text = this.ComputeLink(week, 7, 1); this.txtxq7km2zs.Text = week.Week7km2Num.ToString(); this.Table1.Rows[8].Cells[4].Text = this.ComputeLink(week, 7, 2); this.txtxq7km3zs.Text = week.Week7km3Num.ToString(); this.Table1.Rows[8].Cells[6].Text = this.ComputeLink(week, 7, 3); }
public static bool Save(WeekRecord week, YuyueLimit limit,DateTime beginDate) { limit.Operator = week.CheckOperator; limit.Ksrq = beginDate.AddDays(limit.DayOfWeek - 1).ToString("yyyy-MM-dd"); return SimpleOrmOperator.Create(limit); }
private void InitWeekRecord(WeekRecord week) { string datestr = ""; if (week.Id <= 0) { datestr = this.txtDate.Value; // return; } else { datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至')); } DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr)); this.txtDate.Value = datestr; for (int i = 0; i < 7; i++) { this.Table1.Rows[i + 2].Cells[0].Text = this.GetChineseXq(i + 1) + "(" + begin.AddDays(i).ToString("yyyy-MM-dd") + ")"; } this.txtxq1km1zs.Text = week.Week1km1Num.ToString(); this.Table1.Rows[2].Cells[2].Text = week.Week1km1fp == null ? " " : week.Week1km1fp.ToString(); this.txtxq1km2zs.Text = week.Week1km2Num.ToString(); this.Table1.Rows[2].Cells[4].Text = week.Week1km2fp == null ? " " : week.Week1km2fp.ToString(); this.txtxq1km3zs.Text = week.Week1km3Num.ToString(); this.Table1.Rows[2].Cells[6].Text = week.Week1km3fp == null ? " " : week.Week1km3fp.ToString(); this.txtxq2km1zs.Text = week.Week2km1Num.ToString(); this.Table1.Rows[3].Cells[2].Text = week.Week2km1fp == null ? " " : week.Week2km1fp.ToString(); this.txtxq2km2zs.Text = week.Week2km2Num.ToString(); this.Table1.Rows[3].Cells[4].Text = week.Week2km2fp == null ? " " : week.Week2km2fp.ToString(); this.txtxq2km3zs.Text = week.Week2km3Num.ToString(); this.Table1.Rows[3].Cells[6].Text = week.Week2km3fp == null ? " " : week.Week2km3fp.ToString(); this.txtxq3km1zs.Text = week.Week3km1Num.ToString(); this.Table1.Rows[4].Cells[2].Text = week.Week3km1fp == null ? " " : week.Week3km1fp.ToString(); this.txtxq3km2zs.Text = week.Week3km2Num.ToString(); this.Table1.Rows[4].Cells[4].Text = week.Week3km2fp == null ? " " : week.Week3km2fp.ToString(); this.txtxq3km3zs.Text = week.Week3km3Num.ToString(); this.Table1.Rows[4].Cells[6].Text = week.Week3km3fp == null ? " " : week.Week3km3fp.ToString(); this.txtxq4km1zs.Text = week.Week4km1Num.ToString(); this.Table1.Rows[5].Cells[2].Text = week.Week4km1fp == null ? " " : week.Week4km1fp.ToString(); this.txtxq4km2zs.Text = week.Week4km2Num.ToString(); this.Table1.Rows[5].Cells[4].Text = week.Week4km2fp == null ? " " : week.Week4km2fp.ToString(); this.txtxq4km3zs.Text = week.Week4km3Num.ToString(); this.Table1.Rows[5].Cells[6].Text = week.Week4km3fp == null ? " " : week.Week4km3fp.ToString(); this.txtxq5km1zs.Text = week.Week5km1Num.ToString(); this.Table1.Rows[6].Cells[2].Text = week.Week5km1fp == null ? " " : week.Week5km1fp.ToString(); this.txtxq5km2zs.Text = week.Week5km2Num.ToString(); this.Table1.Rows[6].Cells[4].Text = week.Week5km2fp == null ? " " : week.Week5km2fp.ToString(); this.txtxq5km3zs.Text = week.Week5km3Num.ToString(); this.Table1.Rows[6].Cells[6].Text = week.Week5km3fp == null ? " " : week.Week5km3fp.ToString(); this.txtxq6km1zs.Text = week.Week6km1Num.ToString(); this.Table1.Rows[7].Cells[2].Text = week.Week6km1fp == null ? " " : week.Week6km1fp.ToString(); this.txtxq6km2zs.Text = week.Week6km2Num.ToString(); this.Table1.Rows[7].Cells[4].Text = week.Week6km2fp == null ? " " : week.Week6km2fp.ToString(); this.txtxq6km3zs.Text = week.Week6km3Num.ToString(); this.Table1.Rows[7].Cells[6].Text = week.Week6km3fp == null ? " " : week.Week6km3fp.ToString(); this.txtxq7km1zs.Text = week.Week7km1Num.ToString(); this.Table1.Rows[8].Cells[2].Text = week.Week7km1fp == null ? " " : week.Week7km1fp.ToString(); this.txtxq7km2zs.Text = week.Week7km2Num.ToString(); this.Table1.Rows[8].Cells[4].Text = week.Week7km2fp == null ? " " : week.Week7km2fp.ToString(); this.txtxq7km3zs.Text = week.Week7km3Num.ToString(); this.Table1.Rows[8].Cells[6].Text = week.Week7km3fp == null ? " " : week.Week7km3fp.ToString(); }