public AisinoDataSet QueryGoods(FaPiaoQueryArgs QueryArgs, int pagesize, int pageno) { AisinoDataSet set; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("FPDM", "%" + QueryArgs.FPDM + "%"); dictionary.Add("FPHM", "%" + QueryArgs.FPHM + "%"); dictionary.Add("GFMC", "%" + QueryArgs.GFMC + "%"); dictionary.Add("GFSH", "%" + QueryArgs.GFSH + "%"); dictionary.Add("GGXH", "%" + QueryArgs.GGXH + "%"); dictionary.Add("SPMC", "%" + QueryArgs.SPMC + "%"); dictionary.Add("QSRQ", QueryArgs.StartTime); dictionary.Add("JZRQ", QueryArgs.EndTime); dictionary.Add("FPZL", QueryArgs.FPZL); dictionary.Add("ZFBZ", QueryArgs.ZFBZ); if (QueryArgs.StartTime.ToShortDateString() == "1753-1-1") { this.SQLID = "aisino.Fwkp.Wbjk.SPCXQueryAllDate"; } else { this.SQLID = "aisino.Fwkp.Wbjk.SPCXQuery"; } try { set = this.baseDAO.querySQLDataSet(this.SQLID, dictionary, pagesize, pageno); } catch (Exception exception) { this.loger.Info("商品查询失败"); ExceptionHandler.HandleError(exception); return(null); } return(set); }
public DataTable QueryGetGoods(FaPiaoQueryArgs QueryArgs) { DataTable table; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("FPDM", "%" + QueryArgs.FPDM + "%"); dictionary.Add("FPHM", "%" + QueryArgs.FPHM + "%"); dictionary.Add("GFMC", "%" + QueryArgs.GFMC + "%"); dictionary.Add("GFSH", "%" + QueryArgs.GFSH + "%"); dictionary.Add("GGXH", "%" + QueryArgs.GGXH + "%"); dictionary.Add("SPMC", "%" + QueryArgs.SPMC + "%"); dictionary.Add("QSRQ", QueryArgs.StartTime); dictionary.Add("JZRQ", QueryArgs.EndTime); dictionary.Add("FPZL", QueryArgs.FPZL); dictionary.Add("ZFBZ", QueryArgs.ZFBZ); if (QueryArgs.StartTime.ToShortDateString() == "1753-1-1") { this.SQLID = "aisino.Fwkp.Wbjk.SPCXQueryGetAllDate"; } else { this.SQLID = "aisino.Fwkp.Wbjk.SPCXQueryGet"; } try { table = this.baseDAO.querySQLDataTable(this.SQLID, dictionary); } catch (Exception exception) { this.loger.Info("商品查询失败"); ExceptionHandler.HandleError(exception); return(null); } return(table); }
public AisinoDataSet QueryGoods(FaPiaoQueryArgs QueryArgs, int pagesize, int pageno) { return(this.spcxDAL.QueryGoods(QueryArgs, pagesize, pageno)); }
public DataTable QueryGetGoods(FaPiaoQueryArgs QueryArgs) { return(this.spcxDAL.QueryGetGoods(QueryArgs)); }
public DataTable QueryGetFaPiaoxml(FaPiaoQueryArgs QueryArgs) { return(this.DAL_FPCX.QueryGetFaPiaoxml(QueryArgs)); }
public AisinoDataSet QueryFaPiao(FaPiaoQueryArgs QueryArgs, int pagesize, int pageno) { return(this.DAL_FPCX.QueryFaPiao(QueryArgs, pagesize, pageno)); }