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