/// <summary> /// 编辑关系表数据 /// </summary> /// <param name="type">0:新增 1:修改</param> /// <param name="anesVsCharge">关系表数据</param> /// <returns>0:失败 1:成功 2:校验主键已存在</returns> public int EditAnesVsCharge(int type, MED_ANES_VT_VS_CHARGE anesVsCharge) { int result = 0; anesVsCharge.SPEC = anesVsCharge.SPEC / 100; if (type == 0) { //由于 价表没有主键,所以不进行重复项区分 //if (dapper.Set<MED_ANES_VT_VS_CHARGE>().Single(d => d.ITEM_CODE == anesVsCharge.ITEM_CODE) != null) //{ // result = 2; //} //else // { List <MED_ANES_VT_VS_CHARGE> tempList = dapper.Set <MED_ANES_VT_VS_CHARGE>().Select(d => d.VT_ITEM_CODE == anesVsCharge.VT_ITEM_CODE); int maxNo = tempList.Count == 0 ? 0 : tempList.Max(d => d.VS_NO); // 如果是第一项,则序号为0,不写会报错 anesVsCharge.VS_NO = maxNo + 1; // 插入时自动序号加一 result = dapper.Set <MED_ANES_VT_VS_CHARGE>().Insert(anesVsCharge) ? 1 : 0; // } } else { result = dapper.Set <MED_ANES_VT_VS_CHARGE>().Update(anesVsCharge) > 0 ? 1 : 0; } dapper.SaveChanges(); return(result); }
public RequestResult <int> EditAnesVsCharge(int type, MED_ANES_VT_VS_CHARGE AnesVsCharge) { return(Success(ChargeInfo.EditAnesVsCharge(type, AnesVsCharge))); }