/// <summary>
/// 查询所有辞职信息
/// </summary>
/// <returns></returns>
public List <U_Resignation> H_selResignation()
{
List <U_Resignation> re = new List <U_Resignation>();
try
{
string sql = "select a.RID,a.UID,a.DID,a.Reason,a.Time,a.Remark,b.UserName,b.DID,case when b.State=0 then '正常' else '停用'end as st ,c.* from [dbo].[U_ResignationInfo] 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 Time desc";
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null);
while (reader.Read())
{
U_Resignation r = new U_Resignation();
r.RID = int.Parse(reader["RID"].ToString());
U_User user = new U_User();
user.UID = int.Parse(reader["UID"].ToString());
user.UserName = reader["UserName"].ToString();
user.State = reader["st"].ToString();
//user.DID = int.Parse(reader["DID"].ToString());
r.UID = user;
U_Department d = new U_Department();
d.DID = int.Parse(reader["DID"].ToString());
d.DName = reader["DName"].ToString();
r.DID = d;
r.Reason = reader["Reason"].ToString();
r.Time = DateTime.Parse(reader["Time"].ToString());
r.Remark = reader["Remark"].ToString();
r.State = reader["Remark"].ToString();
re.Add(r);
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
return(re);
}
/// <summary>
/// 确认提交信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmission_Click(object sender, EventArgs e)
{
U_Resignation re = new U_Resignation();
if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(this.TbTime.Text))
{
JsMessage.jsAlert("辞职信息不能为空！");
return;
}
use = (U_User)Session["U_USER"];
int i = use.UID;
int dp = use.DID.DID;
U_User u = new U_User();
u.UID = i;
re.UID = u;
U_Department d = new U_Department();
d.DID = dp;
re.DID = d;
re.Reason = this.TbReason.Text.ToString();
re.Time = Convert.ToDateTime(this.TbTime.Text.ToString());
re.Remark = this.TbRemark.Text.Trim();
re.State = "null";
if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(this.TbTime.Text))
{
JsMessage.jsAlert("辞职信息不能为空！");
return;
}
DataTable r = new HrBll().H_SelResignations(i);
//U_User us = new U_User();
//us.UID=
//int uid = r.UID.UID;
if (r.Rows.Count == 1)
{
JsMessage.jsAlert("你已经发送过辞职信息了,不能反复发送！");
return;
}
if (new UserBll().U_AddResigntion(re) > 0)
{
JsMessage.jsAlert("编辑成功！");
use = (U_User)Session["U_USER"];
M_JournalInfo ji = new Model.M_JournalInfo();
ji.Content = use.UserName + "编辑辞职信息！";
ji.ReleaseTime = DateTime.Now.ToLocalTime();
ji.LoginName = use.LoginName;
new UserBll().AddJournalInfo(ji);
return;
}
//清空所有信息
this.TbReason.Text = "";
this.TbRemark.Text = "";
this.TbTime.Text = "";
}
/// <summary>
/// 添加辞职信息
/// </summary>
/// <param name="re"></param>
/// <returns></returns>
public int U_AddResigntion(U_Resignation re)
{
try
{
SqlParameter[] sql = new SqlParameter[]
{
new SqlParameter("@UID", re.UID.UID),
new SqlParameter("@DID", re.DID.DID),
new SqlParameter("@Reason", re.Reason),
new SqlParameter("@Time", re.Time),
new SqlParameter("@Remark", re.Remark),
new SqlParameter("@State", re.State)
};
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "U_AddResigntion", sql));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 根据名字模糊查询辞职信息
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <U_Resignation> H_SelReasontionByName(string name)
{
List <U_Resignation> re = new List <U_Resignation>();
try
{
SqlParameter[] mySql = new SqlParameter[]
{
new SqlParameter("@UserName", name)
};
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "H_SelResignationByName", mySql);
while (reader.Read())
{
U_Resignation r = new U_Resignation();
r.RID = int.Parse(reader["RID"].ToString());
U_User user = new U_User();
user.UID = int.Parse(reader["UID"].ToString());
user.UserName = reader["UserName"].ToString();
user.State = reader["st"].ToString();
//user.DID = int.Parse(reader["DID"].ToString());
r.UID = user;
U_Department d = new U_Department();
d.DID = int.Parse(reader["DID"].ToString());
d.DName = reader["DName"].ToString();
r.DID = d;
r.Reason = reader["Reason"].ToString();
r.Time = DateTime.Parse(reader["Time"].ToString());
r.Remark = reader["Remark"].ToString();
r.State = reader["Remark"].ToString();
re.Add(r);
}
}
catch (Exception ex)
{
JsMessage.jsAlert(ex.Message);
}
return(re);
}
/// <summary>
/// 添加辞职信息
/// </summary>
/// <param name="re"></param>
/// <returns></returns>
public int U_AddResigntion(U_Resignation re)
{
return(ud.U_AddResigntion(re));
}
