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