public int Update_HRPerformAssessType_Person(HRPtypeInfo hr) { return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_HRPerformAssessType_Person", new SqlParameter("@HRPAT_ID", hr.HRPAT_ID), new SqlParameter("@HRPAT_PType", hr.HRPAT_PType), new SqlParameter("@HRPAT_APerson", hr.HRPAT_APerson), new SqlParameter("@HRPAT_CPerson", hr.HRPAT_CPerson), new SqlParameter("@HRPAT_M_State", hr.HRPAT_M_State))); }//更新考核类型的考核人和审核人
public int Insert_HRPerformAssessType(HRPtypeInfo hr) { return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_HRPerformAssessType_HRPAT_PType", new SqlParameter("@HRPAT_ID", hr.HRPAT_ID), new SqlParameter("@HRPAT_PType", hr.HRPAT_PType), new SqlParameter("@HRPAT_APerson", hr.HRPAT_APerson), new SqlParameter("@HRPAT_CPerson", hr.HRPAT_CPerson), new SqlParameter("@HRPAT_IsDeleted", hr.HRPAT_IsDeleted), new SqlParameter("@HRPAT_M_State", hr.HRPAT_M_State))); }
protected void Grid_Type_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Delete_Type") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Grid_Type.SelectedIndex = row.RowIndex; Guid guid = new Guid(e.CommandArgument.ToString()); hRPerfL.Delete_HRPerformAssessType(guid); hRPItemL.Delete_HRPerformceItem(guid); BindGrid(""); //BindItem(""); } if (e.CommandName == "Delete_Type_Item") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Grid_Type.SelectedIndex = row.RowIndex; Guid guid = new Guid(e.CommandArgument.ToString()); //hRPerfL.Delete_HRPerformAssessType(guid); hRPItemL.Delete_HRPerformceItem(guid); //BindGrid(""); BindItem(""); } if (e.CommandName == "Edit_Post") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Panel3.Visible = true; UpdatePanel3.Update(); LblState.Text = "编辑"; Label49.Text = e.CommandArgument.ToString(); id = new Guid(Label49.Text); HRPItemInfo hR = hRPItemL.SearchByID_HRPItem(id)[0]; TextBox_newItem1.Text = hR.HRPI_Items; TextBox_newItem2.Text = hR.HRPI_Contents; TextBox_newItem3.Text = hR.HRPI_StanScore; TextBox_newItem4.Text = hR.HRPI_AssStandard; TextBox_newItem5.Text = hR.HRPI_Remarks; UpdatePanel3.Update(); } if (e.CommandName == "Edit1") { Panel_NewType.Visible = false; UpdatePanel_NewType.Update(); Panel_SearchEmployee.Visible = false; Panel_Grid_Detail.Visible = false; Panel_AddEmployee.Visible = false; UpdatePanel_SearchEmployee.Update(); UpdatePanel_Grid_Detail.Update(); UpdatePanel_AddEmployee.Update(); GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Grid_Type.SelectedIndex = row.RowIndex; Label48.Text = e.CommandArgument.ToString(); Guid guid = new Guid(Label48.Text); Panel2.Visible = true; UpdatePanel2.Update(); BindItem(""); } if (e.CommandName == "Edit2") { Panel_NewType.Visible = false; UpdatePanel_NewType.Update(); Panel2.Visible = false; Panel3.Visible = false; Panel4.Visible = false; UpdatePanel2.Update(); UpdatePanel3.Update(); UpdatePanel4.Update(); con1 = " and HRPAT_ID='" + e.CommandArgument.ToString() + "'"; GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Grid_Type.SelectedIndex = row.RowIndex; Label50.Text = e.CommandArgument.ToString(); Guid guid = new Guid(Label50.Text); Panel_SearchEmployee.Visible = true; Panel_Grid_Detail.Visible = true; UpdatePanel_SearchEmployee.Update(); UpdatePanel_Grid_Detail.Update(); BindGridForEmployee(Grid_Detail, con1); Bind_DdlDep(DdlSearchDep); Bind_DdlPost(DdlSearchPost, ""); } if (e.CommandName == "Edit3") { GridViewRow row = ((LinkButton)e.CommandSource).Parent.Parent as GridViewRow; Panel_NewType.Visible = true; UpdatePanel_NewType.Update(); Label28.Text = "编辑"; Label27.Text = e.CommandArgument.ToString(); id = new Guid(Label27.Text); HRPtypeInfo hRType = hRPerfL.SearchByID_HRPerformAssessType(id)[0]; DataSet dtAperson = neiaL.Search_ForTeacher_HRDDetail("and UMUI_UserID like '%" + hRType.HRPAT_APerson.Trim() + "%' "); DataSet dtCperson = neiaL.Search_ForTeacher_HRDDetail("and UMUI_UserID like '%" + hRType.HRPAT_CPerson.Trim() + "%' "); TxtAperson.Text = Convert.ToString(dtAperson.Tables[0].Rows[0]["UMUI_UserName"]); TxtCperson.Text = Convert.ToString(dtCperson.Tables[0].Rows[0]["UMUI_UserName"]); DataSet dtApersonID = neiaL.Search_ForTeacher_HRDDetail("and UMUI_UserName like '%" + hRType.HRPAT_APerson + "%' "); DataSet dtCpersonID = neiaL.Search_ForTeacher_HRDDetail("and UMUI_UserName like '%" + hRType.HRPAT_CPerson + "%' "); TxtNewType.Text = hRType.HRPAT_PType; Label31.Text = hRType.HRPAT_APerson; Label32.Text = hRType.HRPAT_CPerson; UpdatePanel_NewType.Update(); } }
public int Update_HRPerformAssessType_Person(HRPtypeInfo hr) { return(iHR.Update_HRPerformAssessType_Person(hr)); }
public int Insert_HRPerformAssessType(HRPtypeInfo hr) { return(iHR.Insert_HRPerformAssessType(hr)); }