public int Insert_HRPItemScore(HRPItemScoreInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_HRPItemScore",
new SqlParameter("@HRPIS_ItemID", hr.HRPIS_ItemID), new SqlParameter("@HRPI_ItemID", hr.HRPI_ItemID),
new SqlParameter("@HRPD_ID", hr.HRPD_ID), new SqlParameter("@HRPIS_ItemScore", hr.HRPIS_ItemScore),
new SqlParameter("@HRPIS_ItemFScore", hr.HRPIS_ItemFScore)));
}
public int Update_HRPItemScore_CHECK(HRPItemScoreInfo hr)
{
return(iHR.Update_HRPItemScore_CHECK(hr));
}
public int Insert_HRPItemScore(HRPItemScoreInfo hr)
{
return(iHR.Insert_HRPItemScore(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();
}
}
