public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
string cks = string.Empty;
conditionEntry condition = getFilterCondiftionFields(filter, base.Context, cks);
string material = condition.material;
string startDate = condition.startDate;
string endDate = condition.endDate;
decimal qichu = condition.qichu;
string cangku = condition.cangku;
string executeSQL = string.Empty;
SQLStaticStatements sqlAllDetail = new SQLStaticStatements();
string searchCondition = string.Empty;
string sqlAll = sqlAllDetail.returnSQLInStockDetailReport();
executeSQL = string.Format(sqlAll, tableName, material,cangku,startDate,endDate);
DBUtils.Execute(this.Context, executeSQL);
string SelectSQL = "select FDATE,BILLNO FROM {0} ";
using (IDataReader ReadData = DBUtils.ExecuteReader(this.Context, string.Format(SelectSQL, tableName)))
{
while (ReadData.Read())
{
string endDateCondition = Convert.ToDateTime(ReadData["FDATE"]).ToString("yyyy-MM-dd HH:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
string billno = Convert.ToString(ReadData["BILLNO"]);
string update4KCQTY = sqlAllDetail.returnSQL4KUCUNQTY();
executeSQL = string.Format(update4KCQTY, tableName, startDate, endDateCondition, material, billno, qichu);
DBUtils.Execute(this.Context, executeSQL);
}
}
}
private Dictionary <string, object> GetFilterKeyValue(string fldKey, int rowIndex, string formId)
{
// 使用行索引，到报表数据源中自行获取行
// 报表显示的数据源
DataTable dt = ((ISysReportModel)this.View.Model).DataSource;
if (dt.Rows.Count == 0 || rowIndex >= dt.Rows.Count)
{
return(null);
}
DataRow currRow = dt.Rows[rowIndex];
string fmaterial = Convert.ToString(currRow["FMaterialId"]);
conditionEntry conditionEntry = null;
if (formId.Equals(inStockDetail))
{
string condition = Convert.ToString(currRow["condition"]);
decimal qichu = Convert.ToDecimal(currRow["CHUQIKUCUN"]);
conditionEntry = new conditionEntry();
conditionEntry.material = fmaterial;
conditionEntry.startDate = condition.Substring(0, 10);
conditionEntry.endDate = condition.Substring(11, 10);
conditionEntry.qichu = qichu;
conditionEntry.cangku = "CK002";
}
string ckname = Convert.ToString(currRow[fldKey]);
Dictionary <string, object> fmaterialMap = new Dictionary <string, object>();
fmaterialMap.Add("material", fmaterial);
fmaterialMap.Add("ckname", ckname);
fmaterialMap.Add("condition", conditionEntry);
return(fmaterialMap);
}
