コード例 #1
0
    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);
    }
コード例 #2
0
        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));
        }
コード例 #3
0
    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();
    }
コード例 #4
0
    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();
    }
コード例 #5
0
ファイル: PaibanCheck.aspx.cs プロジェクト: radtek/fivemen
    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("已审核的记录无法审核!");
        }
    }
コード例 #6
0
ファイル: WeekRecordOperator.cs プロジェクト: radtek/fivemen
    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);
    }
コード例 #7
0
 private void ChangeWeekRecord(WeekRecord weekRecord)
 {
     foreach (var _weekRecord in WeekRecords.ToList())
     {
         if (_weekRecord.StartDateOfWeek.Date == weekRecord.StartDateOfWeek.Date)
         {
             _weekRecord.DayRecords = weekRecord.DayRecords;
         }
     }
 }
コード例 #8
0
 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);
     }
 }
コード例 #9
0
ファイル: PaibanCheck.aspx.cs プロジェクト: radtek/fivemen
 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);
         }
     }
 }
コード例 #10
0
ファイル: WeekRecordOperator.cs プロジェクト: radtek/fivemen
    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);
        }
    }
コード例 #11
0
 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;
 }
コード例 #12
0
ファイル: WeekRecordOperator.cs プロジェクト: radtek/fivemen
    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);
        }
    }
コード例 #13
0
ファイル: WeekRecordOperator.cs プロジェクト: radtek/fivemen
    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);
    }
コード例 #14
0
        public RecordDetailViewModel(INavigation navigation, WeekRecord weekRecord, IEnumerable <Record> allRecords, IMessageBoxService messageBoxService) : base(navigation)
        {
            ConstructCommand();

            MessageBoxService = messageBoxService;

            Records = allRecords.ToList();

            WeekRecord = weekRecord;

            CreateTagItems();

            SetDayRecords();

            InitRecordsForSearch();
        }
コード例 #15
0
ファイル: YuyueLimitOperator.cs プロジェクト: radtek/fivemen
    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);
    }
コード例 #16
0
        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));
        }
コード例 #17
0
ファイル: YuyueLimitOperator.cs プロジェクト: radtek/fivemen
    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);
    }
コード例 #18
0
    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);

        }
    }
コード例 #19
0
    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);
    }
コード例 #20
0
ファイル: PaibanEdit.aspx.cs プロジェクト: radtek/fivemen
 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;
         }
     }
 }
コード例 #21
0
        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));
        }
コード例 #22
0
ファイル: PaibanEdit.aspx.cs プロジェクト: radtek/fivemen
    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!");
            }
        }
    }
コード例 #23
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);
     }
 }
コード例 #24
0
ファイル: WeekRecordOperator.cs プロジェクト: radtek/fivemen
    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);
    }
