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)); }