/// <summary> /// 编辑计价单数据 /// </summary> /// <param name="type">0:新增 1:修改</param> /// <param name="MedValuationItemList"></param> /// <returns>0:失败 1:成功 2:校验主键已存在</returns> public int EditMedValuationItemList(int type, MED_VALUATION_ITEM_LIST MedValuationItemList) { int result = 0; if (type == 0) { if (dapper.Set <MED_VALUATION_ITEM_LIST>().Single(d => d.ITEM_CODE == MedValuationItemList.ITEM_CODE) != null) { result = 2; } else { int maxItemCode = dapper.Set <MED_VALUATION_ITEM_LIST>().Select().Max(d => Convert.ToInt32(d.ITEM_CODE));// 获取整个计价单中最大的ITEM_CODE MedValuationItemList.ITEM_CODE = (maxItemCode + 1).ToString(); result = dapper.Set <MED_VALUATION_ITEM_LIST>().Insert(MedValuationItemList) ? 1 : 0; } } else { result = dapper.Set <MED_VALUATION_ITEM_LIST>().Update(MedValuationItemList) > 0 ? 1 : 0; } dapper.SaveChanges(); return(result); }
private void cbItemName_SelectionChanged(object sender, SelectionChangedEventArgs e) { object obj = (object)e.AddedItems; if (obj != null && ((object[])(obj)).Length > 0) { MED_VALUATION_ITEM_LIST row = ((MED_VALUATION_ITEM_LIST)(((object[])(obj))[0])); anesFreeViewModel.ChargItemChange(row); } }
/// <summary> /// 项目改变事件 /// </summary> public void ChargItemChange(MED_VALUATION_ITEM_LIST row) { if (SelectItem != null) { SelectItem.ITEM_CLASS = row.ITEM_CLASS; SelectItem.ITEM_SPEC = row.ITEM_SPEC; SelectItem.ITEM_NAME = row.ITEM_NAME; SelectItem.ITEM_CODE = row.ITEM_CODE; SelectItem.UNITS = row.UNITS; SelectItem.AMOUNT = 1; } }
/// <summary> /// 删除计价单数据 /// </summary> /// <param name="MedValuationItemList">要删除的计价单数据</param> /// <returns>0:失败 1:成功 2:校验主键已存在</returns> public int DeletedMedValuationItemList(List <MED_VALUATION_ITEM_LIST> MedValuationItemList) { int result = dapper.Set <MED_VALUATION_ITEM_LIST>().Delete(MedValuationItemList); //modified by joysola on 2018-6-13 联动删除 麻醉收费模板对应数据、对照表对应数据 if (MedValuationItemList[0] != null) { // 取临时变量,用于下面的lambda表达式 MED_VALUATION_ITEM_LIST tempData = MedValuationItemList[0]; int temp1 = dapper.Set <MED_ANES_BILL_TEMPLET>().Delete(d => d.ITEM_CLASS == tempData.ITEM_CLASS && d.ITEM_CODE == tempData.ITEM_CODE); int temp2 = dapper.Set <MED_ANES_VT_VS_CHARGE>().Delete(d => d.VT_ITEM_CALSS == tempData.ITEM_CLASS && d.VT_ITEM_CODE == tempData.ITEM_CODE); // 以下方法会报错 //int temp3 = dapper.Set<MED_ANES_BILL_TEMPLET>().Delete(d => d.ITEM_CLASS == MedValuationItemList[0].ITEM_CLASS && d.ITEM_CODE == MedValuationItemList[0].ITEM_CODE); //int temp4 = dapper.Set<MED_ANES_VT_VS_CHARGE>().Delete(d => d.VT_ITEM_CALSS == MedValuationItemList[0].ITEM_CLASS && d.VT_ITEM_CODE == MedValuationItemList[0].ITEM_CODE); } //modified end dapper.SaveChanges(); return(result); }
public RequestResult <int> EditMedValuationItemList(int type, MED_VALUATION_ITEM_LIST MedValuationItemList) { return(Success(ChargeInfo.EditMedValuationItemList(type, MedValuationItemList))); }