コード例 #25
0
ファイル: PaibanEdit.aspx.cs プロジェクト: romanu6891/fivemen
    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 ? "&nbsp;" : week.Week1km1fp.ToString();
        this.txtxq1km2zs.Text=week.Week1km2Num.ToString();
        this.Table1.Rows[2].Cells[4].Text = week.Week1km2fp == null ? "&nbsp;" : week.Week1km2fp.ToString();
        this.txtxq1km3zs.Text = week.Week1km3Num .ToString();
        this.Table1.Rows[2].Cells[6].Text = week.Week1km3fp == null ? "&nbsp;" : week.Week1km3fp.ToString();

        this.txtxq2km1zs.Text = week.Week2km1Num.ToString();
        this.Table1.Rows[3].Cells[2].Text = week.Week2km1fp == null ? "&nbsp;" : week.Week2km1fp.ToString();
        this.txtxq2km2zs.Text = week.Week2km2Num.ToString();
        this.Table1.Rows[3].Cells[4].Text = week.Week2km2fp == null ? "&nbsp;" : week.Week2km2fp.ToString();
        this.txtxq2km3zs.Text = week.Week2km3Num.ToString();
        this.Table1.Rows[3].Cells[6].Text = week.Week2km3fp == null ? "&nbsp;" : week.Week2km3fp.ToString();

        this.txtxq3km1zs.Text = week.Week3km1Num.ToString();
        this.Table1.Rows[4].Cells[2].Text = week.Week3km1fp == null ? "&nbsp;" : week.Week3km1fp.ToString();
        this.txtxq3km2zs.Text = week.Week3km2Num.ToString();
        this.Table1.Rows[4].Cells[4].Text = week.Week3km2fp == null ? "&nbsp;" : week.Week3km2fp.ToString();
        this.txtxq3km3zs.Text = week.Week3km3Num.ToString();
        this.Table1.Rows[4].Cells[6].Text = week.Week3km3fp == null ? "&nbsp;" : week.Week3km3fp.ToString();

        this.txtxq4km1zs.Text = week.Week4km1Num.ToString();
        this.Table1.Rows[5].Cells[2].Text = week.Week4km1fp == null ? "&nbsp;" : week.Week4km1fp.ToString();
        this.txtxq4km2zs.Text = week.Week4km2Num.ToString();
        this.Table1.Rows[5].Cells[4].Text = week.Week4km2fp == null ? "&nbsp;" : week.Week4km2fp.ToString();
        this.txtxq4km3zs.Text = week.Week4km3Num.ToString();
        this.Table1.Rows[5].Cells[6].Text = week.Week4km3fp == null ? "&nbsp;" : week.Week4km3fp.ToString();

        this.txtxq5km1zs.Text = week.Week5km1Num.ToString();
        this.Table1.Rows[6].Cells[2].Text = week.Week5km1fp == null ? "&nbsp;" : week.Week5km1fp.ToString();
        this.txtxq5km2zs.Text = week.Week5km2Num.ToString();
        this.Table1.Rows[6].Cells[4].Text = week.Week5km2fp == null ? "&nbsp;" : week.Week5km2fp.ToString();
        this.txtxq5km3zs.Text = week.Week5km3Num.ToString();
        this.Table1.Rows[6].Cells[6].Text = week.Week5km3fp == null ? "&nbsp;" : week.Week5km3fp.ToString();

        this.txtxq6km1zs.Text = week.Week6km1Num.ToString();
        this.Table1.Rows[7].Cells[2].Text = week.Week6km1fp == null ? "&nbsp;" : week.Week6km1fp.ToString();
        this.txtxq6km2zs.Text = week.Week6km2Num.ToString();
        this.Table1.Rows[7].Cells[4].Text = week.Week6km2fp == null ? "&nbsp;" : week.Week6km2fp.ToString();
        this.txtxq6km3zs.Text = week.Week6km3Num.ToString();
        this.Table1.Rows[7].Cells[6].Text = week.Week6km3fp == null ? "&nbsp;" : week.Week6km3fp.ToString();

        this.txtxq7km1zs.Text = week.Week7km1Num.ToString();
        this.Table1.Rows[8].Cells[2].Text = week.Week7km1fp == null ? "&nbsp;" : week.Week7km1fp.ToString();
        this.txtxq7km2zs.Text = week.Week7km2Num.ToString();
        this.Table1.Rows[8].Cells[4].Text = week.Week7km2fp == null ? "&nbsp;" : week.Week7km2fp.ToString();
        this.txtxq7km3zs.Text = week.Week7km3Num.ToString();
        this.Table1.Rows[8].Cells[6].Text = week.Week7km3fp == null ? "&nbsp;" : week.Week7km3fp.ToString();
    }
コード例 #26
0
    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);




    }
コード例 #27
0
    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);
    }
コード例 #28
0
    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);
        }
    }
コード例 #29
0
 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);
 }
コード例 #30
0
ファイル: PaibanEdit.aspx.cs プロジェクト: radtek/fivemen
    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("已审核过的排班无法进行更改!");
        }
    }
コード例 #31
0
ファイル: YuyueLimitOperator.cs プロジェクト: radtek/fivemen
 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));
 }
コード例 #32
0
    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);
    }
コード例 #33
0
 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);
 }
