/// <summary> /// 根据假日ID,更新假日 /// </summary> /// <param name="info">要更新的假日对象</param> /// <returns></returns> public bool Update(RestDate info) { bool _Result = true; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_UserId, OleDbType.Integer), new OleDbParameter(Parm_RestDate, OleDbType.Date), new OleDbParameter(Parm_CycleNum, OleDbType.Integer), new OleDbParameter(Parm_RestDetail, OleDbType.VarChar, 50), new OleDbParameter(Parm_Type, OleDbType.VarChar, 50), new OleDbParameter(Parm_Remark, OleDbType.VarChar, 100), new OleDbParameter(Parm_RestId, OleDbType.Integer), }; parms[0].Value = info.UserId; parms[1].Value = info.Rest_Date; parms[2].Value = info.CycleNum; parms[3].Value = info.RestDetail; parms[4].Value = info.Type; parms[5].Value = info.Remark; parms[6].Value = info.RestID; AccessHelper.ExecuteNonQuery(AccessHelper.CONN_STRING, CommandType.Text, SQL_Update_RestDate, parms); } catch (Exception ex) { _Result = false; throw ex; } return(_Result); }
/// <summary> /// 添加假期 /// </summary> /// <param name="pDate">假期对象</param> /// <returns></returns> private bool AddRestDate(RestDate pDate) { if (pDate == null) { return(false); } NetRestDate _netRestDate = new NetRestDate(); if (_netRestDate.Insert(pDate)) { return(true); } else { return(false); } }
private List <RestDate> GetRestDateListByUserId(string pBeginDate, int pUserId) { NetRestDate _net = new NetRestDate(); DataSet _ds = _net.GetRestDateDataSet(pBeginDate, string.Empty, string.Empty, pUserId); if (_ds.Tables == null || _ds.Tables.Count == 0) { return(null); } int _count = _ds.Tables[0].Rows.Count; List <RestDate> _restDateList = new List <RestDate>(); for (int i = 0; i < _count; i++) { RestDate _rest = new RestDate(); _rest.Rest_Date = Convert.ToDateTime(_ds.Tables[0].Rows[i]["RestDate"]); _rest.RestDetail = _ds.Tables[0].Rows[i]["RestDetail"].ToString(); _restDateList.Add(_rest); } return(_restDateList); }
private const string parm_RestDate = "@RestDate"; //要保存的假日日期 #endregion #region 操作方法 /// <summary> /// 添加假日信息 /// </summary> /// <param name="info">传入RestDate对象</param> /// <returns></returns> public bool Insert(RestDate info) { bool _Result = true; int _count = this.GetRestDateCount(info.Rest_Date.ToShortDateString()); if (_count > 0) { return(false); } try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_UserId, OleDbType.Integer), new OleDbParameter(Parm_RestDate, OleDbType.Date), new OleDbParameter(Parm_CycleNum, OleDbType.Integer), new OleDbParameter(Parm_RestDetail, OleDbType.VarChar, 50), new OleDbParameter(Parm_Type, OleDbType.VarChar, 50), new OleDbParameter(Parm_Remark, OleDbType.VarChar, 100), }; parms[0].Value = info.UserId; parms[1].Value = info.Rest_Date; parms[2].Value = info.CycleNum; parms[3].Value = info.RestDetail; parms[4].Value = info.Type; parms[5].Value = info.Remark; AccessHelper.ExecuteNonQuery(AccessHelper.CONN_STRING, CommandType.Text, SQL_Insert_RestDate, parms); } catch (Exception ex) { _Result = false; } return(_Result); }
protected void btn_addDate_ServerClick(object sender, EventArgs e) { //判断是否空值 if (this.text_restDate.Value.Trim() == string.Empty || this.DropDownList_type.SelectedIndex == 0) { Response.Write("<script> alert(\"输入假日日期或类型出错,请重试!\");</script>"); return; } RestDate _date = new RestDate(); _date.UserId = int.Parse(this.drop_UserList.SelectedValue.Trim()); string _userName = this.drop_UserList.SelectedItem.Text.Trim(); DateTime _restDate = DateTime.Today; DateTime _endDate = DateTime.Today; try { _restDate = Convert.ToDateTime(this.text_restDate.Value.Trim()); } catch (Exception ex) { Response.Write("<script> alert(\"输入假日日期出错,请重试!\");</script>"); return; } try { _endDate = Convert.ToDateTime(this.Text_allEndDate.Value.Trim()); } catch (Exception ex) { Response.Write("<script> alert(\"输入截止日期出错,请重试!\");</script>"); return; } if (_restDate > _endDate) { Response.Write("<script> alert (\"假日日期不能大于截止日期,请修改!\");</script>"); return; } _date.Rest_Date = _restDate; _date.RestDetail = this.DropDownList_resetDetail.SelectedValue; _date.Remark = this.Text_remark.Value; _date.Type = this.DropDownList_type.SelectedValue; if (_date.UserId == -1 && (_date.Type == "个人请假" || _date.Type == "个人出差" || _date.Type == "个人其他")) { Response.Write("<script> alert(\"'所有人'不可能是'" + _date.Type + "'!\");</script>"); return; } if (_date.UserId != -1 && (_date.Type == "周六" || _date.Type == "周日" || _date.Type == "法定节假" || _date.Type == "其他节假")) { Response.Write("<script> alert(\"'" + _userName + "'不可能是'" + _date.Type + "'!\");</script>"); return; } if (this.DropDownList_type.SelectedValue.Trim() == "周六") { _date.CycleNum = 14; if (_restDate.DayOfWeek != DayOfWeek.Saturday) { Response.Write("<script> alert(\"'" + _date.Rest_Date.ToShortDateString() + "'不是周六!\");</script>"); return; } } else if (this.DropDownList_type.SelectedValue.Trim() == "周日") { _date.CycleNum = 7; if (_restDate.DayOfWeek != DayOfWeek.Sunday) { Response.Write("<script> alert(\"'" + _date.Rest_Date.ToShortDateString() + "'不是周日!\");</script>"); return; } } else if (this.DropDownList_type.SelectedValue.Trim() == "个人出差") { _date.CycleNum = 1; } else { _date.CycleNum = 0; } if (m_isUpdate) { _date.RestID = m_RestID; NetRestDate _net = new NetRestDate(); if (_net.Update(_date)) { if (_date.UserId != -1 && _date.Type == "个人请假") { Response.Write("<script> alert(\"修改'" + _userName + "'请假成功!\");</script>"); } else { Response.Write("<script> alert(\"修改'" + _date.Type + "'成功!\");</script>"); } } else { Response.Write("<script> alert(\"'" + _date.Rest_Date.ToShortDateString() + "'修改失败,请重试!\");</script>"); } } else { if (_date.CycleNum == 0) //法定假日和个人请假情况 { if (this.AddRestDate(_date)) { if (_date.UserId != -1 && _date.Type == "个人请假") { Response.Write("<script> alert(\"'" + _userName + "'请假成功!\");</script>"); } else { Response.Write("<script> alert(\"添加'" + _date.Type + "'成功!\");</script>"); } } else { if (_date.UserId != -1 && _date.Type == "个人请假") { Response.Write("<script> alert(\"'" + _date.Rest_Date.ToShortDateString() + "'已经是假日,无需请假!\");</script>"); } else { Response.Write("<script> alert(\"'" + _date.Rest_Date.ToShortDateString() + "'已经添加过!\");</script>"); } } } else // 周六和周日情况 { DateTime _weekDate = _restDate; while (_weekDate <= _endDate) { this.AddRestDate(_date); _weekDate = _weekDate.AddDays(_date.CycleNum); _date.Rest_Date = _weekDate; } Response.Write("<script> alert(\"添加''" + _date.Type + "成功!\");</script>"); } } this.InitializePage(); this.ReflashRestDateList(); }
public override string ToString() { return($"update:{Requester},{WorkDate.ToShortDateString()},{WorkTime}" + $",{RestDate.ToShortDateString()},{RestTime}" + $",{Remarks}"); }