/// <summary>
/// 获取医院药品列表清单
/// </summary>
/// <returns></returns>
public DataTable Get_HIS_DrugList()
{
string childtable_1 = OleDB.ChildTable(OleDB.TableNameBM(Views.VI_DRUG_YK, ""), "", "",
Views.vi_drug_yk.MAKERDICID,
Views.vi_drug_yk.NAME,
"chemname",
Views.vi_drug_yk.TYPEDICID,
Views.vi_drug_yk.SPEC,
Views.vi_drug_yk.UNITNAME,
Views.vi_drug_yk.DOSEDICID,
Views.vi_drug_yk.PACKUNIT,
Views.vi_drug_yk.PACKNUM,
Views.vi_drug_yk.RETAILPRICE,
Views.vi_drug_yk.PRODUCTNAME);
string childtable_2 = OleDB.ChildTable(OleDB.TableNameBM(Views.VI_DRUG_YF, ""), "", "",
Views.vi_drug_yf.MAKERDICID,
Views.vi_drug_yf.NAME,
"chemname",
Views.vi_drug_yf.TYPEDICID,
Views.vi_drug_yf.SPEC,
Views.vi_drug_yf.UNITNAME,
Views.vi_drug_yf.DOSEDICID,
Views.vi_drug_yf.PACKUNIT,
Views.vi_drug_yf.PACKNUM,
Views.vi_drug_yf.RETAILPRICE,
Views.vi_drug_yf.PRODUCTNAME);
string subTable = "(" + childtable_1 + OleDB.UnionAll() + childtable_2 + ")";
string cast = OleDB.DBConvert(Tables.ncms_match_catalog_temp.HOSPITAL_CODE, "INTEGER");
string strWhere = OleDB.ChildTable(Tables.NCMS_MATCH_CATALOG_TEMP, "", Tables.ncms_match_catalog_temp.TYPE + OleDB.EuqalTo() + "'1'", OleDB.FiledNameBM(cast, "his_code"));
string strWhere_1 = Views.vi_drug_yk.MAKERDICID + " NOT IN " + strWhere;
string strsql = OleDB.Table(subTable, "A", strWhere_1,
OleDB.FiledNameBM(OleDB.Distinct(Views.vi_drug_yk.MAKERDICID), "code"),
Views.vi_drug_yk.NAME, "chemname",
OleDB.FiledNameBM(Views.vi_drug_yk.TYPEDICID, "type"),
Views.vi_drug_yk.SPEC,
OleDB.FiledNameBM(Views.vi_drug_yk.UNITNAME, "unit"),
OleDB.FiledNameBM(Views.vi_drug_yk.RETAILPRICE, "price"),
OleDB.FiledNameBM(Views.vi_drug_yk.DOSEDICID, "model"),
OleDB.FiledNameBM(Views.vi_drug_yk.PRODUCTNAME, "factory"));
return(OleDB.GetDataTable(strsql));
}
