public async Task <int> SaveMModule(MaintenanceModule maintenanceModule)
{
return(await WithConnection(async c =>
{
string sql = " insert into maintenance_module " +
" values (0,@Name,@Type,@PlanCode); ";
sql += "SELECT LAST_INSERT_ID() ";
int newid = await c.QueryFirstOrDefaultAsync <int>(sql, maintenanceModule);
return newid;
}));
}
public async Task <ApiResult> SaveMModule(MaintenanceModule maintenanceModule)
{
ApiResult ret = new ApiResult();
try
{
ret.data = await _repo.SaveMModule(maintenanceModule);
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
}
return(ret);
}
private List <MaintenanceModule> ListValues(List <MaintenanceModuleItemAll> mmiAll, int listID)
{
List <MaintenanceModule> mms = new List <MaintenanceModule>();
IEnumerable <IGrouping <int, MaintenanceModuleItemAll> > groupList = mmiAll.GroupBy(a => a.ID);
foreach (IGrouping <int, MaintenanceModuleItemAll> group in groupList)
{
IEnumerable <IGrouping <string, MaintenanceModuleItemAll> > groupByEqp = group.GroupBy(a => a.Eqp);
foreach (IGrouping <string, MaintenanceModuleItemAll> items in groupByEqp)
{
MaintenanceModule mm = new MaintenanceModule();
mm.ID = group.Key;
mm.Name = group.FirstOrDefault().ModuleName;
if (items.Key != null)
{
mm.ShowName = mm.Name + "(设备设施" + items.Key + ")";
mm.IsShowEqp = true;
mm.Eqp = items.Key;
}
else
{
mm.ShowName = mm.Name;
}
mm.Items = new List <MaintenanceModuleItemValue>();
foreach (var item in items)
{
MaintenanceModuleItemValue mmiv = new MaintenanceModuleItemValue();
mmiv.Item = item.Item;
mmiv.List = listID;
mmiv.Module = mm.ID;
mmiv.ItemName = item.ItemName;
mmiv.ItemType = item.ItemType;
mmiv.ItemValue = item.ItemValue;
mm.Items.Add(mmiv);
}
mms.Add(mm);
}
}
return(mms);
}
private List <MaintenanceModule> ListItems(List <MaintenanceModuleItemAll> mmiAll, int listID)
{
List <MaintenanceModule> mms = new List <MaintenanceModule>();
IEnumerable <IGrouping <int, MaintenanceModuleItemAll> > groupList = mmiAll.GroupBy(a => a.ID);
foreach (IGrouping <int, MaintenanceModuleItemAll> group in groupList)
{
int count = group.FirstOrDefault().Count;
for (int i = 0; i < count; i++)
{
MaintenanceModule mm = new MaintenanceModule();
mm.ID = group.Key;
mm.Name = group.FirstOrDefault().ModuleName;
if (count > 1)
{
mm.ShowName = mm.Name + "(设备设施" + (i + 1).ToString() + ")";
mm.IsShowEqp = true;
}
else
{
mm.ShowName = mm.Name;
}
mm.Items = new List <MaintenanceModuleItemValue>();
foreach (var item in group)
{
MaintenanceModuleItemValue mmiv = new MaintenanceModuleItemValue();
mmiv.Item = item.Item;
mmiv.List = listID;
mmiv.Module = mm.ID;
mmiv.ItemName = item.ItemName;
mmiv.ItemType = item.ItemType;
mm.Items.Add(mmiv);
}
mms.Add(mm);
}
}
return(mms);
}
public ActionResult SaveMModule(MaintenanceModule maintenanceModule)
{
var ret = _service.SaveMModule(maintenanceModule);
return(Ok(ret.Result));
}
