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