private void AddLeave(HttpContext context)
{
context.Response.ContentType = "text/plain";
int LeaveTypeID = int.Parse(context.Request.Params["LeaveType"].ToString());
string LeaveReason = context.Request.Params["LeaveReason"];
string ApprovalPerson = context.Request.Params["ApprovalPerson"];
DateTime?BeginTime = DateTime.Parse(context.Request.Params["BeginTime"]);
DateTime?EndTime = DateTime.Parse(context.Request.Params["EndTime"]);
int leavestatus = 0;
bll = new BLL.Sys_LeavesBLL();
model = new Model.Sys_Leaves();
model.ApplyPerson = context.Session["uLoginName"].ToString();
model.LeaveReason = LeaveReason;
model.LeaveStatus = leavestatus;
model.LeaveTypeID = LeaveTypeID;
model.ApplyTime = DateTime.Now;
model.BeginTime = BeginTime;
model.EndTime = EndTime;
model.ApprovalPerson = ApprovalPerson;
int codeNum = bll.Add(model);
if (codeNum > 0)
{
context.Response.Write("ok");
context.Response.End();
}
else
{
context.Response.Write("no");
return;
}
}
/// <summary>
/// 获取假期申请数据列表
/// </summary>
/// <returns></returns>
public void GetLeavesInfo()
{
int leaveId = Convert.ToInt32(Id);
model_leave = bll_leave.GetModel(leaveId);
BeginTime = string.Format("{0:u}", model_leave.BeginTime).Split(' ')[0].Replace('-', '/');
EndTime = string.Format("{0:u}", model_leave.EndTime).Split(' ')[0];
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Sys_Leaves GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,LeaveReason,LeaveTypeID,ApplyTime,ApprovalPerson,BeginTime,EndTime,LeaveStatus,CancelLeaveTime,ApplyPerson from Sys_Leaves ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Model.Sys_Leaves model = new Model.Sys_Leaves();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.Sys_Leaves model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Sys_Leaves model)
{
return(dal.Add(model));
}
