/// <summary>
/// 设置报表头
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override ReportTitles GetReportTitles(IRptParams filter)
{
ReportTitles titles = new ReportTitles();
if (CacheDataList != null && CacheDataList.ContainsKey(filter.CurrentPosition))
{
var dr = CacheDataList[filter.CurrentPosition];
if (dr != null)
{
titles.AddTitle("F_QNWB_SalOrg", Convert.ToString(dr["FOrgName"]));
}
}
titles.AddTitle("F_QNWB_DateRange", String.Format("{0}至{1}", filters["StartDate"].Substring(0, 10), filters["EndDate"].Substring(0, 10)));
titles.AddTitle("F_QNWB_Currency", "人民币");
return(titles);
}
/// <summary>
/// 向报表临时表，插入报表数据
/// </summary>
/// <param name="filter">过滤信息</param>
/// <param name="tableName">临时表名</param>
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
base.BuilderReportSqlAndTempTable(filter, tableName);
KSQL_SEQ = string.Format(KSQL_SEQ, " t1.FMATERIALID asc");
string sql = string.Format(
@"
SELECT t0.FID ,
t1.FENTRYID ,
t1.FMATERIALID ,
t1M_L.FNAME AS FMATERIALNAME ,
t1.FQTY ,
t1U_L.FNAME AS FUNITNAME ,
t1f.FTAXPRICE ,
t1f.FALLAMOUNT ,
t1f.FTAXRATE ,
t0.FBILLNO ,
t0.FDATE ,
sl.FNAME AS FSUPPLIERNAME ,
{0}
INTO {1}
FROM T_PUR_POORDER t0
INNER JOIN T_PUR_POORDERENTRY t1 ON ( t0.FID = t1.FID )
INNER JOIN T_PUR_POORDERENTRY_F t1F ON ( t1.FENTRYID = t1f.FENTRYID )
LEFT JOIN T_BD_MATERIAL_L t1M_L on (t1.FMATERIALID = t1m_l.FMATERIALID and t1M_L.FLOCALEID = 2052)
LEFT JOIN T_BD_UNIT t1U ON ( t1f.FPRICEUNITID = t1u.FUNITID )
LEFT JOIN T_BD_UNIT_L t1U_L ON ( t1U.FUNITID = t1U_L.FUNITID AND t1U_L.FLOCALEID = 2052 )
LEFT JOIN T_BD_SUPPLIER_L sl ON (t0.FSUPPLIERID=sl.FSUPPLIERID AND sl.FLOCALEID = 2052 )
WHERE 1 = 1 ", KSQL_SEQ, tableName);
if (CacheDataList != null && CacheDataList.ContainsKey(filter.CurrentPosition))
{
var dr = CacheDataList[filter.CurrentPosition];
if (dr != null)
{
sql = sql + string.Format(" AND t0.FSUPPLIERID={0}", Convert.ToInt32(dr["FSUPPLIERID"]));
}
}
DBUtils.Execute(Context, sql);
}
/// <summary>
/// 设置报表标题
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override ReportTitles GetReportTitles(IRptParams filter)
{
var titles = base.GetReportTitles(filter);
if (titles == null)
{
titles = new ReportTitles();
}
if (CacheDataList != null && CacheDataList.ContainsKey(filter.CurrentPosition))
{
var dr = CacheDataList[filter.CurrentPosition];
if (dr != null)
{
titles.AddTitle("FSupplier", Convert.ToString(dr["FSUPPLIERNAME"]));
}
}
return(titles);
}
