public bool insertNewMedicine(MedicineDTO medicine) { try { Db.Ado.BeginTran(); MEDICINE_INFORMATION medicineInformation = new MEDICINE_INFORMATION() { MEDICINE_ID = medicine._medicine_id, MEDICINE_APPLICABILITY = medicine._medicine_applicability, MEDICINE_CHARACTER = medicine._medicine_character, MEDICINE_ATTENTION = medicine._medicine_attention, MEDICINE_NAME = medicine._medicine_name, MEDICINE_TYPE = medicine._medicine_type, MEDICINE_INGREDIENTS = medicine._medicine_ingredients, MEDICINE_USAGE = medicine._medicine_usage, SUPPLIER_ID = medicine._supplier_id, MEDICINE_IMAGE = medicine._medicine_image }; bool judge = Db.Queryable <MEDICINE_INFORMATION>().Where(it => it.MEDICINE_ID == medicine._medicine_id).Any(); if (!judge) { Db.Insertable(medicineInformation).ExecuteCommand(); } Db.Ado.CommitTran(); return(true); } catch (Exception ex) { Db.Ado.RollbackTran(); return(false); } }
public bool updateMedicineInfo(MedicineDTO medicineDTO) { try { Db.Ado.BeginTran(); MEDICINE_INFORMATION medicineInformation = new MEDICINE_INFORMATION() { MEDICINE_ID = medicineDTO._medicine_id, MEDICINE_APPLICABILITY = medicineDTO._medicine_applicability, MEDICINE_CHARACTER = medicineDTO._medicine_character, MEDICINE_ATTENTION = medicineDTO._medicine_attention, MEDICINE_NAME = medicineDTO._medicine_name, MEDICINE_TYPE = medicineDTO._medicine_type, MEDICINE_INGREDIENTS = medicineDTO._medicine_ingredients, MEDICINE_USAGE = medicineDTO._medicine_usage, SUPPLIER_ID = medicineDTO._supplier_id, MEDICINE_IMAGE = medicineDTO._medicine_image }; Db.Updateable(medicineInformation).ExecuteCommand(); Db.Ado.CommitTran(); return(true); } catch (Exception ex) { Db.Ado.RollbackTran(); return(false); } }
//获取所有药品的销售记录 public List <MedicineSaleDataDTO> getAllMedicineSaleData() { List <MedicineSaleDataDTO> group = Db.Queryable <SALE_RECORD_ITEM, MEDICINE_INFORMATION>( (s, mi) => s.MEDICINE_ID == mi.MEDICINE_ID).GroupBy((s, mi) => mi.MEDICINE_ID) .Select((s, mi) => new MedicineSaleDataDTO { _medicine_id = mi.MEDICINE_ID, _sale_num = SqlFunc.AggregateSum(s.SALE_NUM) }).ToList(); foreach (MedicineSaleDataDTO temp in group) { MEDICINE_INFORMATION s = Db.Queryable <MEDICINE_INFORMATION>().InSingle(temp._medicine_id); int amount = Db.Queryable <MEDICINE_STOCK>().Where(it => it.MEDICINE_ID == temp._medicine_id).Sum(it => it.AMOUNT); temp._medicine_name = s.MEDICINE_NAME; temp._amount = amount; } group.Sort(); return(group); }