public IActionResult Add([FromBody] UnitDutyCheckSchedule model)
{
try
{
if (model == null)
{
return(BadRequest());
}
using (var db = new AllInOneContext.AllInOneContext())
{
db.UnitDutyCheckSchedule.Add(model);
db.SaveChanges();
return(Created("", "OK"));
}
}
catch (DbUpdateException dbEx)
{
return(BadRequest(new ApplicationException {
ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message
}));
}
catch (System.Exception ex)
{
return(BadRequest(new ApplicationException {
ErrorCode = "Unknown", ErrorMessage = ex.Message
}));
}
}
public IActionResult Get(Guid id)
{
try
{
using (var db = new AllInOneContext.AllInOneContext())
{
UnitDutyCheckSchedule data = db.UnitDutyCheckSchedule
.Include(t => t.Lister)
.Include(t => t.Organization)
.Include(t => t.UnitDutyCheckScheduleDetails).ThenInclude(t => t.CheckMan)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.CycleType)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods).ThenInclude(t => t.TimePeriods)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleType)
.FirstOrDefault(p => p.UnitDutyCheckScheduleId.Equals(id));
if (data == null)
{
return(NoContent());
}
return(new ObjectResult(data));
}
}
catch (Exception ex)
{
return(BadRequest(new ApplicationException {
ErrorCode = "Unknown", ErrorMessage = ex.Message
}));
}
}
public IActionResult Update([FromBody] UnitDutyCheckSchedule model)
{
try
{
if (model == null)
{
return(BadRequest());
}
using (var db = new AllInOneContext.AllInOneContext())
{
using (var tran = db.Database.BeginTransaction())
{
UnitDutyCheckSchedule dutyGroupSchedule = db.UnitDutyCheckSchedule
.Include(t => t.Lister)
.Include(t => t.Organization)
.Include(t => t.UnitDutyCheckScheduleDetails).ThenInclude(t => t.CheckMan)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.CycleType)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods).ThenInclude(t => t.TimePeriods)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleType)
.FirstOrDefault(p => p.UnitDutyCheckScheduleId.Equals(model.UnitDutyCheckScheduleId));
if (dutyGroupSchedule == null)
{
return(BadRequest());
}
//
dutyGroupSchedule.EndDate = model.EndDate;
dutyGroupSchedule.IsCancel = model.IsCancel;
dutyGroupSchedule.ListerId = model.ListerId;
dutyGroupSchedule.OrganizationId = model.OrganizationId;
dutyGroupSchedule.ScheduleId = model.ScheduleId;
dutyGroupSchedule.StartDate = model.StartDate;
dutyGroupSchedule.TabulationTime = model.TabulationTime;
//
RemoveDetails(db, model);
//
dutyGroupSchedule.UnitDutyCheckScheduleDetails = model.UnitDutyCheckScheduleDetails;
//
db.UnitDutyCheckSchedule.Update(dutyGroupSchedule);
db.SaveChanges();
tran.Commit();
return(new NoContentResult());
}
}
}
catch (DbUpdateException dbEx)
{
return(BadRequest(new ApplicationException {
ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message
}));
}
catch (System.Exception ex)
{
return(BadRequest(new ApplicationException {
ErrorCode = "Unknown", ErrorMessage = ex.Message
}));
}
}
/// <summary>
/// 解除明细表的关联
/// </summary>
/// <param name="db"></param>
/// <param name="model"></param>
private void RemoveDetails(AllInOneContext.AllInOneContext db, UnitDutyCheckSchedule model)
{
List <UnitDutyCheckScheduleDetail> delList = new List <UnitDutyCheckScheduleDetail>();
if (model.UnitDutyCheckScheduleDetails != null)
{
foreach (UnitDutyCheckScheduleDetail detail in model.UnitDutyCheckScheduleDetails)
{
UnitDutyCheckScheduleDetail del = db.Set <UnitDutyCheckScheduleDetail>().FirstOrDefault(p => p.UnitDutyCheckScheduleDetailId.Equals(detail.UnitDutyCheckScheduleDetailId));
if (del != null)
{
delList.Add(del);
}
}
}
db.Set <UnitDutyCheckScheduleDetail>().RemoveRange(delList);
db.SaveChanges();
}
public IActionResult Delete(Guid id)
{
try
{
using (var db = new AllInOneContext.AllInOneContext())
{
using (var tran = db.Database.BeginTransaction())
{
UnitDutyCheckSchedule dutyGroupSchedule = db.UnitDutyCheckSchedule
.Include(t => t.Lister)
.Include(t => t.Organization)
.Include(t => t.UnitDutyCheckScheduleDetails).ThenInclude(t => t.CheckMan)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.CycleType)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods).ThenInclude(t => t.TimePeriods)
.Include(t => t.Schedule).ThenInclude(t => t.ScheduleType)
.FirstOrDefault(p => p.UnitDutyCheckScheduleId.Equals(id));
if (dutyGroupSchedule == null)
{
return(BadRequest());
}
RemoveDetails(db, dutyGroupSchedule);
//
db.UnitDutyCheckSchedule.Remove(dutyGroupSchedule);
db.SaveChanges();
tran.Commit();
return(new NoContentResult());
return(new NoContentResult());
}
}
}
catch (System.Exception ex)
{
return(BadRequest(new ApplicationException {
ErrorCode = "Unknown", ErrorMessage = ex.Message
}));
}
}
private static void InitUnitDutyCheckSchedule()
{
using (var db = new AllInOneContext.AllInOneContext())
{
List <UnitDutyCheckScheduleDetail> list = new List <UnitDutyCheckScheduleDetail>();
list.Add(new UnitDutyCheckScheduleDetail
{
CheckManId = new Guid("5a23904c-4bb3-4caf-5212-9c58302721d5"),
Data = "2017-01-07",
TimePeriodId = new Guid("476f089d-cae0-0e10-4560-34f3ff659c9e"),
UnitDutyCheckScheduleDetailId = Guid.NewGuid()
});
//
list.Add(new UnitDutyCheckScheduleDetail
{
CheckManId = new Guid("9c1607e9-14a9-8ba1-caae-a211678390c3"),
Data = "2017-01-07",
TimePeriodId = new Guid("d2bb10b9-73a0-7117-cf5a-ab41f638c12b"),
UnitDutyCheckScheduleDetailId = Guid.NewGuid()
});
list.Add(new UnitDutyCheckScheduleDetail
{
CheckManId = new Guid("e4cb9413-31d5-984b-6d53-063df03cb97b"),
Data = "2017-01-08",
TimePeriodId = new Guid("476f089d-cae0-0e10-4560-34f3ff659c9e"),
UnitDutyCheckScheduleDetailId = Guid.NewGuid()
});
//
list.Add(new UnitDutyCheckScheduleDetail
{
CheckManId = new Guid("9c1607e9-14a9-8ba1-caae-a211678390c3"),
Data = "2017-01-08",
TimePeriodId = new Guid("d2bb10b9-73a0-7117-cf5a-ab41f638c12b"),
UnitDutyCheckScheduleDetailId = Guid.NewGuid()
});
UnitDutyCheckSchedule model = new UnitDutyCheckSchedule
{
EndDate = Convert.ToDateTime("2017-01-15"),
ListerId = new Guid("5a23904c-4bb3-4caf-5212-9c58302721d5"),
OrganizationId = new Guid("8098e65c-e366-404b-9d09-b8bcea3adca5"),
StartDate = Convert.ToDateTime("2017-01-09"),
ScheduleId = new Guid("9b94a7d4-9f34-a101-4b35-53db7ca37c2a"),
UnitDutyCheckScheduleId = Guid.NewGuid(),
UnitDutyCheckScheduleDetails = list
};
try
{
db.UnitDutyCheckSchedule.Add(model);
db.SaveChanges();
}
catch (Exception ex)
{
}
}
}
