public static int CreateTrainingSchedule(TrainingScheduleModel model) { using (var ctx = new DFAppEntities()) { var existing = ctx.TrainingSchedules.FirstOrDefault(x => x.TrainingLocationID == model.TrainingLocationID && x.WeekDay == model.WeekDay && x.StartTime == model.StartTime && x.EndTime == model.EndTime ); if (existing != null) { throw new Exception("error_training_schedule_exists"); } TrainingSchedules s = new TrainingSchedules() { TrainingLocationID = model.TrainingLocationID, WeekDay = model.WeekDay, StartTime = model.StartTime, EndTime = model.EndTime, Note = model.Note, Active = model.Active }; ctx.TrainingSchedules.Add(s); ctx.SaveChanges(); return(s.ID); } }
public static void SetActive(TrainingScheduleModel model) { using (var ctx = new DFAppEntities()) { var existing = ctx.TrainingSchedules.FirstOrDefault(x => x.ID == model.ID); if (existing != null) { existing.Active = model.Active; ctx.SaveChanges(); } else { throw new Exception("error_training_schedule_not_exist"); } } }
/// <summary> /// トレーニングスケジュール更新 /// </summary> /// <param name="id"></param> /// <param name="trainingMenu"></param> /// <param name="week"></param> /// <returns></returns> public bool UpdateTrainingSchedule(int id, string trainingMenu, int week) { var model = new TrainingScheduleModel { Id = id, TrainingMenu = trainingMenu, Week = week }; using (var db = new SQLiteConnection(DbConst.DbPath)) { var result = db.Update(model); if (result == DbConst.Failed) { return(false); } db.Commit(); return(true); } }
/// <summary> /// トレーニングスケジュール登録 /// </summary> /// <param name="trainingMenu"></param> /// <param name="week"></param> /// <returns></returns> public bool RegistTrainingSchedule(string trainingMenu, int week) { var model = new TrainingScheduleModel { TrainingMenu = trainingMenu, Week = week, RegistedDate = DateTime.Now }; using (var db = new SQLiteConnection(DbConst.DbPath)) { var result = db.Insert(model); if (result == DbConst.Failed) { return(false); } db.Commit(); return(true); } }
public void SetActive(TrainingScheduleModel model) { DB.Trainings.SetActive(model); }
public int CreateTrainingSchedule(TrainingScheduleModel model) { return(DB.Trainings.CreateTrainingSchedule(model)); }
/// <summary> /// 登陆或更新进度安排目标信息 /// </summary> /// <param name="lstCommand">数据库操作命令列表</param> /// <param name="lstSchedule">进度安排信息</param> /// <param name="trainingNo">培训编号</param> /// <param name="companyCD">公司代码</param> /// <param name="modifiedUserID">最后更新者ID</param> /// <returns></returns> private static void EditScheduleInfo(ArrayList lstCommand, ArrayList lstSchedule, string trainingNo , string companyCD, string modifiedUserID) { //未填写进度安排时,返回true //if (lstSchedule == null || lstSchedule.Count < 1) //{ // return; //} //全删全插方式插入进度安排信息 #region 除操作 //删除SQL StringBuilder deleteSql = new StringBuilder(); deleteSql.AppendLine(" DELETE FROM officedba.TrainingSchedule "); deleteSql.AppendLine(" WHERE "); deleteSql.AppendLine(" TrainingNo = @TrainingNo "); deleteSql.AppendLine(" AND CompanyCD = @CompanyCD "); //定义Command SqlCommand comm = new SqlCommand(); //设置执行 Transact-SQL 语句 comm.CommandText = deleteSql.ToString(); //培训编号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingNo", trainingNo)); //公司编码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", companyCD)); #endregion //添加删除命令 lstCommand.Add(comm); /* 插入操作 */ #region 插入SQL文 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO officedba.TrainingSchedule "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,TrainingNo "); insertSql.AppendLine(" ,ScheduleDate "); insertSql.AppendLine(" ,Abstract "); insertSql.AppendLine(" ,Remark "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@TrainingNo "); insertSql.AppendLine(" ,@ScheduleDate "); insertSql.AppendLine(" ,@Abstract "); insertSql.AppendLine(" ,@Remark "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID) "); #endregion //遍历所有的履历信息 for (int i = 0; i < lstSchedule.Count; i++) { //获取单条目标记录 TrainingScheduleModel model = (TrainingScheduleModel)lstSchedule[i]; //定义Command comm = new SqlCommand(); //设置执行 Transact-SQL 语句 comm.CommandText = insertSql.ToString(); #region 设置参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", companyCD)); //公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TrainingNo", trainingNo)); //培训编号(对应培训表中的培训编号) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ScheduleDate", model.ScheduleDate)); //时间 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Abstract", model.Abstract)); //内容摘要 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark)); //备注 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", modifiedUserID)); //更新用户ID #endregion //添加插入命令 lstCommand.Add(comm); } }