public IList <TrainCourse> GetTrainCourseInfo(int trainCourseID, int standardID, int courseNo, string courseName, string description, string studyDemand, decimal studyHours, bool hasExam, string examForm, int requireCourseID, string memo, int startRowIndex, int maximumRows, string orderBy) { IList <TrainCourse> objCourseList = new List <TrainCourse>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_COURSE_S"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); if (standardID != 0) { db.AddInParameter(dbCommand, "p_standard_id", DbType.Int32, standardID); } if (courseNo != 0) { db.AddInParameter(dbCommand, "p_course_no", DbType.Int32, courseNo); } db.AddInParameter(dbCommand, "p_start_row_index", DbType.Int32, startRowIndex); db.AddInParameter(dbCommand, "p_page_size", DbType.Int32, maximumRows); db.AddInParameter(dbCommand, "p_order_by", DbType.String, GetMappingOrderBy(orderBy)); db.AddOutParameter(dbCommand, "p_count", DbType.Int32, 4); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { TrainCourse obj = CreateModelObject(dataReader); objCourseList.Add(obj); } } _recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count")); return(objCourseList); }
private void MapTrainCourse(TrainCourse trainCourse, TrainCourseFormViewModel model, OptionsViewModel moreInfo) { model.Branches = model.IBranches == null ? null : string.Join(",", model.IBranches.ToArray()); model.Jobs = model.IJobs == null ? null : string.Join(",", model.IJobs.ToArray()); model.Employments = model.IEmployments == null ? null : string.Join(",", model.IEmployments.ToArray()); model.PeopleGroups = model.IPeopleGroups == null ? null : string.Join(",", model.IPeopleGroups.ToArray()); model.Payrolls = model.IPayrolls == null ? null : string.Join(",", model.IPayrolls.ToArray()); model.PayrollGrades = model.IPayrollGrades == null ? null : string.Join(",", model.IPayrollGrades.ToArray()); model.CompanyStuctures = model.ICompanyStuctures == null ? null : string.Join(",", model.ICompanyStuctures.ToArray()); model.Positions = model.IPositions == null ? null : string.Join(",", model.IPositions.ToArray()); model.PrevCourses = model.IPrevCourses == null ? null : string.Join(",", model.IPrevCourses.ToArray()); moreInfo.VisibleColumns.Add("Branches"); moreInfo.VisibleColumns.Add("Jobs"); moreInfo.VisibleColumns.Add("Employments"); moreInfo.VisibleColumns.Add("PeopleGroups"); moreInfo.VisibleColumns.Add("Payrolls"); moreInfo.VisibleColumns.Add("PayrollGrades"); moreInfo.VisibleColumns.Add("CompanyStuctures"); moreInfo.VisibleColumns.Add("Positions"); moreInfo.VisibleColumns.Add("PrevCourses"); _hrUnitOfWork.LeaveRepository.AddLName(Language, trainCourse.Name, model.Name, model.LocalName); if (trainCourse.Id == 0) { AutoMapper(new Models.AutoMapperParm { Destination = trainCourse, Source = model, ObjectName = "TrainCourse", Options = moreInfo, Transtype = TransType.Insert }); } else { AutoMapper(new Models.AutoMapperParm { Destination = trainCourse, Source = model, ObjectName = "TrainCourse", Options = moreInfo, Transtype = TransType.Update }); } }
/// <summary> /// 更新培训课程 /// </summary> /// <param name="obj"></param> public void UpdateTrainCourse(TrainCourse obj) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_COURSE_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_train_course_id", DbType.Int32, obj.TrainCourseID); db.AddInParameter(dbCommand, "p_standard_id", DbType.Int32, obj.StandardID); db.AddInParameter(dbCommand, "p_course_no", DbType.Int32, obj.CourseNo); db.AddInParameter(dbCommand, "p_course_name", DbType.String, obj.CourseName); db.AddInParameter(dbCommand, "p_description", DbType.String, obj.Description); db.AddInParameter(dbCommand, "p_study_demand", DbType.String, obj.StudyDemand); db.AddInParameter(dbCommand, "p_study_hours", DbType.VarNumeric, obj.StudyHours); db.AddInParameter(dbCommand, "p_has_exam", DbType.Int32, obj.HasExam ? 1 : 0); db.AddInParameter(dbCommand, "p_exam_form", DbType.String, obj.ExamForm); db.AddInParameter(dbCommand, "p_require_course_id", DbType.Int32, obj.RequireCourseID); db.AddInParameter(dbCommand, "p_memo", DbType.String, obj.Memo); db.ExecuteNonQuery(dbCommand); }
public IList <TrainCourse> GetTrainCommondCourseInfo() { IList <TrainCourse> objCourseList = new List <TrainCourse>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_COMMON_COURSE_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { TrainCourse obj = CreateModelObject(dataReader); objCourseList.Add(obj); } } return(objCourseList); }
public TrainCourse GetTrainCourseInfo(int trainCourseID) { TrainCourse obj = new TrainCourse(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_COURSE_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_train_course_id", DbType.Int32, trainCourseID); db.AddInParameter(dbCommand, "p_standard_id", DbType.Int32, 0); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { obj = CreateModelObject(dataReader); } } return(obj); }
public IList <TrainCourse> GetTrainCourseQueryInfo(string strSql) { IList <TrainCourse> objCourseList = new List <TrainCourse>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_TRAIN_COURSE_Q"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_strSql", DbType.String, strSql); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { TrainCourse obj = CreateModelObject(dataReader); objCourseList.Add(obj); } } return(objCourseList); }
public ActionResult DeleteTrainCourse(int id) { var message = "OK"; var Source = new DataSource <TrainCourseViewModel>(); Source.Errors = new List <Error>(); TrainCourse trainCourse = _hrUnitOfWork.TrainingRepository.GetTrainCourse(id); bool Exist = false; var ExistData = _hrUnitOfWork.Repository <TrainCourse>().Select(a => new { a.Id, a.PrevCourses }).ToList(); foreach (var item in ExistData) { if (item.PrevCourses != null) { if (item.PrevCourses.Split(',').Contains(trainCourse.Id.ToString())) { Exist = true; break; } } } if (!Exist) { if (trainCourse != null) { AutoMapper(new Models.AutoMapperParm { Source = trainCourse, ObjectName = "TrainCourses", Transtype = TransType.Delete }); _hrUnitOfWork.TrainingRepository.Remove(trainCourse); _hrUnitOfWork.TrainingRepository.RemoveLName(Language, trainCourse.Name); } Source.Errors = SaveChanges(Language); } else { Source.Errors.Add(new Error() { errors = new List <ErrorMessage>() { new ErrorMessage() { message = MsgUtils.Instance.Trls("connectwithData") } } }); } if (Source.Errors.Count() > 0) { return(Json(Source)); } else { return(Json(message)); } }
public ActionResult Details(TrainCourseFormViewModel model, OptionsViewModel moreInfo) { List <Error> errors = new List <Error>(); if (ModelState.IsValid) { if (ServerValidationEnabled) { errors = _hrUnitOfWork.SiteRepository.CheckForm(new CheckParm { CompanyId = CompanyId, ObjectName = "TrainCourse", TableName = "TrainCourses", Columns = Models.Utils.GetColumnViews(ModelState.Where(a => !a.Key.Contains('.'))), Culture = Language }); if (errors.Count() > 0) { foreach (var e in errors) { foreach (var errorMsg in e.errors) { ModelState.AddModelError(errorMsg.field, errorMsg.message); } } return(Json(Models.Utils.ParseFormErrors(ModelState))); } } //insert if (model.Id == 0) { var record = new TrainCourse(); MapTrainCourse(record, model, moreInfo); record.CreatedUser = UserName; record.CreatedTime = DateTime.Now; record.CompanyId = model.IsLocal ? CompanyId : (int?)null; if (record.StartDate > record.EndDate) { ModelState.AddModelError("EndDate", MsgUtils.Instance.Trls("EndDateGthanStartDate")); return(Json(Models.Utils.ParseFormErrors(ModelState))); } _hrUnitOfWork.TrainingRepository.Add(record); } //update else { var record = _hrUnitOfWork.Repository <TrainCourse>().FirstOrDefault(a => a.Id == model.Id); MapTrainCourse(record, model, moreInfo); record.ModifiedTime = DateTime.Now; record.ModifiedUser = UserName; record.CompanyId = model.IsLocal ? CompanyId : (int?)null; if (record.StartDate > record.EndDate) { ModelState.AddModelError("EndDate", MsgUtils.Instance.Trls("EndDateGthanStartDate")); return(Json(Models.Utils.ParseFormErrors(ModelState))); } _hrUnitOfWork.TrainingRepository.Attach(record); _hrUnitOfWork.TrainingRepository.Entry(record).State = EntityState.Modified; } var Errors = SaveChanges(Language); var message = "OK"; if (Errors.Count > 0) { message = Errors.First().errors.First().message; } return(Json(message)); } return(Json(Models.Utils.ParseFormErrors(ModelState))); }
/// <summary> /// 更新培训课程 /// </summary> /// <param name="trainCourse"></param> public void UpdateTrainCourse(TrainCourse trainCourse) { dal.UpdateTrainCourse(trainCourse); }
public void DeleteTrainCourse(TrainCourse trainCourse) { dal.DeleteTrainCourse(trainCourse.TrainCourseID); }
/// <summary> /// 新增培训课程 /// </summary> /// <param name="trainCourse"></param> public void AddTrainCourse(TrainCourse trainCourse) { dal.AddTrainCourse(trainCourse); }