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