예제 #1
0
        /// <summary>
        /// 加载页面信息
        /// </summary>
        private void BindShow()
        {
            string id = Request.QueryString["id"];

            if (!string.IsNullOrEmpty(id))
            {
                Sys_HolidayBLL bllHoliday = new Sys_HolidayBLL();
                Sys_Holiday    model      = bllHoliday.Find(p => p.HolidayId == id);
                if (model == null)
                {
                    MessageBox.ShowAndRedirect(this, "该数据不存在!", "HolidayList.aspx");
                }
                else
                {
                    txtHoliday_Name.Text      = model.Holiday_Name;
                    txtHoliday_StartDate.Text = Convert.ToDateTime(model.Holiday_StartDate).ToString("yyyy年MM月dd日");
                    txtHoliday_EndDate.Text   = Convert.ToDateTime(model.Holiday_EndDate).ToString("yyyy年MM月dd日");
                }
            }
        }
예제 #2
0
        /// <summary>
        /// 保存按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnAdd_Click(object sender, ImageClickEventArgs e)
        {
            string         id         = Request.QueryString["id"];
            string         msg        = string.Empty;
            Sys_HolidayBLL bllHoliday = new Sys_HolidayBLL();
            StringBuilder  strWhere   = new StringBuilder();
            string         startDate  = Convert.ToDateTime(txtHoliday_StartDate.Text.Trim()).ToString("yyyy-MM-dd") + " 00:00:00";
            string         endDate    = Convert.ToDateTime(txtHoliday_EndDate.Text.Trim()).ToString("yyyy-MM-dd") + " 23:59:59";

            strWhere.AppendFormat(" ('{0}' <= Holiday_EndDate AND '{1}' >= Holiday_StartDate AND '{0}' <= '{1}' ) AND HolidayId <> '{2}' ", startDate, endDate, id);
            //获取待保存的“节假日时间段”是否与其它节假日时间段有交集
            List <Sys_Holiday> list = bllHoliday.FindWhere(strWhere.ToString());

            if (list.Count > 0)
            {
                MessageBox.Show(this, "此节假日时间段与其它节假日时间段存在交集,无法保存!");
                return;
            }

            //编辑保存
            if (!string.IsNullOrEmpty(id))
            {
                Sys_Holiday model = bllHoliday.Find(p => p.HolidayId == id);
                model.Holiday_Name         = txtHoliday_Name.Text.Trim();
                model.Holiday_StartDate    = Convert.ToDateTime(startDate);
                model.Holiday_EndDate      = Convert.ToDateTime(endDate);
                model.Holiday_UpdateTime   = DateTime.Now;
                model.Holiday_UpdateUserId = base.CurrUserInfo().UserID;
                bool bol = bllHoliday.Update(model, out msg);
                if (bol)
                {
                    MessageBox.ShowAndRedirect(this, "保存成功!", "HolidayList.aspx");
                }
                else
                {
                    MessageBox.Show(this, msg);
                }
            }
            else  //新增保存
            {
                Sys_Holiday model = new Sys_Holiday();
                model.HolidayId            = Guid.NewGuid().ToString();
                model.Holiday_Name         = txtHoliday_Name.Text.Trim();
                model.Holiday_StartDate    = Convert.ToDateTime(startDate);
                model.Holiday_EndDate      = Convert.ToDateTime(endDate);
                model.Holiday_UpdateTime   = DateTime.Now;
                model.Holiday_UpdateUserId = base.CurrUserInfo().UserID;
                model.Holiday_IsDelete     = false;
                bool bol = bllHoliday.Add(model, out msg);
                if (bol)
                {
                    txtHoliday_Name.Text      = "";
                    txtHoliday_StartDate.Text = "";
                    txtHoliday_EndDate.Text   = "";
                    MessageBox.Show(this, "保存成功!请继续添加。");
                }
                else
                {
                    MessageBox.Show(this, msg);
                }
            }
        }