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