コード例 #34
0
ファイル: PaibanCheck.aspx.cs プロジェクト: radtek/fivemen
    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 ? "&nbsp;" : week.Week1km1fp.ToString();
        this.txtxq1km2zs.Text             = week.Week1km2Num.ToString();
        this.Table1.Rows[2].Cells[4].Text = week.Week1km2fp == null ? "&nbsp;" : week.Week1km2fp.ToString();
        this.txtxq1km3zs.Text             = week.Week1km3Num.ToString();
        this.Table1.Rows[2].Cells[6].Text = week.Week1km3fp == null ? "&nbsp;" : week.Week1km3fp.ToString();

        this.txtxq2km1zs.Text             = week.Week2km1Num.ToString();
        this.Table1.Rows[3].Cells[2].Text = week.Week2km1fp == null ? "&nbsp;" : week.Week2km1fp.ToString();
        this.txtxq2km2zs.Text             = week.Week2km2Num.ToString();
        this.Table1.Rows[3].Cells[4].Text = week.Week2km2fp == null ? "&nbsp;" : week.Week2km2fp.ToString();
        this.txtxq2km3zs.Text             = week.Week2km3Num.ToString();
        this.Table1.Rows[3].Cells[6].Text = week.Week2km3fp == null ? "&nbsp;" : week.Week2km3fp.ToString();

        this.txtxq3km1zs.Text             = week.Week3km1Num.ToString();
        this.Table1.Rows[4].Cells[2].Text = week.Week3km1fp == null ? "&nbsp;" : week.Week3km1fp.ToString();
        this.txtxq3km2zs.Text             = week.Week3km2Num.ToString();
        this.Table1.Rows[4].Cells[4].Text = week.Week3km2fp == null ? "&nbsp;" : week.Week3km2fp.ToString();
        this.txtxq3km3zs.Text             = week.Week3km3Num.ToString();
        this.Table1.Rows[4].Cells[6].Text = week.Week3km3fp == null ? "&nbsp;" : week.Week3km3fp.ToString();

        this.txtxq4km1zs.Text             = week.Week4km1Num.ToString();
        this.Table1.Rows[5].Cells[2].Text = week.Week4km1fp == null ? "&nbsp;" : week.Week4km1fp.ToString();
        this.txtxq4km2zs.Text             = week.Week4km2Num.ToString();
        this.Table1.Rows[5].Cells[4].Text = week.Week4km2fp == null ? "&nbsp;" : week.Week4km2fp.ToString();
        this.txtxq4km3zs.Text             = week.Week4km3Num.ToString();
        this.Table1.Rows[5].Cells[6].Text = week.Week4km3fp == null ? "&nbsp;" : week.Week4km3fp.ToString();

        this.txtxq5km1zs.Text             = week.Week5km1Num.ToString();
        this.Table1.Rows[6].Cells[2].Text = week.Week5km1fp == null ? "&nbsp;" : week.Week5km1fp.ToString();
        this.txtxq5km2zs.Text             = week.Week5km2Num.ToString();
        this.Table1.Rows[6].Cells[4].Text = week.Week5km2fp == null ? "&nbsp;" : week.Week5km2fp.ToString();
        this.txtxq5km3zs.Text             = week.Week5km3Num.ToString();
        this.Table1.Rows[6].Cells[6].Text = week.Week5km3fp == null ? "&nbsp;" : week.Week5km3fp.ToString();

        this.txtxq6km1zs.Text             = week.Week6km1Num.ToString();
        this.Table1.Rows[7].Cells[2].Text = week.Week6km1fp == null ? "&nbsp;" : week.Week6km1fp.ToString();
        this.txtxq6km2zs.Text             = week.Week6km2Num.ToString();
        this.Table1.Rows[7].Cells[4].Text = week.Week6km2fp == null ? "&nbsp;" : week.Week6km2fp.ToString();
        this.txtxq6km3zs.Text             = week.Week6km3Num.ToString();
        this.Table1.Rows[7].Cells[6].Text = week.Week6km3fp == null ? "&nbsp;" : week.Week6km3fp.ToString();

        this.txtxq7km1zs.Text             = week.Week7km1Num.ToString();
        this.Table1.Rows[8].Cells[2].Text = week.Week7km1fp == null ? "&nbsp;" : week.Week7km1fp.ToString();
        this.txtxq7km2zs.Text             = week.Week7km2Num.ToString();
        this.Table1.Rows[8].Cells[4].Text = week.Week7km2fp == null ? "&nbsp;" : week.Week7km2fp.ToString();
        this.txtxq7km3zs.Text             = week.Week7km3Num.ToString();
        this.Table1.Rows[8].Cells[6].Text = week.Week7km3fp == null ? "&nbsp;" : week.Week7km3fp.ToString();
    }