private const string SP_INSERTREQUIREMENTCOURSE = "usp_require_InsertRequirementCourse";
private const string PARA_COURSE_ID = "@courseId";
private const string PARA_COURSE_NAME = "@courseName";
private const string PARA_TRAINED_OBJECT = "@trainedObject";
private const string PARA_TRAINED_FORM = "@trainedForm";
private const string PARA_RECOMMEND_AGENCY = "@recommendAgency";
private const string PARA_TRAIN_BUDGET = "@trainBudget";
private const string PARA_ARRANGE_TIME = "@arrangeTime";
private const string PARA_TRAIN_OBJECTIVE = "@trainObjective";
private const string PARA_FUNDING_REQUIREMENT = "@fundingRequirement";
public int InsertRequirementCourse(RequirementCourseInfo requireCourseInfo) {
SqlParameter[] requireCourseParameters = GetRequirementCourseInsertParameters();
requireCourseParameters[0].Value = requireCourseInfo.CourseId;
requireCourseParameters[1].Value = requireCourseInfo.CourseName;
requireCourseParameters[2].Value = requireCourseInfo.TrainedObject;
requireCourseParameters[3].Value = requireCourseInfo.TrainedForm;
requireCourseParameters[4].Value = requireCourseInfo.RecommendAgency;
requireCourseParameters[5].Value = requireCourseInfo.TrainBudget;
requireCourseParameters[6].Value = requireCourseInfo.ArrangeTime;
requireCourseParameters[7].Value = requireCourseInfo.TrainedObject;
requireCourseParameters[8].Value = requireCourseInfo.FundingRequirement;
int affectRows = SQLHelper.RunProcedureQuery(SP_INSERTREQUIREMENTCOURSE, requireCourseParameters);
return affectRows;
}
public static SqlParameter[] GetRequirementCourseInsertParameters() {
SqlParameter[] parameters = SQLHelper.GetCachedParameters(SP_INSERTREQUIREMENTCOURSE);
if (parameters == null) {
parameters = new SqlParameter[]{
new SqlParameter(PARA_COURSE_ID,SqlDbType.UniqueIdentifier,16),
new SqlParameter(PARA_COURSE_NAME,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAINED_OBJECT,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAINED_FORM,SqlDbType.VarChar,520),
new SqlParameter(PARA_RECOMMEND_AGENCY,SqlDbType.VarChar,520),
new SqlParameter(PARA_TRAIN_BUDGET,SqlDbType.VarChar,50),
new SqlParameter(PARA_ARRANGE_TIME,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAIN_OBJECTIVE,SqlDbType.VarChar,50),
new SqlParameter(PARA_FUNDING_REQUIREMENT,SqlDbType.VarChar,50),
};
}
return parameters;
}
问题补充：courseId uniqueidentifier Unchecked
courseName varchar(50) Checked
trainedObject varchar(50) Checked
trainedForm varchar(520) Checked
recommendAgency varchar(520) Checked
trainBudget varchar(50) Checked
arrangeTime varchar(50) Checked
trainObjective varchar(50) Checked
fundingRequirement varchar(50) Checked
Unchecked
数据库为如上:
| 
