/// <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}");
}
