public int DeleteAnesBillTemplete(int type, MED_ANES_BILL_TEMPLET model) { int result = 0; if (model == null) { return(-1); } else { if (type == 0) { //删除模版事件 result = dapper.Set <MED_ANES_BILL_TEMPLET>().Delete(d => d.TEMPLET == model.TEMPLET && d.ANESTHESIA_METHOD == model.ANESTHESIA_METHOD && d.ITEM_CLASS == model.ITEM_CLASS && d.ITEM_NO == model.ITEM_NO); } else { //删除模版 result = dapper.Set <MED_ANES_BILL_TEMPLET>().Delete(d => d.TEMPLET == model.TEMPLET && d.ANESTHESIA_METHOD == model.ANESTHESIA_METHOD); } dapper.SaveChanges(); return(result); } }
public int EditAnesBillTemplete(int type, MED_ANES_BILL_TEMPLET model) { int result = 0; if (type == 0) //新增 { MED_ANES_BILL_TEMPLET newModel = new MED_ANES_BILL_TEMPLET(); newModel.TEMPLET = model.TEMPLET; newModel.ANESTHESIA_METHOD = model.ANESTHESIA_METHOD; newModel.TEMPLET_CLASS = model.TEMPLET_CLASS; MED_ANES_BILL_TEMPLET obj = dapper.Set <MED_ANES_BILL_TEMPLET>().Select(p => p.TEMPLET == model.TEMPLET && p.ANESTHESIA_METHOD == model.ANESTHESIA_METHOD).OrderByDescending(x => x.ITEM_NO).FirstOrDefault(); int maxItemId = 0; if (obj != null) { maxItemId = Convert.ToInt32(obj.ITEM_NO); } newModel.ITEM_NO = maxItemId + 1; newModel.ITEM_CLASS = model.ITEM_CLASS; newModel.ITEM_CODE = model.ITEM_CODE; newModel.ITEM_NAME = model.ITEM_NAME; newModel.ITEM_SPEC = model.ITEM_SPEC; newModel.UNITS = model.UNITS; newModel.AMOUNT = model.AMOUNT; result = dapper.Set <MED_ANES_BILL_TEMPLET>().Insert(newModel) ? 1 : 0; } else //修改 { MED_ANES_BILL_TEMPLET newModel = dapper.Set <MED_ANES_BILL_TEMPLET>().Single(d => d.TEMPLET == model.TEMPLET && d.ANESTHESIA_METHOD == model.ANESTHESIA_METHOD && d.ITEM_NO == model.ITEM_NO); newModel.ITEM_CLASS = model.ITEM_CLASS; newModel.ITEM_CODE = model.ITEM_CODE; newModel.ITEM_NAME = model.ITEM_NAME; newModel.ITEM_SPEC = model.ITEM_SPEC; newModel.UNITS = model.UNITS; newModel.AMOUNT = model.AMOUNT; result = dapper.Set <MED_ANES_BILL_TEMPLET>().Update(newModel, null, d => d.TEMPLET == model.TEMPLET && d.ANESTHESIA_METHOD == model.ANESTHESIA_METHOD && d.ITEM_NO == model.ITEM_NO) > 0 ? 1 : 0; } dapper.SaveChanges(); return(result); }
public RequestResult <int> EditAnesBillTemplete(int type, MED_ANES_BILL_TEMPLET model) { return(Success(ChargeInfo.EditAnesBillTemplete(type, model))); }