/// <summary> /// 数据添加和修改函数的统一参数填充 /// </summary> /// <param name="myParameters"></param> /// <param name="myEnum_zwjKindofUpdate"></param> public void ParametersAdd(SqlParameterCollection myParameters, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { this.myClass_WeldingParameter.ParametersAdd(myParameters, "Issue"); myParameters.Add("@IssueNo", SqlDbType.NVarChar, 20).Value = this.IssueNo; //myParameters.Add("@IssueStatus", SqlDbType.Int).Value = Class_DataValidateTool.CouvertuintToint(this.IssueStatus); myParameters.Add("@IssueStatus", SqlDbType.Int).Value = (int)this.IssueStatus; myParameters.Add("@SignUpDate", SqlDbType.DateTime).Value = this.SignUpDate; myParameters.Add("@WeldingProcessAb", SqlDbType.NVarChar, 10).Value = this.WeldingProcessAb; myParameters.Add("@ShipClassificationAb", SqlDbType.NVarChar, 10).Value = this.ShipClassificationAb; myParameters.Add("@ShipboardNo", SqlDbType.NVarChar, 10).Value = this.ShipboardNo; myParameters.Add("@IssueEmployerHPID", SqlDbType.NChar, 4).Value = this.EmployerHPID; myParameters.Add("@KindofEmployer", SqlDbType.NVarChar, 20).Value = this.KindofEmployer; myParameters.Add("@IssueWPSNo", SqlDbType.NVarChar, 50).Value = this.IssueWPSNo; myParameters.Add("@IssueRemark", SqlDbType.NVarChar, 255).Value = this.IssueRemark; myParameters.Add("@KindofEmployerIssueID", SqlDbType.Int).Direction = ParameterDirection.InputOutput; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Add: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Add.ToString(); break; case Enum_zwjKindofUpdate.Modify: myParameters["@KindofEmployerIssueID"].Value = this.KindofEmployerIssueID; myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Modify.ToString(); break; } }
/// <summary> /// 数据添加和修改函数的统一参数填充 /// </summary> /// <param name="myParameters"></param> /// <param name="myEnum_zwjKindofUpdate"></param> public void ParametersAdd(SqlParameterCollection myParameters, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { this.myClass_BelongUnit.ParametersAdd(myParameters, "Welder"); myParameters.Add("@KindofEmployer", SqlDbType.NVarChar, 20).Value = this.KindofEmployer; myParameters.Add("@IdentificationCard", SqlDbType.NChar, 18).Value = this.IdentificationCard; myParameters.Add("@WelderName", SqlDbType.NVarChar, 10).Value = this.WelderName; myParameters.Add("@Schooling", SqlDbType.NVarChar, 20).Value = this.Schooling; myParameters.Add("@Sex", SqlDbType.NChar, 1).Value = this.Sex; myParameters.Add("@WeldingBeginning", SqlDbType.DateTime).Value = this.WeldingBeginning; myParameters.Add("@WelderRemark", SqlDbType.NVarChar, 255).Value = this.WelderRemark; myParameters.Add("@Postcode", SqlDbType.NVarChar, 10).Value = this.Postcode; myParameters.Add("@WelderAddress", SqlDbType.NVarChar, 255).Value = this.WelderAddress; myParameters.Add("@WelderTel", SqlDbType.NVarChar, 255).Value = this.WelderTel; myParameters.Add("@WeldingExperiences", SqlDbType.NVarChar, 255).Value = this.WeldingExperiences; myParameters.Add("@KindofEmployerWelderID", SqlDbType.Int).Direction = ParameterDirection.InputOutput; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Add: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Add.ToString(); break; case Enum_zwjKindofUpdate.Modify: myParameters["@KindofEmployerWelderID"].Value = this.KindofEmployerWelderID; myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Modify.ToString(); break; } }
/// <summary> /// 集成数据删除、判断是否可以删除和判断是否存在的统一函数 /// </summary> /// <param name="Judgment"></param> /// <param name="myEnum_zwjKindofUpdate"></param> /// <returns></returns> static public bool ExistAndCanDeleteAndDelete(int JudgmentID, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { SqlCommand myCmd_Temp = new SqlCommand(null, Class_zwjPublic.myClass_SqlConnection.mySqlConn); myCmd_Temp.CommandText = "Question_Judgment_Update"; myCmd_Temp.CommandType = CommandType.StoredProcedure; Class_Judgment.ParametersAdd(myCmd_Temp.Parameters, JudgmentID, myEnum_zwjKindofUpdate); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(true); myCmd_Temp.ExecuteNonQuery(); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(false); if ((int)myCmd_Temp.Parameters["@ReturnNum"].Value > 0) { if (myEnum_zwjKindofUpdate == Enum_zwjKindofUpdate.Exist) { return(true); } else { return(false); } } else { if (myEnum_zwjKindofUpdate == Enum_zwjKindofUpdate.Exist) { return(false); } else { return(true); } } }
/// <summary> /// 数据添加和修改函数的统一参数填充 /// </summary> /// <param name="myParameters"></param> /// <param name="myEnum_zwjKindofUpdate"></param> public void ParametersAdd(SqlParameterCollection myParameters, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { myParameters.Add("@ChoiceID", SqlDbType.Int).Direction = ParameterDirection.InputOutput; myParameters.Add("@Subject", SqlDbType.NVarChar, 50).Value = this.Subject; myParameters.Add("@QuestionText", SqlDbType.NVarChar, 255).Value = this.QuestionText; myParameters.Add("@Result", SqlDbType.NVarChar, 1).Value = this.Result; myParameters.Add("@A", SqlDbType.NVarChar, 255).Value = this.A; myParameters.Add("@B", SqlDbType.NVarChar, 255).Value = this.B; myParameters.Add("@C", SqlDbType.NVarChar, 255).Value = this.C; myParameters.Add("@D", SqlDbType.NVarChar, 255).Value = this.D; myParameters.Add("@E", SqlDbType.NVarChar, 255).Value = this.E; myParameters.Add("@ResultQuantity", SqlDbType.Int).Value = this.ResultQuantity; myParameters.Add("@DegreeOfDifficulty", SqlDbType.Real).Value = this.DegreeOfDifficulty; myParameters.Add("@ChoiceRemark", SqlDbType.NVarChar, 255).Value = this.ChoiceRemark; myParameters.Add("@isValid", SqlDbType.Bit).Value = this.isValid; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Add: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Add.ToString(); break; case Enum_zwjKindofUpdate.Modify: myParameters["@ChoiceID"].Value = this.ChoiceID; myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Modify.ToString(); break; } }
/// <summary> /// 集成数据添加和修改的统一函数 /// </summary> /// <param name="myEnum_zwjKindofUpdate"></param> /// <returns></returns> public bool AddAndModify(Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { SqlCommand myCmd_Temp = new SqlCommand(null, Class_zwjPublic.myClass_SqlConnection.mySqlConn); myCmd_Temp.CommandText = "Question_Judgment_Update"; myCmd_Temp.CommandType = CommandType.StoredProcedure; ParametersAdd(myCmd_Temp.Parameters, myEnum_zwjKindofUpdate); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(true); myCmd_Temp.ExecuteNonQuery(); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(false); return(true); }
/// <summary> /// 集成数据添加和修改的统一函数 /// </summary> /// <param name="myEnum_zwjKindofUpdate"></param> /// <returns></returns> public bool AddAndModify(Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { SqlCommand myCmd_Temp = new SqlCommand(null, Class_zwjPublic.myClass_SqlConnection.mySqlConn); myCmd_Temp.CommandText = "SignUp_KindofEmployerStudent_Update"; myCmd_Temp.CommandType = CommandType.StoredProcedure; ParametersAdd(myCmd_Temp.Parameters, myEnum_zwjKindofUpdate); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(true); myCmd_Temp.ExecuteNonQuery(); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(false); this.KindofEmployerStudentID = (int)myCmd_Temp.Parameters["@KindofEmployerStudentID"].Value; Class_UpdateLog.UpdateLog(myEnum_zwjKindofUpdate, "SignUp_KindofEmployerStudent", string.Format("{0}, {1}, {2}", this.KindofEmployerStudentID, this.KindofEmployerIssueID, this.KindofEmployerWelderID), Class_zwjPublic.myClass_CustomUser.UserGUID, ""); return(true); }
/// <summary> /// 数据添加和修改函数的统一参数填充 /// </summary> /// <param name="myParameters"></param> /// <param name="myEnum_zwjKindofUpdate"></param> public void ParametersAdd(SqlParameterCollection myParameters, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { myParameters.Add("@Subject", SqlDbType.NVarChar, 50).Value = this.Subject; myParameters.Add("@SubjectIndex", SqlDbType.Int).Value = this.SubjectIndex; myParameters.Add("@SubjectRemark", SqlDbType.NVarChar, 255).Value = this.SubjectRemark; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Add: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Add.ToString(); break; case Enum_zwjKindofUpdate.Modify: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Modify.ToString(); break; } }
/// <summary> /// 数据添加和修改函数的统一参数填充 /// </summary> /// <param name="myParameters"></param> /// <param name="myEnum_zwjKindofUpdate"></param> public void ParametersAdd(SqlParameterCollection myParameters, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { myParameters.Add("@KindofEmployerIssueID", SqlDbType.Int).Value = this.KindofEmployerIssueID; myParameters.Add("@KindofEmployerWelderID", SqlDbType.Int).Value = this.KindofEmployerWelderID; myParameters.Add("@ExamSubjectID", SqlDbType.NChar, 4).Value = this.ExamSubjectID; myParameters.Add("@StudentKindofExam", SqlDbType.NVarChar, 10).Value = this.StudentKindofExam; myParameters.Add("@StudentRemark", SqlDbType.NVarChar, 255).Value = this.StudentRemark; myParameters.Add("@KindofEmployerStudentID", SqlDbType.Int).Direction = ParameterDirection.InputOutput; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Add: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Add.ToString(); break; case Enum_zwjKindofUpdate.Modify: myParameters["@KindofEmployerStudentID"].Value = this.KindofEmployerStudentID; myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Modify.ToString(); break; } }
/// <summary> /// 集成数据删除、判断是否可以删除和判断是否存在的统一函数 /// </summary> /// <param name="KindofEmployerStudent"></param> /// <param name="myEnum_zwjKindofUpdate"></param> /// <returns></returns> static public bool ExistAndCanDeleteAndDelete(int KindofEmployerIssueID, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { if (myEnum_zwjKindofUpdate == Enum_zwjKindofUpdate.Delete) { Class_KindofEmployerIssue myClass_KindofEmployerIssue = new Class_KindofEmployerIssue(KindofEmployerIssueID); Class_UpdateLog.UpdateLog(myEnum_zwjKindofUpdate, "SignUp_KindofEmployerIssue", string.Format("{0}, {1}, {2}", KindofEmployerIssueID, myClass_KindofEmployerIssue.KindofEmployer, myClass_KindofEmployerIssue.IssueNo), Class_zwjPublic.myClass_CustomUser.UserGUID, ""); } SqlCommand myCmd_Temp = new SqlCommand(null, Class_zwjPublic.myClass_SqlConnection.mySqlConn); myCmd_Temp.CommandText = "SignUp_KindofEmployerIssue_Update"; myCmd_Temp.CommandType = CommandType.StoredProcedure; Class_KindofEmployerIssue.ParametersAdd(myCmd_Temp.Parameters, KindofEmployerIssueID, myEnum_zwjKindofUpdate); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(true); myCmd_Temp.ExecuteNonQuery(); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(false); if ((int)myCmd_Temp.Parameters["@ReturnNum"].Value > 0) { if (myEnum_zwjKindofUpdate == Enum_zwjKindofUpdate.Exist) { return(true); } else { return(false); } } else { if (myEnum_zwjKindofUpdate == Enum_zwjKindofUpdate.Exist) { return(false); } else { return(true); } } }
static public bool ExistSecond(int KindofEmployerIssueID, int KindofEmployerWelderID, int KindofEmployerStudentID, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { SqlCommand myCmd_Temp = new SqlCommand(null, Class_zwjPublic.myClass_SqlConnection.mySqlConn); myCmd_Temp.CommandText = "SignUp_KindofEmployerStudent_ExistSecond"; myCmd_Temp.CommandType = CommandType.StoredProcedure; myCmd_Temp.Parameters.Add("@KindofEmployerIssueID", SqlDbType.Int).Value = KindofEmployerIssueID; myCmd_Temp.Parameters.Add("@KindofEmployerWelderID", SqlDbType.Int).Value = KindofEmployerWelderID; myCmd_Temp.Parameters.Add("@ReturnNum", SqlDbType.Int).Direction = ParameterDirection.Output; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Add: myCmd_Temp.Parameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Add.ToString(); break; case Enum_zwjKindofUpdate.Modify: myCmd_Temp.Parameters.Add("@KindofEmployerStudentID", SqlDbType.Int).Value = KindofEmployerStudentID; myCmd_Temp.Parameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Modify.ToString(); break; } Class_zwjPublic.myClass_SqlConnection.SetConnectionState(true); myCmd_Temp.ExecuteNonQuery(); Class_zwjPublic.myClass_SqlConnection.SetConnectionState(false); if ((int)myCmd_Temp.Parameters["@ReturnNum"].Value > 0) { return(true); } else { return(false); } }
/// <summary> /// 数据删除、判断是否可以删除和判断是否存在的统一参数填充 /// </summary> /// <param name="myParameters"></param> /// <param name="KindofEmployerStudent"></param> /// <param name="myEnum_zwjKindofUpdate"></param> static public void ParametersAdd(SqlParameterCollection myParameters, int KindofEmployerStudentID, Enum_zwjKindofUpdate myEnum_zwjKindofUpdate) { myParameters.Add("@KindofEmployerStudentID", SqlDbType.Int).Value = KindofEmployerStudentID; myParameters.Add("@ReturnNum", SqlDbType.Int).Direction = ParameterDirection.Output; switch (myEnum_zwjKindofUpdate) { case Enum_zwjKindofUpdate.Delete: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Delete.ToString(); break; case Enum_zwjKindofUpdate.CanDelete: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.CanDelete.ToString(); break; case Enum_zwjKindofUpdate.Exist: myParameters.Add("@KindofUpdate", SqlDbType.NVarChar, 20).Value = Enum_zwjKindofUpdate.Exist.ToString(); break; } }