private MaintenanceList GetMList(ConstructionPlanMonthDetail detail, DateTime dt)
{
MaintenanceList ret = new MaintenanceList();
ret.CreatedBy = _userID;
ret.CreatedTime = dt;
ret.Status = (int)PMStatus.Init;
ret.Team = detail.Team;
ret.UpdatedBy = _userID;
ret.UpdatedTime = dt;
return(ret);
}
public async Task <int> SaveMList(MaintenanceList maintenanceList)
{
return(await WithConnection(async c =>
{
string sql = " insert into maintenance_list " +
" values (0,@Title,@Team,@PlanDate,@Location,@LocationBy,@Status,@Remark," +
" @CreatedBy,@CreatedTime,@UpdatedBy,@UpdatedTime); ";
sql += "SELECT LAST_INSERT_ID() ";
int newid = await c.QueryFirstOrDefaultAsync <int>(sql, maintenanceList);
return newid;
}));
}
private List <MaintenanceList> GetDayMLists(MaintenanceList ml, int year)
{
List <MaintenanceList> ret = new List <MaintenanceList>();
for (int i = 0; i < 12; i++)
{
int day = Convert.ToInt32(Model.Common.GetLastDay(i, year));
for (int j = 0; j < day; i++)
{
string tmp = year + "-" + i.ToString("D2") + "-" + j.ToString("D2");
ml.PlanDate = tmp;
ret.Add(ml);
}
}
return(ret);
}
//自动生成检修单，此逻辑未完成，暂时不做
private List <MaintenanceList> GetMLists(List <ConstructionPlanMonthDetail> month, int year, DateTime dt)
{
List <MaintenanceList> ret = new List <MaintenanceList>();
IEnumerable <IGrouping <int, ConstructionPlanMonthDetail> > groupList = month.GroupBy(a => a.Team);
foreach (IGrouping <int, ConstructionPlanMonthDetail> group in groupList)
{
//需要拼凑的，目前只限于日检
List <ConstructionPlanMonthDetail> days = group.Where(a => a.PMType == (int)PMTYPE.Day).ToList();
MaintenanceList day = GetMList(days[0], dt);
ret.AddRange(GetDayMLists(day, year));
//非日检的，一个module就是一张检修表
List <ConstructionPlanMonthDetail> notDays = group.Where(a => a.PMType != (int)PMTYPE.Day).ToList();
foreach (var item in notDays)
{
MaintenanceList notDay = GetMList(item, dt);
notDay.PlanDate = item.PlanDate;
ret.Add(notDay);
}
}
return(ret);
}
public async Task <ApiResult> SaveMList(MaintenanceList maintenanceList)
{
ApiResult ret = new ApiResult();
int retData = 0;
DateTime dt = DateTime.Now;
maintenanceList.CreatedBy = _userID;
maintenanceList.CreatedTime = dt;
maintenanceList.Status = (int)PMStatus.Init;
maintenanceList.UpdatedBy = _userID;
maintenanceList.UpdatedTime = dt;
try
{
List <MaintenancePlanDetail> mpds = new List <MaintenancePlanDetail>();
using (TransactionScope scope = new TransactionScope())
{
retData = await _repo.SaveMList(maintenanceList);
foreach (var item in maintenanceList.Details)
{
item.List = retData;
mpds.Add(item);
}
retData = await _repo.SaveMDetail(mpds);
scope.Complete();
}
ret.data = retData;
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
}
return(ret);
}
public ActionResult SaveMList(MaintenanceList maintenanceList)
{
var ret = _service.SaveMList(maintenanceList);
return(Ok(ret.Result));
}
