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