/// <summary>
/// 读取匹配关系（下载的）
/// </summary>
/// <returns></returns>
public DataTable Get_Ncms_Drug_MatchList()
{
string table_a = OleDB.ChildTable(HIS.BLL.Tables.NCMS_MATCH_CATALOG, "a", HIS.BLL.Tables.ncms_match_catalog.TYPE + OleDB.EuqalTo() + "'1'",
HIS.BLL.Tables.ncms_match_catalog.NCMS_CODE,
HIS.BLL.Tables.ncms_match_catalog.HOSPITAL_CODE,
HIS.BLL.Tables.ncms_match_catalog.STATUS,
HIS.BLL.Tables.ncms_match_catalog.TYPE,
HIS.BLL.Tables.ncms_match_catalog.UPLOAD_TIME,
HIS.BLL.Tables.ncms_match_catalog.UPLOADER,
HIS.BLL.Tables.ncms_match_catalog.APPROVE_STATUS);
string table_b = OleDB.ChildTable(HIS.BLL.Tables.NCMS_DRUG_CATALOG, "b", "",
HIS.BLL.Tables.ncms_drug_catalog.DRUG_CODE,
HIS.BLL.Tables.ncms_drug_catalog.DRUG_ALIAS,
HIS.BLL.Tables.ncms_drug_catalog.DRUG_NAME,
HIS.BLL.Tables.ncms_drug_catalog.DRUG_FORM);
string cast_2 = OleDB.DBConvert(HIS.BLL.Views.vi_item_drug.ITEMID, "char(10)");
string table_c = OleDB.ChildTable(HIS.BLL.Views.VI_ITEM_DRUG, "c", "",
OleDB.FiledNameBM(cast_2, HIS.BLL.Views.vi_item_drug.ITEMID),
HIS.BLL.Views.vi_item_drug.ITEMNAME,
HIS.BLL.Views.vi_item_drug.STANDARD,
OleDB.FiledNameBM(HIS.BLL.Views.vi_item_drug.PACKUNIT, "ITEM_UNIT"),
OleDB.FiledNameBM(HIS.BLL.Views.vi_item_drug.SELL_PRICE, "PRICE"),
HIS.BLL.Views.vi_item_drug.ADDRESS);
string strWhere = "a.ncms_code" + OleDB.EuqalTo() + "b.drug_code" + OleDB.And() + "a.hospital_code" + OleDB.EuqalTo() + "c.itemid";
string table = OleDB.Table(OleDB.TableName(table_a, table_b, table_c), "", strWhere, "*");
return(OleDB.GetDataTable(table));
}
