/// <summary> /// 按病人信息检索已发药明细信息 /// </summary> /// <param name="invoiceNum">发票号</param> /// <returns>已发药明细信息</returns> public static DataTable QueryRefRecipeOrder(string invoiceNum) { HIS.DAL.YP_Dal dal = new YP_Dal(); dal._oleDb = oleDb; string strWhere = "E." + Tables.yf_drorder.INVOICENUM + oleDb.EuqalTo() + invoiceNum; return(dal.YF_DispenseOrder_GetList(strWhere)); }
/// <summary> /// 加载发/退药单据明细 /// </summary> /// <param name="billMaster">单据头表</param> /// <returns></returns> public override DataTable LoadOrder(BillMaster billMaster) { try { YP_DRMaster queryMaster = (YP_DRMaster)billMaster; YP_Dal ypDal = new YP_Dal(); ypDal._oleDb = oleDb; string strWhere = "A.MASTERDRUGOCID" + oleDb.EuqalTo() + queryMaster.MasterDrugOCID; return(ypDal.YF_DispenseOrder_GetList(strWhere)); } catch (Exception error) { throw error; } }
/// <summary> /// 加载住院统领单据明细 /// </summary> /// <param name="billMaster">单据头表</param> /// <returns></returns> public override DataTable LoadOrder(BillMaster billMaster) { try { YP_Dal ypDal = new YP_Dal(); ypDal._oleDb = oleDb; YP_DispDeptHis deptDisp = (YP_DispDeptHis)billMaster; DataTable deptDispOrder = new DataTable(); deptDispOrder.Columns.Add("ITEMNAME"); deptDispOrder.Columns.Add("STANDARD"); deptDispOrder.Columns.Add("PRODUCTNAME"); deptDispOrder.Columns.Add("AMOUNT", Type.GetType("System.Decimal")); deptDispOrder.Columns.Add("MAKERDICID"); deptDispOrder.Columns.Add("SELL_PRICE", Type.GetType("System.Decimal")); deptDispOrder.Columns.Add("TOLAL_FEE", Type.GetType("System.Decimal")); deptDispOrder.Columns.Add("UNIT"); deptDispOrder.Columns.Add("DOSEDICID"); deptDispOrder.PrimaryKey = new DataColumn[] { deptDispOrder.Columns["MAKERDICID"] }; string strWhere = "A.UNIFORMID" + oleDb.EuqalTo() + deptDisp.Id + oleDb.And() + "A.UNIFORM_FLAG" + oleDb.EuqalTo() + "1"; DataTable drOrders = ypDal.YF_DispenseOrder_GetList(strWhere); //设置摆药人员姓名 List <YP_DRMaster> drMasters = BindEntity <YP_DRMaster> .CreateInstanceDAL(oleDb, BLL.Tables.YF_DRMASTER).GetListArray("UNIFORMID=" + deptDisp.Id.ToString()); foreach (YP_DRMaster drmaster in drMasters) { deptDisp.PatientNames += drmaster.PatientName + ","; } for (int index = 0; index < drOrders.Rows.Count; index++) { DataRow drOrder = drOrders.Rows[index]; DataRow findRow = deptDispOrder.Rows.Find(drOrder["MAKERDICID"]); if (findRow != null) { findRow["AMOUNT"] = Convert.ToDecimal(findRow["AMOUNT"]) + Convert.ToDecimal(drOrder["DRUGOCNUM"]); findRow["TOLAL_FEE"] = Convert.ToDecimal(findRow["TOLAL_FEE"]) + Convert.ToDecimal(drOrder["RETAILFEE"]); } else { DataRow deptDispRow = deptDispOrder.NewRow(); deptDispRow["ITEMNAME"] = drOrder["CHEMNAME"]; deptDispRow["STANDARD"] = drOrder["SPEC"]; deptDispRow["PRODUCTNAME"] = drOrder["PRODUCTNAME"]; deptDispRow["AMOUNT"] = drOrder["DRUGOCNUM"]; deptDispRow["MAKERDICID"] = drOrder["MAKERDICID"]; deptDispRow["SELL_PRICE"] = drOrder["RETAILPRICE"]; deptDispRow["TOLAL_FEE"] = drOrder["RETAILFEE"]; deptDispRow["UNIT"] = drOrder["UNITNAME"]; deptDispRow["DOSEDICID"] = drOrder["DOSEDICID"]; deptDispOrder.Rows.Add(deptDispRow); } } deptDispOrder.DefaultView.Sort = "DOSEDICID ASC"; deptDispOrder = deptDispOrder.DefaultView.ToTable(); return(deptDispOrder); } catch (Exception error) { throw error; } }