public int Update_HRPerformceDetail_CHECK(HRPerformceDetailInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_HRPerformceDetail_CHECK",
new SqlParameter("@HRPD_ID", hr.HRPD_ID), new SqlParameter("@HRPD_Auditor", hr.HRPD_Auditor),
new SqlParameter("@HRPD_AuTime", hr.HRPD_AuTime), new SqlParameter("@HRPD_C_FinalScore", hr.HRPD_C_FinalScore),
new SqlParameter("@HRPD_State", hr.HRPD_State)));
}
public int Update_HRPerformceDetail(HRPerformceDetailInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_HRPerformceDetail",
new SqlParameter("@HRPD_ID", hr.HRPD_ID), new SqlParameter("@HRDD_ID", hr.HRDD_ID),
new SqlParameter("@HRPD_APerson", hr.HRPD_APerson), new SqlParameter("@HRPD_Atime", hr.HRPD_Atime),
new SqlParameter("@HRPD_FinalScore", hr.HRPD_FinalScore), new SqlParameter("@HRPD_Year", hr.HRPD_Year),
new SqlParameter("@HRPD_Month", hr.HRPD_Month),
new SqlParameter("@HRPD_State", hr.HRPD_State),
new SqlParameter("@HRPD_AState", hr.HRPD_AState)));
}
public int Update_HRPerformceDetail_CHECK(HRPerformceDetailInfo hr)
{
return(iHR.Update_HRPerformceDetail_CHECK(hr));
}
public int Insert_HRPerformceDetail(HRPerformceDetailInfo hr)
{
return(iHR.Insert_HRPerformceDetail(hr));
}
protected void BtnOK_Click(object sender, EventArgs e)
{
HRPerformceDetailInfo neiaInfo1 = new HRPerformceDetailInfo(); //提交"按钮，插入新员工培训结果详情表
HRPItemScoreInfo neiaInfo2 = null; //"提交"按钮，更新新员工培训信息主表的状态
DateTime d1;
if (DateTime.TryParse(TxtCheckTime.Text, out d1))
{
neiaInfo1.HRPD_AuTime = d1;
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('请输入格式正确的培训开始日期！')", true);
return;
}
int count = GridView2.Rows.Count;
for (int j = 0; j < count; j++)
{
TextBox tb1 = GridView2.Rows[j].FindControl("TxtRemarks") as TextBox;//取得所在行的是否合格的列
if (tb1.Text == "")
{
tb1.Text = GridView2.Rows[j].Cells[7].Text;
//ScriptManager.RegisterClientScriptBlock(this.Page, typeof(Page), "alert", "alert('请输入最终得分！')", true);
flag = "提交";
//break;
}
else if (Int32.Parse(GridView2.Rows[j].Cells[4].Text) < Int32.Parse(tb1.Text))
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('项目最终得分不能比标准得分高！')", true);
flag = "不提交";
break;
}
else
{
flag = "提交";
}
}
if (CheckPerson.Text == "")
{
flag = "不提交";
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('请输入审核人！')", true);
}
if (flag == "提交")
{
neiaInfo1.HRPD_ID = new Guid(Label2.Text);//人事档案ID
neiaInfo1.HRPD_Auditor = CheckPerson.Text;
neiaInfo1.HRPD_C_FinalScore = 0;
neiaInfo1.HRPD_State = true;
for (int i = 0; i < count; i++)
{
neiaInfo2 = new HRPItemScoreInfo();
TextBox tb = GridView2.Rows[i].FindControl("TxtRemarks") as TextBox;//取得所在行的是否合格的列
string id = GridView2.Rows[i].Cells[0].Text;
neiaInfo2.HRPIS_ItemID = new Guid(GridView2.Rows[i].Cells[0].Text);
neiaInfo2.HRPIS_ItemFScore = Int32.Parse(tb.Text);
neiaInfo1.HRPD_C_FinalScore = neiaInfo1.HRPD_C_FinalScore + neiaInfo2.HRPIS_ItemFScore;
hRPItemScoreL.Update_HRPItemScore_CHECK(neiaInfo2);
}
hRPerformceDetailL.Update_HRPerformceDetail_CHECK(neiaInfo1);
Panel2.Visible = false;
BindGridForEmployee(Grid_Detail, " and HRPD_Year='" + LabelYear.Text.Trim() + "' and HRPD_Month ='" + LabelMonth.Text.Trim() + "' ");
UpdatePanel_SearchEmployee.Update();
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('已提交！')", true);
int year = Int32.Parse(LabelYear.Text);
int month = Int32.Parse(LabelMonth.Text);
string Person = Session["UserId"].ToString();
int state = hRPerfYearL.Search_HRPerformceYear_CHECK_State(year, month, Person);
if (state == 0)
{
yearInfo.HRP_C_State = "已审核";
}
else
{
yearInfo.HRP_C_State = "审核中";
}
//yearInfo.HRPYear_ID = guidPanel1;
//yearInfo.HRP_Year =System.Int32.Parse(this.LabelYear.Text);
//yearInfo.HRP_Month = System.Int32.Parse(this.LabelMonth.Text);
//yearInfo.HRP_A_State = this.LabelA_State.Text;
//yearInfo.HRP_C_Person = Session["UserId"].ToString();
//hRPerfYearL.Update_HRPerformceYear(yearInfo);
if (Label18.Text == "检索前")
{
BindGrid1("");
}
if (Label18.Text == "检索后")
{
BindGrid1(con2);
}
UpdatePanel1.Update();
}
}
protected void BtnOK_Click(object sender, EventArgs e)
{
HRPerformceDetailL hRPerformceDetailL = new HRPerformceDetailL();
HRPerformceDetailInfo neiaInfo1 = new HRPerformceDetailInfo();
HRPItemScoreL hRPItemScoreL = new HRPItemScoreL();
HRPItemScoreInfo neiaInfo2 = null;
DateTime d1;
if (DateTime.TryParse(TxtCheckTime.Text, out d1))
{
neiaInfo1.HRPD_Atime = d1;
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('请输入格式正确的培训开始日期！')", true);
return;
}
int count = GridView2.Rows.Count;
for (int i = 0; i < count; i++)
{
TextBox tb1 = GridView2.Rows[i].FindControl("TxtRemarks") as TextBox;//取得所在行的是否合格的列
if (tb1.Text == "")
{
//tb1.Text = GridView2.Rows[i].Cells[]
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('考核项目得分不能为空！')", true);
flag = "不提交";
break;
}
else if (Int32.Parse(GridView2.Rows[i].Cells[3].Text) < Int32.Parse(tb1.Text))
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('项目得分不能比标准得分高！')", true);
flag = "不提交";
break;
}
else
{
flag = "提交";
}
}
if (CheckPerson.Text == "")
{
flag = "不提交";
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('请输入考核人！')", true);
}
if (flag == "提交")
{
neiaInfo1.HRDD_ID = new Guid(Label2.Text);//人事档案ID
//Guid guid = Guid.NewGuid();
//LabelDetail.Text = guid.ToString();
neiaInfo1.HRPD_ID = new Guid(Label6.Text.ToString().Trim());
neiaInfo1.HRPD_APerson = CheckPerson.Text;
neiaInfo1.HRPD_FinalScore = 0;
neiaInfo1.HRPD_Month = Int32.Parse(LabelMonth.Text.ToString());
neiaInfo1.HRPD_Year = Int32.Parse(LabelYear.Text.ToString());
neiaInfo1.HRPD_State = false;
neiaInfo1.HRPD_AState = true;
//hRPerformceDetailL.Insert_HRPerformceDetail(neiaInfo1);
//hRPerformceDetailL.Update_HRPerformceDetail(neiaInfo1);
for (int j = 0; j < count; j++)
{
neiaInfo2 = new HRPItemScoreInfo();
TextBox tb2 = GridView2.Rows[j].FindControl("TxtRemarks") as TextBox;//取得所在行的是否合格的列
neiaInfo2.HRPI_ItemID = new Guid(GridView2.Rows[j].Cells[0].Text);
neiaInfo2.HRPIS_ItemFScore = 0;
neiaInfo2.HRPD_ID = neiaInfo1.HRPD_ID;
neiaInfo2.HRPIS_ItemScore = Int32.Parse(tb2.Text);
neiaInfo1.HRPD_FinalScore = neiaInfo1.HRPD_FinalScore + neiaInfo2.HRPIS_ItemScore;
hRPItemScoreL.Insert_HRPItemScore(neiaInfo2);
}
hRPerformceDetailL.Update_HRPerformceDetail(neiaInfo1);
Panel2.Visible = false;
BindGridForEmployee(Grid_Detail, "");
UpdatePanel_SearchEmployee.Update();
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('已提交！')", true);
int updateState = getReturnState();
if (updateState == 0)
{
yearInfo.HRP_A_State = "已录入";
//RTX
string message = "ERP系统消息：" + Session["UserName"].ToString() + "于" + DateTime.Now.ToString("F") + "提交了绩效考核信息，请审核。";
string sErr = RTXhelper.Send(message, "绩效考核结果审核");
if (!string.IsNullOrEmpty(sErr))
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('" + sErr + "')", true);
}
}
else
{
yearInfo.HRP_A_State = "录入中";
}
yearInfo.HRPYear_ID = guidYear;
yearInfo.HRP_Year = Int32.Parse(LabelYear.Text);
yearInfo.HRP_Month = Int32.Parse(LabelMonth.Text);
yearInfo.HRP_C_State = "未审核";
yearInfo.HRP_C_Person = "";
hRPerfYearL.Update_HRPerformceYear(yearInfo);
if (Label18.Text == "检索前")
{
BindGrid1("");
}
if (Label18.Text == "检索后")
{
BindGrid1(con2);
}
UpdatePanel1.Update();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditPanel1")
{
Panel3.Visible = false;
UpdatePanel3.Update();
Panel_Time.Visible = false;
UpdatePanel_Time.Update();
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_Detail.SelectedIndex = row.RowIndex;
LabelYear.Text = row.Cells[1].Text.ToString();
LabelMonth.Text = row.Cells[2].Text.ToString();
editFlag = row.Cells[4].Text.ToString();
guidYear = new Guid(e.CommandArgument.ToString());
if (editFlag == "未审核")
{
HRPerformceDetailL hRPerformceDetailL_New = new HRPerformceDetailL();
HRPerformceDetailInfo neiaInfo1_New = new HRPerformceDetailInfo();
DateTime dtimeNew = DateTime.Now;
if (LabelYear.Text == "" || LabelMonth.Text == "")
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('年份和月份不能为空！')", true);
return;
}
DataSet dtNew = hRPItemScoreL.Search_HRDDetail_HRPerformAssessType_Year("and HRPerformAssessType.HRPAT_APerson = '" + Session["UserId"] + "'");
DataTable dtNewTable = dtNew.Tables[0];
int count = dtNewTable.Rows.Count;
for (int i = 0; i < count; i++)
{
Guid guid = Guid.NewGuid();
neiaInfo1_New.HRPD_ID = new Guid(guid.ToString());
neiaInfo1_New.HRDD_ID = new Guid(dtNewTable.Rows[i]["HRDD_ID"].ToString());
neiaInfo1_New.HRPYear_ID = new Guid(guidYear.ToString());
neiaInfo1_New.HRPD_Year = Int32.Parse(LabelYear.Text);
neiaInfo1_New.HRPD_Month = Int32.Parse(LabelMonth.Text);
neiaInfo1_New.HRPD_AState = false;
neiaInfo1_New.HRPD_Atime = dtimeNew;
neiaInfo1_New.HRPD_APerson = "";
hRPerformceDetailL_New.Insert_HRPerformceDetail(neiaInfo1_New);
}
Panel_SearchEmployee.Visible = true;
BindGridForEmployee(Grid_Detail, "");
Bind_DdlHRPtype(DropDownList1);
Bind_DdlDep(DdlSearchDep);
Bind_DdlPost(DdlSearchPost, "");
UpdatePanel_SearchEmployee.Update();
}
else
{
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "alert", "alert('审核状态下不能进行录入！')", true);
return;
}
}
if (e.CommandName == "EditPanel1_View")
{
Panel_SearchEmployee.Visible = false;
UpdatePanel_SearchEmployee.Update();
Panel_Time.Visible = false;
UpdatePanel_Time.Update();
Panel2.Visible = false;
UpdatePanel2.Update();
GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow;
Grid_Detail.SelectedIndex = row.RowIndex;
Guid guidView = new Guid(e.CommandArgument.ToString());
con3 = " and HRPYear_ID ='" + guidView + "'";
Panel3.Visible = true;
BindGridView3(con3);
UpdatePanel3.Update();
}
}//
public int Update_HRPerformceDetail_Manager(HRPerformceDetailInfo hr)
{
return(iHR.Update_HRPerformceDetail_Manager(hr));
}
public int Update_HRPerformceDetail_Manager(HRPerformceDetailInfo hr)
{
return (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_HRPerformceDetail_Manager",
new SqlParameter("@HRPD_ID", hr.HRPD_ID), new SqlParameter("@HRPD_M_Score", hr.HRPD_M_Score));
}
