public DataTable QueryGetGoods(InvoiceQueryCondition QueryArgs) { DataTable table; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("FPDM", "%"); dictionary.Add("FPHM", "%"); dictionary.Add("GFSH", "%"); dictionary.Add("GFMC", "%"); dictionary.Add("SPMC", "%"); dictionary.Add("GGXH", "%"); if (QueryArgs.m_strInvCodeList.Count > 0) { dictionary["FPDM"] = QueryArgs.m_strInvCodeList; } if (QueryArgs.m_strInvNumList.Count > 0) { dictionary["FPHM"] = QueryArgs.m_strInvNumList; } if (QueryArgs.m_strBuyerCodeList.Count > 0) { dictionary["GFSH"] = QueryArgs.m_strBuyerCodeList; } if (QueryArgs.m_strBuyerNameList.Count > 0) { dictionary["GFMC"] = QueryArgs.m_strBuyerNameList; } if (QueryArgs.m_strGoodsNameList.Count > 0) { dictionary["SPMC"] = QueryArgs.m_strGoodsNameList; } if (QueryArgs.m_strStateList.Count > 0) { dictionary["GGXH"] = QueryArgs.m_strStateList; } dictionary.Add("QSRQ", QueryArgs.m_dtStart); dictionary.Add("JZRQ", QueryArgs.m_dtEnd); dictionary.Add("FPZL", QueryArgs.m_strInvType); dictionary.Add("ZFBZ", QueryArgs.m_strWasteFlag); if (QueryArgs.m_dtStart == Convert.ToDateTime("0001-01-01")) { this.SQLID = "aisino.Fwkp.Wbjk.GoodsQueryAllDateExport"; } else { this.SQLID = "aisino.Fwkp.Wbjk.GoodsQueryTheDateExport"; } try { table = this.baseDAO.querySQLDataTable(this.SQLID, dictionary); } catch (Exception exception) { this.loger.Info("商品查询失败"); ExceptionHandler.HandleError(exception); return(null); } return(table); }
public AisinoDataSet QueryGoods(InvoiceQueryCondition QueryArgs, int pagesize, int pageno) { if (QueryArgs.m_dtStart > QueryArgs.m_dtEnd) { throw new CustomException("截止日期不能小于起始日期"); } return(this.spcxDAL.QueryGoods(QueryArgs, this.Pagesize, pageno)); }
public AisinoDataSet GetInvoiceDetail(InvoiceQueryCondition invoiceQueryCondition, int nPageSize, int nPageNo) { if (invoiceQueryCondition.m_dtStart > invoiceQueryCondition.m_dtEnd) { throw new CustomException("截止日期不能小于起始日期"); } return(this.DAL_FPCX.GetInvoiceDetail(invoiceQueryCondition, nPageSize, nPageNo)); }
public AisinoDataSet GetInvoiceDetail(InvoiceQueryCondition QueryArgs, int nPageSize, int nPageNo) { AisinoDataSet set; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("FPZL", QueryArgs.m_strInvType); dictionary.Add("ZFBZ", QueryArgs.m_strWasteFlag); dictionary.Add("GFSH", "%"); dictionary.Add("GFMC", "%"); dictionary.Add("FPDM", "%"); dictionary.Add("FPHM", "%"); dictionary.Add("XSDJBH", "%"); if (QueryArgs.m_strBuyerCodeList.Count > 0) { dictionary["GFSH"] = QueryArgs.m_strBuyerCodeList; } if (QueryArgs.m_strBuyerNameList.Count > 0) { dictionary["GFMC"] = QueryArgs.m_strBuyerNameList; } if (QueryArgs.m_strInvCodeList.Count > 0) { dictionary["FPDM"] = QueryArgs.m_strInvCodeList; } if (QueryArgs.m_strInvNumList.Count > 0) { dictionary["FPHM"] = QueryArgs.m_strInvNumList; } if (QueryArgs.m_strBillCodeList.Count > 0) { dictionary["XSDJBH"] = QueryArgs.m_strBillCodeList; } if (QueryArgs.m_dtStart == Convert.ToDateTime("0001-01-01")) { this.SQLID = "aisino.Fwkp.Wbjk.InvQueryAllDateXXFP"; } else { dictionary.Add("BEGINDATE", QueryArgs.m_dtStart); dictionary.Add("ENDDATE", QueryArgs.m_dtEnd); this.SQLID = "aisino.Fwkp.Wbjk.InvQueryTheDateXXFP"; } try { set = this.baseDAO.querySQLDataSet(this.SQLID, dictionary, nPageSize, nPageNo); } catch (Exception exception) { this.loger.Info(exception.Message); ExceptionHandler.HandleError(exception); return(null); } return(set); }
public DataTable QueryGetGoods(InvoiceQueryCondition QueryArgs) { return(this.spcxDAL.QueryGetGoods(QueryArgs)); }
public DataTable QueryGetFaPiaoxml(InvoiceQueryCondition QueryArgs) { return(this.DAL_FPCX.QueryGetFaPiaoxml(QueryArgs)); }