public ActionResult Edit(STCheckEquipModel model) { ControllerResult result = ControllerResult.SuccResult; result.IsSucc = true; try { DateTime?timeStar = null, timeEnd = null; CommonUtils.GetLayuiDateRange(model.Time, out timeStar, out timeEnd); var editModel = new STCheckEquipEditServiceModel() { id = model.id, Customid = model.CustomName, EquName = model.EquipName, equspec = model.EquipSpec, equtype = model.EquipType, TimeStart = timeStar, TimeEnd = timeEnd, //checktime = DateTime.Parse(model.CheckTime), }; if (!model.BuyTime.IsNullOrEmpty()) { editModel.buyTime = DateTime.Parse(model.BuyTime); } if (!model.CheckTime.IsNullOrEmpty()) { editModel.checktime = DateTime.Parse(model.CheckTime); } string erroMsg = string.Empty; if (!sTCheckEquipService.EditCheckEquip(editModel, out erroMsg)) { result = ControllerResult.FailResult; result.ErroMsg = erroMsg; result.IsSucc = false; } } catch (Exception ex) { result = ControllerResult.FailResult; result.ErroMsg = ex.Message; result.IsSucc = false; } return(Content(result.ToJson())); }
public bool EditCheckEquip(STCheckEquipEditServiceModel model, out string erroMsg) { using (var db = dbFactory.Open()) { using (var dbTrans = db.OpenTransaction()) { try { erroMsg = string.Empty; db.UpdateOnly(new t_bp_Equipment_ST { customid = model.Customid, EquName = model.EquName, equspec = model.equspec, equtype = model.equtype, checktime = model.checktime, buytime = model.buyTime, timeend = model.TimeEnd, timestart = model.TimeStart }, r => new { r.customid, r.EquName, r.equspec, r.equtype, r.checktime, r.buytime, r.timestart, r.timeend }, r => r.Id == int.Parse(model.id) ); dbTrans.Commit(); return(true); } catch (Exception ex) { dbTrans.Rollback(); erroMsg = ex.Message; return(false); } } } }
public bool CreateCheckEquip(STCheckEquipEditServiceModel model, out string erroMsg) { using (var db = dbFactory.Open()) { using (var dbTrans = db.OpenTransaction()) { try { erroMsg = string.Empty; var STEquip = new t_bp_Equipment_ST() { customid = model.Customid, EquName = model.EquName, equspec = model.equspec, equtype = model.equtype, checkitem = model.checktime.ToString(), buytime = model.buyTime, timeend = model.TimeEnd, timestart = model.TimeStart, approvalstatus = "0", Id = 0 }; db.Insert(STEquip); dbTrans.Commit(); return(true); } catch (Exception ex) { dbTrans.Rollback(); erroMsg = ex.Message; return(false); } } } }