/// <summary>
/// 新增或更新离职记录
/// </summary>
/// <param name="id"></param>
/// <param name="si"></param>
/// <param name="userID"></param>
public static void SetDismissionApplyByID(int id, DismissionApply si, int userID)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd;
bool isExist = HasDismissionApplyInfo(id);
if (isExist)
{
cmd = new SqlCommand("UPDATE [DismissionApplies] SET [StaffName] = @StaffName, [Department]=@Department, [BusinessUnit]=@BusinessUnit, [Position]=@Position, [Reason]=@Reason, [StartDate]=@StartDate, [EndDate]=@EndDate, [Address] = @Address, [Telephone]=@Telephone, [HandOver]=@HandOver, [Borrow]=@Borrow, [Others]=@Others, [Reimburese]=@Reimburse, [Books]=@Books, [RemovibleDisk]=@RemovibleDisk, [Computer]=@Computer, [Communication]=@Communication, [ReturnThings]=@ReturnThings, [ReCheckHandOver]=@ReCheckHandOver, [Keys]=@Keys, [OfficeThings]=@OfficeThings, [ApproveProcess]=@ApproveProcess WHERE [ApplyID] = @ApplyID", conn);
}
else
{
cmd = new SqlCommand("INSERT INTO [DismissionApplies] ([StaffName], [Department], [BusinessUnit], [Position], [Reason], [StartDate], [EndDate], [Address], [Telephone], [HandOver], [ReturnThings], [Reimburse], [Borrow], [RemovibleDisk], [Computer], [Communication], [Books], [ReCheckHandOver], [Keys], [OfficeThings]) VALUES (@StaffName, @Department, @BusinessUnit, @Position, @Reason, @StartDate, @EndDate, @Address, @Telephone, @HandOver, @ReturnThings, @Reimburse, @Borrow, @RemovibleDisk, @Computer, @Communication, @Books, @ReCheckHandOver, @Keys, @OfficeThings) Select @@Identity as 'Identity'", conn);
}
cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = si.staffName;
cmd.Parameters.Add("@Department", SqlDbType.VarChar).Value = si.department;
cmd.Parameters.Add("@BusinessUnit", SqlDbType.VarChar).Value = si.businessUnit;
cmd.Parameters.Add("@Position", SqlDbType.VarChar).Value = si.position;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = si.startDate;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = si.endDate;
cmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = si.address;
cmd.Parameters.Add("@Telephone", SqlDbType.VarChar).Value = si.telephone;
cmd.Parameters.Add("@Reason", SqlDbType.VarChar).Value = si.reason;
cmd.Parameters.Add("@HandOver", SqlDbType.Bit).Value = si.handOver;
cmd.Parameters.Add("@ReturnThings", SqlDbType.Bit).Value = si.returnThings;
cmd.Parameters.Add("@Reimburse", SqlDbType.Bit).Value = si.reimburse;
cmd.Parameters.Add("@Borrow", SqlDbType.Bit).Value = si.borrow;
cmd.Parameters.Add("@RemovibleDisk", SqlDbType.Bit).Value = si.removibleDisk;
cmd.Parameters.Add("@Computer", SqlDbType.Bit).Value = si.computer;
cmd.Parameters.Add("@Communication", SqlDbType.Bit).Value = si.communication;
cmd.Parameters.Add("@Books", SqlDbType.Bit).Value = si.books;
cmd.Parameters.Add("@ReCheckHandOver", SqlDbType.Bit).Value = si.reCheckHandOver;
cmd.Parameters.Add("@Keys", SqlDbType.Bit).Value = si.keys;
cmd.Parameters.Add("@OfficeThings", SqlDbType.Bit).Value = si.officeThings;
cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = si.approveProcess;
conn.Open();
//同时在标准化申请表中插入一条记录
int recordId = Convert.ToInt32(cmd.ExecuteScalar());
if (!isExist)
{
SqlCommand cmd2 = new SqlCommand("INSERT INTO [AllApplies] ( [ApplyStaff], [ApplyDate], [ApplyType], [NextApprover], [RecordID], [Result]) VALUES (@ApplyStaff, @ApplyDate, @ApplyType, @NextApprover, @RecordID, @Result)", conn);
cmd2.Parameters.Add("@ApplyStaff", SqlDbType.VarChar).Value = si.staffName;
cmd2.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@ApplyType", SqlDbType.VarChar).Value = "离职申请";
cmd2.Parameters.Add("@RecordID", SqlDbType.Int).Value = recordId;
cmd2.Parameters.Add("@NextApprover", SqlDbType.VarChar).Value = Department.GetDepartmentByName(si.department).ResponsiblePerson;
cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false;
cmd2.ExecuteNonQuery();
}
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
int recordID = Convert.ToInt32(Request["RecordID"]);
DismissionApply di = DismissionApply.GetDismissionApplyByID(recordID);
staffName.Text = di.StaffName;
department.Text = di.Department_str;
businessUnit.Text = di.BusinessUnit;
position.Text = di.Position;
startDate.Text = di.StartDate.ToShortDateString();
endDate.Text = di.EndDate.ToShortDateString();
address.Text = di.Address;
teletphone.Text = di.Telephone;
reason.SelectedValue = di.Reason;
handOver.Checked = di.HandOver;
returnThings.Checked = di.ReturnThings;
reimburse.Checked = di.Reimburse;
borrow.Checked = di.Borrow;
removibleDisk.Checked = di.RemovibleDisk;
computer.Checked = di.Computer;
communication.Checked = di.Communication;
books.Checked = di.Books;
reCheckHandOver.Checked = di.ReCheckHandOver;
keys.Checked = di.Keys;
officeThings.Checked = di.OfficeThings;
processShow.Text = di.ApproveProcess;
}
protected void confirm_Click(object sender, EventArgs e)
{
DismissionApply di = new DismissionApply();
di.StaffName = Request["staffName"];
di.Department_str = depList.SelectedValue;
di.BusinessUnit = buList.SelectedValue;
di.Position = posList.SelectedValue;
di.StartDate = Convert.ToDateTime(startDate.Value);
di.EndDate = Convert.ToDateTime(endDate.Value);
di.Address = Request["address"];
di.Telephone = Request["telephone"];
di.Reason = reason.SelectedValue;
di.HandOver = handOver.Checked;
di.ReturnThings = returnThings.Checked;
di.Reimburse = reimburse.Checked;
di.Borrow = borrow.Checked;
di.RemovibleDisk = removibleDisk.Checked;
di.Computer = computer.Checked;
di.Communication = communication.Checked;
di.Books = books.Checked;
di.ReCheckHandOver = reCheckHandOver.Checked;
di.Keys = keys.Checked;
di.OfficeThings = officeThings.Checked;
di.ApproveProcess = "";
Users usr = (Users)Session["Identify"];
DismissionApply.SetDismissionApplyByID(-1, di, usr.UserID);
Response.Redirect("~/Account/BasicInfo.aspx");
}
private void updateApprove(string if_agree, string next, BasicInfo info, bool if_back)
{
Users usr = (Users)Session["Identify"];
int recordID = Convert.ToInt32(Request["RecordID"]);
DismissionApply di = DismissionApply.GetDismissionApplyByID(recordID);
di.ApproveProcess += info.StaffName.Trim() + "-" + if_agree + ",";
DismissionApply.SetDismissionApplyByID(recordID, di, usr.UserID);
string nextApprover = next;
int applyID = Convert.ToInt32(Request["ApplyID"]);
Apply.UpdateNextApprover(applyID, nextApprover, if_back);
}
/// <summary>
/// 根据编号获取特定的离职申请记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static DismissionApply GetDismissionApplyByID(int id)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM [DismissionApplies] WHERE [ApplyID] = @ApplyID", conn);
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
DismissionApply di = null;
if (sdr.Read())
{
di = new DismissionApply();
di.staffName = (string)sdr["StaffName"];
di.department = (string)sdr["Department"];
di.position = (string)sdr["Position"];
di.businessUnit = (string)sdr["BusinessUnit"];
di.startDate = Convert.ToDateTime(sdr["StartDate"]);
di.endDate = Convert.ToDateTime(sdr["EndDate"]);
di.address = (string)sdr["Address"];
di.telephone = (string)sdr["Telephone"];
di.reason = (string)sdr["Reason"];
di.handOver = (bool)sdr["Handover"];
di.returnThings = (bool)sdr["ReturnThings"];
di.reimburse = (bool)sdr["Reimburse"];
di.borrow = (bool)sdr["Borrow"];
di.removibleDisk = (bool)sdr["RemovibleDisk"];
di.computer = (bool)sdr["Computer"];
di.communication = (bool)sdr["Communication"];
di.books = (bool)sdr["Books"];
di.reCheckHandOver = (bool)sdr["ReCheckHandOver"];
di.keys = (bool)sdr["Keys"];
di.officeThings = (bool)sdr["OfficeThings"];
di.ApproveProcess = sdr["ApproveProcess"] == DBNull.Value ? "" : (string)sdr["ApproveProcess"];
}
sdr.Close();
conn.Close();
return(di);
}
