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