/// <summary>
/// 编辑请假信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmission_Click(object sender, EventArgs e)
{
use = (U_User)Session["U_USER"];
int i = use.UID;
int dp = use.DID.DID;
U_Leave le = new U_Leave();
U_User u = new U_User();
u.UID = i;
le.UID = u;
U_Department d = new U_Department();
d.DID = dp;
le.DID = d;
le.LReason = this.TbReason.Text.Trim();
le.BeginTime = this.TbAoginTime.Text.Trim();
le.EndTime = this.TbEndTime.Text.Trim();
le.Remark = this.TbRemark.Text.Trim();
if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(TbAoginTime.Text) || string.IsNullOrEmpty(this.TbEndTime.Text) || string.IsNullOrEmpty(this.TbRemark.Text))
{
JsMessage.jsAlert("请假信息不能为空，请填写完整！");
return;
}
if (new UserBll().AddUserLeave(le) > 0)
{
JsMessage.jsAlert("添加成功！");
}
this.TbReason.Text = "";
this.TbAoginTime.Text = "";
this.TbEndTime.Text = "";
this.TbRemark.Text = "";
}
/// <summary>
/// 查询所有请假信息
/// </summary>
/// <returns></returns>
public List <U_Leave> H_selLeave()
{
List <U_Leave> le = new List <U_Leave>();
try
{
string sql = "select * from [dbo].[U_Leave] as a left join [dbo].[U_UserInfor] as b on a.UID=b.UID left join [dbo].[U_Department] as c on a.DID=c.DID order by a.BeginTime desc";
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
U_Leave l = new U_Leave();
l.LID = int.Parse(reader["LID"].ToString());
U_User user = new U_User();
user.UID = int.Parse(reader["UID"].ToString());
user.UserName = reader["UserName"].ToString();
l.UID = user;
U_Department d = new U_Department();
d.DID = int.Parse(reader["DID"].ToString());
d.DName = reader["DName"].ToString();
l.DID = d;
l.LReason = reader["LReason"].ToString();
l.BeginTime = reader["BeginTime"].ToString();
l.EndTime = reader["EndTime"].ToString();
l.Month = reader["Month"].ToString();
l.Remark = reader["Remark"].ToString();
l.State = reader["State"].ToString();
le.Add(l);
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
return(le);
}
/// <summary>
/// 添加请假信息
/// </summary>
/// <param name="l"></param>
/// <returns></returns>
public int AddUserLeave(U_Leave l)
{
try
{
SqlParameter[] sql = new SqlParameter[]
{
new SqlParameter("@UID", l.UID.UID),
new SqlParameter("@DID", l.DID.DID),
new SqlParameter("@LReason", l.LReason),
new SqlParameter("@BeginTime", l.BeginTime),
new SqlParameter("@EndTime", l.EndTime),
new SqlParameter("@Remark", l.Remark)
};
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "AddUserLeave", sql));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 通过员工名字进行模糊查询
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <U_Leave> H_selLeaveByName(string name)
{
List <U_Leave> le = new List <U_Leave>();
try
{
SqlParameter[] mySql = new SqlParameter[]
{
new SqlParameter("@UserName", name)
};
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "H_selLeaveByName", mySql);
while (reader.Read())
{
U_Leave l = new U_Leave();
l.LID = int.Parse(reader["LID"].ToString());
U_User user = new U_User();
user.UID = int.Parse(reader["UID"].ToString());
user.UserName = reader["UserName"].ToString();
l.UID = user;
U_Department d = new U_Department();
d.DID = int.Parse(reader["DID"].ToString());
d.DName = reader["DName"].ToString();
l.DID = d;
l.LReason = reader["LReason"].ToString();
l.BeginTime = reader["BeginTime"].ToString();
l.EndTime = reader["EndTime"].ToString();
l.Month = reader["Month"].ToString();
l.Remark = reader["Remark"].ToString();
l.State = reader["State"].ToString();
le.Add(l);
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
return(le);
}
/// <summary>
/// 添加请假信息
/// </summary>
/// <param name="l"></param>
/// <returns></returns>
public int AddUserLeave(U_Leave l)
{
return(ud.AddUserLeave(l));
}
