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