public static DataTable GetReceiptStatusList() { string query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList(); Receipt receipt = new Receipt(); receipt.LoadFromRawSql(query); System.Data.DataTable tbl = receipt.DataTable; query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList2(); receipt.FlushData(); receipt.LoadFromRawSql(query); tbl.Merge(receipt.DataTable); return(tbl); }
public static DataTable GetReceiptStatusList() { string query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList(); Receipt receipt = new Receipt(); receipt.LoadFromRawSql(query); System.Data.DataTable tbl = receipt.DataTable; query = HCMIS.Repository.Queries.Receipt.SelectGetReceiptStatusList2(); receipt.FlushData(); receipt.LoadFromRawSql(query); tbl.Merge(receipt.DataTable); return tbl; }