/// <summary>
/// 根据编号返回特定的转正申请记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ConversionApply GetConversionApplyByID(int id)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM [ConversionApplies] WHERE [ApplyID] = @ApplyID", conn);
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
ConversionApply ci = null;
if (sdr.Read())
{
ci = new ConversionApply();
ci.staffName = (string)sdr["StaffName"];
ci.department = (string)sdr["Department"];
ci.education = (string)sdr["Education"];
ci.level = (string)sdr["Level"];
ci.salaryLevel = (string)sdr["SalaryLevel"];
ci.startDate = Convert.ToDateTime(sdr["StartDate"]);
ci.applyDate = Convert.ToDateTime(sdr["ApplyDate"]);
ci.summary = (string)sdr["Summary"];
ci.ApproveProcess = sdr["ApproveProcess"] == DBNull.Value ? "" : (string)sdr["ApproveProcess"];
}
sdr.Close();
conn.Close();
return(ci);
}
private void updateApprove(string if_agree, string next, BasicInfo info, bool if_back)
{
Users usr = (Users)Session["Identify"];
int recordID = Convert.ToInt32(Request["RecordID"]);
ConversionApply ci = ConversionApply.GetConversionApplyByID(recordID);
ci.ApproveProcess += info.StaffName.Trim() + "-" + if_agree + ",";
ConversionApply.SetConversionApplyByID(recordID, ci, usr.UserID);
string nextApprover = next;
int applyID = Convert.ToInt32(Request["ApplyID"]);
Apply.UpdateNextApprover(applyID, nextApprover, if_back);
}
protected void Page_Load(object sender, EventArgs e)
{
int recordID = Convert.ToInt32(Request["RecordID"]);
ConversionApply ci = ConversionApply.GetConversionApplyByID(recordID);
staffName.Text = ci.StaffName;
department.Text = ci.Department_str;
education.Text = ci.Education;
startDate.Text = ci.StartDate.ToShortDateString();
applyDate.Text = ci.ApplyDate.ToShortDateString();
level.Text = ci.Level;
salaryLevel.Text = ci.SalaryLevel;
summary.Text = ci.Summary;
processShow.Text = ci.ApproveProcess;
}
/// <summary>
/// 新增或更新转正申请记录
/// </summary>
/// <param name="id"></param>
/// <param name="ci"></param>
/// <param name="userID"></param>
public static void SetConversionApplyByID(int id, ConversionApply ci, int userID)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd;
bool isExist = HasConversionApplyInfo(id);
if (isExist)
{
cmd = new SqlCommand("UPDATE [ConversionApplies] SET [StaffName] = @StaffName, [Department]=@Department, [Education]=@Education, [Level]=@Level, [SalaryLevel]=@SalaryLevel, [StartDate]=@StartDate, [ApplyDate]=@ApplyDate, [Summary] = @Summary, [ApproveProcess]=@ApproveProcess WHERE [ApplyID] = @ApplyID", conn);
}
else
{
cmd = new SqlCommand("INSERT INTO [ConversionApplies] ( [StaffName], [Department], [Education], [Level], [SalaryLevel], [StartDate], [ApplyDate], [Summary]) VALUES ( @StaffName, @Department, @Education, @Level, @SalaryLevel, @StartDate, @ApplyDate, @Summary) Select @@Identity as 'Identity'", conn);
}
cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = ci.staffName;
cmd.Parameters.Add("@Department", SqlDbType.VarChar).Value = ci.department;
cmd.Parameters.Add("@Education", SqlDbType.VarChar).Value = ci.education;
cmd.Parameters.Add("@Level", SqlDbType.Float).Value = ci.level;
cmd.Parameters.Add("@SalaryLevel", SqlDbType.VarChar).Value = ci.salaryLevel;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = ci.startDate;
cmd.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = ci.applyDate;
cmd.Parameters.Add("@Summary", SqlDbType.VarChar).Value = ci.summary;
cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = ci.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 = ci.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(ci.department).ResponsiblePerson;
cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false;
cmd2.ExecuteNonQuery();
}
conn.Close();
}
protected void confirm_Click(object sender, EventArgs e)
{
ConversionApply ci = new ConversionApply();
ci.StaffName = Request["staffName"];
ci.Department_str = depList.SelectedValue;
ci.Education = Request["education"];
ci.ApplyDate = Convert.ToDateTime(Request["applyDate"]);
ci.StartDate = Convert.ToDateTime(Request["startDate"]);
ci.Level = Request["level"];
ci.SalaryLevel = Request["salaryLevel"];
ci.Summary = Request["summary"];
ci.ApproveProcess = "";
Users usr = (Users)Session["Identify"];
ConversionApply.SetConversionApplyByID(-1, ci, usr.UserID);
Response.Redirect("~/Account/BasicInfo.aspx");
}
