//反写报表过滤信息
public override ReportTitles GetReportTitles(IRptParams filter)
{
var result = base.GetReportTitles(filter);
DynamicObject dyFilter = filter.FilterParameter.CustomFilter;
if (dyFilter != null)
{
if (result == null)
{
result = new ReportTitles();
}
//反写过滤条件
//起始日期
if (dyFilter["F_QSNC_StartDateFilter"] == null)
{
result.AddTitle("F_QSNC_StartDate", "");
}
else
{
result.AddTitle("F_QSNC_StartDate", Convert.ToString(dyFilter["F_QSNC_StartDateFilter"]));
}
//截止日期
if (dyFilter["F_QSNC_EndDateFilter"] == null)
{
result.AddTitle("F_QSNC_EndDate", "");
}
else
{
result.AddTitle("F_QSNC_EndDate", Convert.ToString(dyFilter["F_QSNC_EndDateFilter"]));
}
//销售部门
if (dyFilter["F_QSNC_DeptFilter"] != null && ((DynamicObjectCollection)dyFilter["F_QSNC_DeptFilter"]).Count > 0)
{
StringBuilder deptName = new StringBuilder();
DynamicObjectCollection cols = (DynamicObjectCollection)dyFilter["F_QSNC_DeptFilter"];
foreach (DynamicObject dept in cols)
{
String tmpName = Convert.ToString(((DynamicObject)dept["F_QSNC_DeptFilter"])["Name"]);
deptName.Append(tmpName + "; ");
}
result.AddTitle("F_QSNC_Department", deptName.ToString());
}
else
{
result.AddTitle("F_QSNC_Department", "全部");
}
//销售员
if (dyFilter["F_QSNC_SalerFilter"] != null && ((DynamicObjectCollection)dyFilter["F_QSNC_SalerFilter"]).Count > 0)
{
StringBuilder salerName = new StringBuilder();
DynamicObjectCollection cols = (DynamicObjectCollection)dyFilter["F_QSNC_SalerFilter"];
foreach (DynamicObject saler in cols)
{
String tmpName = Convert.ToString(((DynamicObject)saler["F_QSNC_SalerFilter"])["Name"]);
salerName.Append(tmpName + "; ");
}
result.AddTitle("F_QSNC_Saler", salerName.ToString());
}
else
{
result.AddTitle("F_QSNC_Saler", "全部");
}
}
return(result);
}
//准备报表的表头信息
public override ReportTitles GetReportTitles(IRptParams filter)
{
var result = base.GetReportTitles(filter);
DynamicObject dyFilter = filter.FilterParameter.CustomFilter;
if (dyFilter != null)
{
if (result == null)
{
result = new ReportTitles();
}
// 物料
if (dyFilter["F_scfg_MaterialIdFilter"] != null && ((DynamicObjectCollection)dyFilter["F_scfg_MaterialIdFilter"]).Count > 0)
{
StringBuilder tmpNameCol = new StringBuilder();
DynamicObjectCollection cols = (DynamicObjectCollection)dyFilter["F_scfg_MaterialIdFilter"];
foreach (DynamicObject obj in cols)
{
String tmpName = Convert.ToString(((DynamicObject)obj["F_scfg_MaterialIdFilter"])["Name"]);
tmpNameCol.Append(tmpName + "; ");
}
result.AddTitle("F_scfg_MaterialId", tmpNameCol.ToString());
}
else
{
result.AddTitle("F_scfg_MaterialId", "全部物料");
}
// 仓库
if (dyFilter["F_scfg_StockIdFilter"] != null && ((DynamicObjectCollection)dyFilter["F_scfg_StockIdFilter"]).Count > 0)
{
StringBuilder tmpNameCol = new StringBuilder();
DynamicObjectCollection cols = (DynamicObjectCollection)dyFilter["F_scfg_StockIdFilter"];
foreach (DynamicObject obj in cols)
{
String tmpName = Convert.ToString(((DynamicObject)obj["F_scfg_StockIdFilter"])["Name"]);
tmpNameCol.Append(tmpName + "; ");
}
result.AddTitle("F_scfg_StockId", tmpNameCol.ToString());
}
else
{
result.AddTitle("F_scfg_StockId", "全部仓库");
}
// 批号
if (dyFilter["F_scfg_BatchFilter"] != null && ((DynamicObjectCollection)dyFilter["F_scfg_BatchFilter"]).Count > 0)
{
StringBuilder tmpNameCol = new StringBuilder();
DynamicObjectCollection cols = (DynamicObjectCollection)dyFilter["F_scfg_BatchFilter"];
foreach (DynamicObject obj in cols)
{
String tmpName = Convert.ToString(((DynamicObject)obj["F_scfg_BatchFilter"])["Name"]);
tmpNameCol.Append(tmpName + "; ");
}
result.AddTitle("F_scfg_Batch", tmpNameCol.ToString());
}
else
{
result.AddTitle("F_scfg_Batch", "全部批次");
}
}
return(result);
}
//准备报表的表头信息
public override ReportTitles GetReportTitles(IRptParams filter)
{
var result = base.GetReportTitles(filter);
DynamicObject customFilter = filter.FilterParameter.CustomFilter;
if (customFilter != null)
{
if (result == null)
{
result = new ReportTitles();
}
//商机编号
if (customFilter["F_QSNC_OppBillNoFilter"] != null)
{
String oppBillNo = Convert.ToString(customFilter["F_QSNC_OppBillNoFilter"]);
result.AddTitle("F_QSNC_OppBillNo", oppBillNo);
}
else
{
result.AddTitle("F_QSNC_OppBillNo", "全部");
}
if (customFilter["F_QSNC_StartDateFilter"] == null)
{
result.AddTitle("F_QSNC_StartDate", "");
}
else
{
result.AddTitle("F_QSNC_StartDate", Convert.ToString(customFilter["F_QSNC_StartDateFilter"]));
}
//截止日期
if (customFilter["F_QSNC_EndDateFilter"] == null)
{
result.AddTitle("F_QSNC_EndDate", "");
}
else
{
result.AddTitle("F_QSNC_EndDate", Convert.ToString(customFilter["F_QSNC_EndDateFilter"]));
}
//销售部门
if (customFilter["F_QSNC_DeptFilter"] != null && ((DynamicObjectCollection)customFilter["F_QSNC_DeptFilter"]).Count > 0)
{
StringBuilder deptName = new StringBuilder();
DynamicObjectCollection cols = (DynamicObjectCollection)customFilter["F_QSNC_DeptFilter"];
foreach (DynamicObject dept in cols)
{
String tmpName = Convert.ToString(((DynamicObject)dept["F_QSNC_DeptFilter"])["Name"]);
deptName.Append(tmpName + "; ");
}
result.AddTitle("F_QSNC_Department", deptName.ToString());
}
else
{
result.AddTitle("F_QSNC_Department", "全部");
}
}
//当前日期
result.AddTitle("F_QSNC_CurrentDate", DateTime.Now.ToShortDateString());
return(result);
}
public override ReportTitles GetReportTitles(IRptParams filter)
{
string dept = string.Empty; string fforgroup = string.Empty;
if (dep != null)
{
dept = dep["Name"].ToString();
}
if (forgroup != null)
{
fforgroup = forgroup["FDataValue"].ToString();
}
string s = string.Empty;
ReportTitles titles = new ReportTitles();
string tableTitle = string.Empty;
//long titleFilter = Convert.ToInt64(filter.FilterParameter.CustomFilter["F_TL_Combo"]);
switch (columnFilter)
{
case 1:
s = "KA部门-KA组";
tableTitle = string.Format(@"KA部门销售数据查询");
break;
case 2:
s = "KA部门-产品";
tableTitle = string.Format(@"KA部门销售数据查询");
break;
case 3:
s = "KA部门-产品-KA组";
tableTitle = string.Format(@"KA部门{0}销售数据查询", mat["Name"].ToString());
break;
case 4:
s = "KA部门-KA组-产品";
tableTitle = string.Format(@"KA部门{0}销售数据查询", dept);
break;
case 5:
s = "KA部门-KA组-连锁";
tableTitle = string.Format(@"KA部门{0}销售数据查询", dept);
break;
case 6:
s = "KA部门-KA组-连锁-客户";
tableTitle = string.Format(@"KA部门{0}{1}销售数据查询", dept, fforgroup);
break;
case 7:
s = "KA部门-连锁-客户";
tableTitle = string.Format(@"KA部门{0}销售数据查询", fforgroup);
break;
default: break;
}
titles.AddTitle("FTITLEFILTER", tableTitle);
titles.AddTitle("F_JF_Label", s);
return(titles);
}
