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