private void getFilterCondiftionFields(IRptParams filter, BOS.Context context, string cks)
{
//定义是否从汇总表过来的过滤条件
Boolean fromMainReportFlag = false;
//用于定位明细的过滤条件map
Dictionary <string, object> selectedCurrentRow = new Dictionary <string, object>();
if (filter.CustomParams.Count > 0 && filter.CustomParams.ContainsKey("OpenParameter"))
{
selectedCurrentRow = (Dictionary <string, object>)filter.CustomParams["OpenParameter"];
fromMainReportFlag = true;
}
List <DynamicStockObject> fldKeyList = new GetSubStockNameUtils().getStockID(context);
foreach (DynamicStockObject fldKey in fldKeyList)
{
if (fromMainReportFlag)
{
if (selectedCurrentRow.ContainsKey(fldKey.ckName + "notouttoal"))
{
material = Convert.ToString(selectedCurrentRow[fldKey.ckName + "notouttoal"]);
ckName = fldKey.ckName;
}
}
}
}
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 void showSubReport(string ColumnNameKey, int rowSeq)
{
string formId = string.Empty;
if (ColumnNameKey.Equals(inStockColumnName))
{
// 入库明细报表
formId = inStockDetail;
showStockDetailReport(ColumnNameKey, rowSeq, formId);
}
if (ColumnNameKey.Equals(notOutColumnName))
{
// 未出明细报表
formId = notOut;
showStockDetailReport(ColumnNameKey, rowSeq, formId);
}
if (ColumnNameKey.Equals(onTheWayColumnName))
{
// 在途明细报表
formId = onTheWay;
showStockDetailReport(ColumnNameKey, rowSeq, formId);
}
//库存明细报表
List <DynamicStockObject> fldKeyList = new GetSubStockNameUtils().getStockID(this.Context);
DynamicStockObject ckchengpin = new DynamicStockObject();
ckchengpin.ckName = "CK002";
ckchengpin.StockName = "成品仓";
ckchengpin.stockid = 0;
fldKeyList.Add(ckchengpin);
foreach (DynamicStockObject ckname in fldKeyList)
{
if (ColumnNameKey.Equals(ckname.ckName))
{
formId = stockDetail;
showStockDetailReport(ColumnNameKey, rowSeq, formId);
}
}
if (string.IsNullOrWhiteSpace(formId))
{
return;
}
}
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);
}
private conditionEntry getFilterCondiftionFields(IRptParams filter, BOS.Context context, string cks)
{
//定义是否从汇总表过来的过滤条件
Boolean fromMainReportFlag = false;
//用于定位明细的过滤条件map
Dictionary<string, object> selectedCurrentRow = new Dictionary<string, object>();
if (filter.CustomParams.Count > 0 && filter.CustomParams.ContainsKey("OpenParameter"))
{
selectedCurrentRow = (Dictionary<string, object>)filter.CustomParams["OpenParameter"];
fromMainReportFlag = true;
}
List<DynamicStockObject> fldKeyList = new GetSubStockNameUtils().getStockID(context);
foreach (KeyValuePair<string, object> materialMap in selectedCurrentRow)
{
if (materialMap.Key.Equals(inStockColumnName))
{
return (conditionEntry)materialMap.Value;
}
}
return null;
}
private void getFilterCondiftionFields(IRptParams filter, BOS.Context context, string cks)
{
//定义是否从汇总表过来的过滤条件
Boolean fromMainReportFlag = false;
//用于定位明细的过滤条件map
Dictionary <string, object> selectedCurrentRow = new Dictionary <string, object>();
if (filter.CustomParams.Count > 0 && filter.CustomParams.ContainsKey("OpenParameter"))
{
selectedCurrentRow = (Dictionary <string, object>)filter.CustomParams["OpenParameter"];
fromMainReportFlag = true;
}
List <DynamicStockObject> fldKeyList = new GetSubStockNameUtils().getStockID(context);
DynamicStockObject ckchengpin = new DynamicStockObject();
ckchengpin.ckName = "CK002";
ckchengpin.StockName = "成品仓";
ckchengpin.stockid = 0;
fldKeyList.Add(ckchengpin);
foreach (DynamicStockObject fldKey in fldKeyList)
{
if (fromMainReportFlag)
{
if (selectedCurrentRow.ContainsKey(fldKey.ckName))
{
material = Convert.ToString(selectedCurrentRow[fldKey.ckName]);
ckName = fldKey.ckName;
}
if (!string.IsNullOrWhiteSpace(material))
{
break;
}
}
}
}
