//取单元格的字段作为可双击单元格进行跳转窗口
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;
}
}
//internal List<DynamicStockObject> getStockID(BOS.Context context, int id)
//{
// DynamicObjectCollection whCol = null;
// string cknameSql = " select a.stockid from T_BD_STOCK a inner join T_BD_STOCKGROUP b on b.FID=a.FGROUP WHERE b.fnumber = '02' order by a.fnumber ";
// whCol = DBServiceHelper.ExecuteDynamicObject(context, cknameSql) as DynamicObjectCollection;
// foreach (DynamicObject ckname in whCol)
// {
// fldKeyList.Add(Convert.ToString(ckname["STOCKID"]));
// }
// return fldKeyList;
// throw new NotImplementedException();
//}
internal List <DynamicStockObject> getStockID(BOS.Context context)
{
DynamicObjectCollection whCol = null;
string cknameSql = " SELECT a.FSTOCKID AS STOCKID, a.FNUMBER AS FNUMBER ,c.FNAME AS FNAME FROM T_BD_STOCK a INNER JOIN T_BD_STOCKGROUP b ON b.FID = a.FGROUP " +
"LEFT JOIN T_BD_STOCK_L C ON C.FSTOCKID = a.FSTOCKID WHERE b.fnumber = '02' ORDER BY a.fnumber";
whCol = DBServiceHelper.ExecuteDynamicObject(context, cknameSql) as DynamicObjectCollection;
foreach (DynamicObject ckname in whCol)
{
DynamicStockObject stockObject = new DynamicStockObject();
stockObject.stockid = Convert.ToInt32(ckname["STOCKID"]);
stockObject.ckName = Convert.ToString(ckname["FNUMBER"]);
stockObject.StockName = Convert.ToString(ckname["FNAME"]);
fldKeyList.Add(stockObject);
}
return(fldKeyList);
throw new NotImplementedException();
}
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;
}
}
}
}
