public override void Initialize()
{
this.ReportProperty.ReportName = new LocaleValue("销售排名报表-按产品", this.Context.UserLocale.LCID);
this.ReportProperty.IdentityFieldName = "FIDENTITYID";
List <DecimalControlField> list = new List <DecimalControlField>();
list.Add(new DecimalControlField
{
ByDecimalControlFieldName = "DANJIA",
DecimalControlFieldName = "JINDU"
});
GetSubStockNameUtils stocks = new GetSubStockNameUtils();
stockList = stocks.getStockID(this.Context);
foreach (DynamicStockObject stock in stockList)
{
list.Add(new DecimalControlField
{
ByDecimalControlFieldName = stock.ckName,
DecimalControlFieldName = "JINDU"
});
}
list.Add(new DecimalControlField
{
ByDecimalControlFieldName = "DIAOBOSUM",
DecimalControlFieldName = "JINDU"
});
list.Add(new DecimalControlField
{
ByDecimalControlFieldName = "DIAOBOJINE",
DecimalControlFieldName = "JINDU"
});
list.Add(new DecimalControlField
{
ByDecimalControlFieldName = "QIMOKUCUN",
DecimalControlFieldName = "JINDU"
});
list.Add(new DecimalControlField
{
ByDecimalControlFieldName = "QIMOKUCUNJINE",
DecimalControlFieldName = "JINDU"
});
this.ReportProperty.DecimalControlFieldList = list;
}
private string buildNoOutFlg(string ColumnNameKey)
{
List <string> notOutColumnNameList = new List <string>();
GetSubStockNameUtils stockNameObject = new GetSubStockNameUtils();
List <DynamicStockObject> stockObject = stockNameObject.getStockID(this.Context);
foreach (DynamicStockObject dso in stockObject)
{
notOutColumnNameList.Add(Convert.ToString(dso.ckName) + "notouttoal");
}
foreach (string columnName in notOutColumnNameList)
{
if (columnName.Equals(ColumnNameKey))
{
notOutColumnName = columnName;
}
}
return(notOutColumnName);
}
private void SetStockComList()
{
ComboFieldEditor headComboEidtor = this.View.GetControl <ComboFieldEditor>("F_PAEZ_outStock");
List <EnumItem> comboOptions = new List <EnumItem>();
GetSubStockNameUtils subStock = new GetSubStockNameUtils();
int i = 0;
List <DynamicStockObject> fldKeyList = subStock.getStockID(base.Context);
foreach (DynamicStockObject fldKey in fldKeyList)
{
comboOptions.Add(new EnumItem()
{
Caption = new LocaleValue(fldKey.StockName, this.View.Context.UserLocale.LCID), EnumId = i.ToString(), Seq = i, Value = fldKey.ToString()
});
i = i + 1;
}
headComboEidtor.SetComboItems(comboOptions);
}
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
string cks = string.Empty;
getFilterCondiftionFields(filter, base.Context, cks);
SQLStaticStatements sqlAllDetail = new SQLStaticStatements();
string sqlAll = sqlAllDetail.returnSQK4NoOutDetailReport();
GetSubStockNameUtils ckNameObject = new GetSubStockNameUtils();
List <DynamicStockObject> ckNameObj = ckNameObject.getStockID(this.Context);
foreach (DynamicStockObject ck in ckNameObj)
{
if (ck.ckName.Equals(ckName.Substring(0, 5)))
{
ckid = Convert.ToString(ck.stockid);
}
}
string executeSQL = string.Format(sqlAll, tableName, ckid, material);
DBUtils.Execute(this.Context, executeSQL);
}