private bool CheckUnique(EnrollmentPlan enrollmentPlan) { string sql = @"select 1 from EnrollmentPlan where EnrollmentPlanId <> @EnrollmentPlanId and Discipline = @Discipline and MajorName = @MajorName and Year = @Year and ProvinceId = @ProvinceId and PlanType = @PlanType"; SqlParameter prmEnrollmentPlanId = new SqlParameter("@EnrollmentPlanId", SqlDbType.Int) { Value = enrollmentPlan.EnrollmentPlanId }; SqlParameter prmDiscipline = new SqlParameter("@Discipline", SqlDbType.Int) { Value = enrollmentPlan.Discipline }; SqlParameter prmMajorName = new SqlParameter("@MajorName", SqlDbType.VarChar, 100) { Value = enrollmentPlan.MajorName }; SqlParameter prmYear = new SqlParameter("@Year", SqlDbType.Int) { Value = enrollmentPlan.Year }; SqlParameter prmProvinceId = new SqlParameter("@ProvinceId", SqlDbType.Int) { Value = enrollmentPlan.ProvinceId }; SqlParameter prmPlanType = new SqlParameter("@PlanType", SqlDbType.Int) { Value = enrollmentPlan.PlanType }; return(Query(CheckUnique, sql, prmEnrollmentPlanId, prmDiscipline, prmMajorName, prmYear, prmProvinceId, prmPlanType)); }
public Entity Add(Entity entity) { EnrollmentPlan enrollmentPlan = entity as EnrollmentPlan; if (!CheckUnique(enrollmentPlan)) { return(null); } string sql = " insert into EnrollmentPlan(Year,UniversityId,PlanNumber,ProvinceId,Discipline,Tuition,MajorName,MajorCode,PlanType)values(@Year,@UniversityId,@PlanNumber,@ProvinceId,@Discipline,@Tuition,@MajorName,@MajorCode,@PlanType);select @EnrollmentPlanId = @@Identity"; SqlParameter prmYear = new SqlParameter("@Year", SqlDbType.Int) { Value = enrollmentPlan.Year }; SqlParameter prmMajorId = new SqlParameter("@UniversityId", SqlDbType.Int) { Value = enrollmentPlan.UniversityId }; SqlParameter prmPlanNumber = new SqlParameter("@PlanNumber", SqlDbType.Int) { Value = enrollmentPlan.PlanNumber }; SqlParameter prmProvinceId = new SqlParameter("@ProvinceId", SqlDbType.Int) { Value = enrollmentPlan.ProvinceId }; SqlParameter prmDiscipline = new SqlParameter("@Discipline", SqlDbType.Int) { Value = enrollmentPlan.Discipline }; SqlParameter prmTuition = new SqlParameter("@Tuition", SqlDbType.Int) { Value = enrollmentPlan.Tuition }; SqlParameter prmMajorName = new SqlParameter("@MajorName", SqlDbType.VarChar, 100) { Value = enrollmentPlan.MajorName }; SqlParameter prmMajorCode = new SqlParameter("@MajorCode", SqlDbType.VarChar, 50) { Value = enrollmentPlan.MajorCode }; SqlParameter prmEnrollmentPlanId = new SqlParameter("@EnrollmentPlanId", SqlDbType.Int) { Direction = ParameterDirection.Output }; SqlParameter prmPlanType = new SqlParameter("@PlanType", SqlDbType.Int) { Value = enrollmentPlan.PlanType }; ExecuteNoQuery(sql, prmYear, prmMajorId, prmPlanNumber, prmProvinceId, prmEnrollmentPlanId, prmDiscipline, prmTuition, prmMajorName, prmMajorCode, prmPlanType); return(enrollmentPlan); }
public Entity Update(Entity entity) { EnrollmentPlan enrollmentPlan = entity as EnrollmentPlan; if (!CheckUnique(enrollmentPlan)) { return(null); } string sql = "update EnrollmentPlan set Year = @Year,PlanNumber = @PlanNumber,ProvinceId = @ProvinceId,Discipline = @Discipline,Tuition = @Tuition,MajorName = @MajorName,MajorCode = @MajorCode,PlanType = @PlanType where EnrollmentPlanId= @EnrollmentPlanId"; SqlParameter prmYear = new SqlParameter("@Year", SqlDbType.Int) { Value = enrollmentPlan.Year }; SqlParameter prmPlanNumber = new SqlParameter("@PlanNumber", SqlDbType.Int) { Value = enrollmentPlan.PlanNumber }; SqlParameter prmProvinceId = new SqlParameter("@ProvinceId", SqlDbType.Int) { Value = enrollmentPlan.ProvinceId }; SqlParameter prmEnrollmentPlanId = new SqlParameter("@EnrollmentPlanId", SqlDbType.Int) { Value = enrollmentPlan.EnrollmentPlanId }; SqlParameter prmDiscipline = new SqlParameter("@Discipline", SqlDbType.Int) { Value = enrollmentPlan.Discipline }; SqlParameter prmTuition = new SqlParameter("@Tuition", SqlDbType.Int) { Value = enrollmentPlan.Tuition }; SqlParameter prmMajorName = new SqlParameter("@MajorName", SqlDbType.VarChar, 200) { Value = enrollmentPlan.MajorName }; SqlParameter prmMajorCode = new SqlParameter("@MajorCode", SqlDbType.VarChar, 50) { Value = enrollmentPlan.MajorCode }; SqlParameter prmPlanType = new SqlParameter("@PlanType", SqlDbType.Int) { Value = enrollmentPlan.PlanType }; ExecuteNoQuery(sql, prmYear, prmPlanNumber, prmProvinceId, prmEnrollmentPlanId, prmDiscipline, prmTuition, prmMajorName, prmMajorCode, prmPlanType); return(enrollmentPlan); }
private Entities GetList(SqlDataReader reader) { EnrollmentPlan enrollmentPlan; Entities entities = new Entities(); while (reader.Read()) { enrollmentPlan = new EnrollmentPlan(); enrollmentPlan.EnrollmentPlanId = reader.GetInt32(1); enrollmentPlan.Year = reader.GetInt32(2); enrollmentPlan.PlanNumber = reader.GetInt32(3); enrollmentPlan.ProvinceId = reader.GetInt32(4); enrollmentPlan.Discipline = reader.GetInt32(5); enrollmentPlan.Tuition = reader.GetInt32(6); enrollmentPlan.MajorName = reader.GetString(7); enrollmentPlan.MajorCode = reader.GetString(8); enrollmentPlan.UniversityId = reader.GetInt32(9); entities.Add(enrollmentPlan); } return(entities); }
private Entity GetOne(SqlDataReader reader) { if (!reader.HasRows) { SetError("招生计划不存在"); return(null); } reader.Read(); EnrollmentPlan enrollmentPlan = new EnrollmentPlan(); enrollmentPlan.EnrollmentPlanId = reader.GetInt32(0); enrollmentPlan.Year = reader.GetInt32(1); enrollmentPlan.UniversityId = reader.GetInt32(2); enrollmentPlan.PlanNumber = reader.GetInt32(3); enrollmentPlan.ProvinceId = reader.GetInt32(4); enrollmentPlan.Discipline = reader.GetInt32(5); enrollmentPlan.Tuition = reader.GetInt32(6); enrollmentPlan.MajorName = reader.GetString(7); enrollmentPlan.MajorCode = reader.GetString(8); enrollmentPlan.PlanType = reader.GetInt32(9); return(enrollmentPlan); }