//
public void LoadFilterTable(DataColumnCollection dcCollection)
{
filterSetList = new CustomList <FilterSets>();
FilterSets newFilter;
RDLColumn rc;
foreach (RDLParameter rp in Parameters)
{
newFilter = new FilterSets();
string[] items = rp.Name.Split('_');
if (items.Length == 2)
{
newFilter.ColumnName = items[0];
newFilter.Caption = "*";
}
else
{
newFilter.ColumnName = rp.Name;
}
newFilter.DataType = rp.DbType.ToString();
newFilter.TableName = "Parameter";
newFilter.OrAnd = "And";
newFilter.Operators = "=";
//newFilter.Caption = "***";
newFilter.IsParameter = true;
filterSetList.Add(newFilter);
}
foreach (DataColumn dc in dcCollection)
{
rc = Fields.Find(item => item.Name == dc.ColumnName);
if (rc.IsNotNull())
{
if (filterSetList.Find(item => item.ColumnName == dc.ColumnName && (item.TableName == "Parameter" || item.TableName == rc.TableName)).IsNull())
{
newFilter = new FilterSets();
newFilter.ColumnName = rc.Name;
newFilter.DataType = rc.DataType;
newFilter.TableName = rc.TableName;
newFilter.OrAnd = "And";
newFilter.Operators = "=";
newFilter.IsParameter = false;
filterSetList.Add(newFilter);
}
}
}
//foreach (String tableName in BodyTablesName)
//{
// //Expression
// newFilter = new FilterSets();
// newFilter.ColumnName = "Expression";
// newFilter.DataType = "Expression";
// newFilter.TableName = tableName;
// newFilter.OrAnd = "And";
// newFilter.Operators = "=";
// newFilter.IsParameter = false;
// filterSetList.Add(newFilter);
//}
}
public void LoadSourceDataSet(ref string checkedRequiredField, string supervisorKey)
{
DataSet dsTemp = new DataSet();
dsSource = new DataSet();
foreach (RDLTable rtTable in dsreport.Tables)
{
string search = "";
if (supervisorKey.IsNotNullOrEmpty())
{
search += "@Supervisor='" + supervisorKey + "',";
}
foreach (RDLParameter param in rtTable.Parameters)
{
FilterSets fSL = new FilterSets();
string[] items = param.Prompt.Split('_');
if (items.Length == 2)
{
fSL = filterSetList.Find(item => item.IsParameter && item.ColumnName == items[0]);
}
else
{
fSL = filterSetList.Find(item => item.IsParameter && item.ColumnName == param.Prompt);
}
//FilterSets fSL = filterSetList.Find(item => item.IsParameter);
if (fSL.ColumnActualValue != "")
{
search += "@" + param.Prompt + "='" + fSL.ColumnActualValue + "',";
}
if (fSL.ColumnActualValue == "" && fSL.ColumnValue != "")
{
search += "@" + param.Prompt + "='" + fSL.ColumnValue + "',";
}
if ((items.Length == 2 && fSL.ColumnActualValue == "") && (items.Length == 2 && fSL.ColumnValue == ""))
{
checkedRequiredField = items[0] + " is required.";
return;
}
//if (items.Length == 2 && fSL.ColumnActualValue == "" && fSL.ColumnValue=="")
//{
// checkedRequiredField = items[0] + " is required.";
// return;
//}
}
if (search != "")
{
search = search.Length > 0 ? search.Substring(0, search.Length - 1) : string.Empty;
}
String sql = "EXEC " + rtTable.CommandText + " " + search + "";
LoadReportSourceDataSet(ref dsTemp, sql);
dsTemp.Tables[0].TableName = rtTable.TableName;
dsSource.Tables.Add(dsTemp.Tables[rtTable.TableName].Copy());
}
}
private void SetValue(RDLParameter param, FilterSets value)
{
try
{
param.DbType = (DbType)StaticInfo.GetEnumValue(typeof(DbType), value.DataType);
switch (param.DbType)
{
case DbType.DateTime:
CultureInfo provider = CultureInfo.InvariantCulture;
if (value.ColumnValue == "")
{
param.Value = String.Empty;
break;
}
param.Value = DateTime.ParseExact(value.ColumnValue, StaticInfo.GridDateFormat, provider).ToString(StaticInfo.DateFormat);
break;
case DbType.Int16:
param.Value = Convert.ToInt16(value.ColumnValue);
break;
case DbType.Int32:
param.Value = Convert.ToInt32(value.ColumnValue);
break;
case DbType.Int64:
param.Value = Convert.ToInt64(value.ColumnValue);
break;
case DbType.Double:
param.Value = Convert.ToDouble(value.ColumnValue);
break;
case DbType.Decimal:
param.Value = Convert.ToDecimal(value.ColumnValue);
break;
case DbType.Boolean:
param.Value = Convert.ToBoolean(value.ColumnValue);
break;
default:
param.Value = value.ColumnValue;
break;
}
}
catch (Exception ex)
{
throw (ex);
}
}
private void SetValue(RDLParameter param, FilterSets value)
{
try
{
param.DbType = (DbType)StaticInfo.GetEnumValue(typeof(DbType), value.DataType);
switch (param.DbType)
{
case DbType.DateTime:
CultureInfo provider = CultureInfo.InvariantCulture;
if (value.ColumnValue == "")
{
param.Value = String.Empty;
break;
}
param.Value = DateTime.ParseExact(value.ColumnValue, StaticInfo.GridDateFormat, provider).ToString(StaticInfo.DateFormat);
break;
case DbType.Int16:
param.Value = Convert.ToInt16(value.ColumnValue);
break;
case DbType.Int32:
param.Value = Convert.ToInt32(value.ColumnValue);
break;
case DbType.Int64:
param.Value = Convert.ToInt64(value.ColumnValue);
break;
case DbType.Double:
param.Value = Convert.ToDouble(value.ColumnValue);
break;
case DbType.Decimal:
param.Value = Convert.ToDecimal(value.ColumnValue);
break;
case DbType.Boolean:
param.Value = Convert.ToBoolean(value.ColumnValue);
break;
default:
param.Value = value.ColumnValue;
break;
}
}
catch (Exception ex)
{
throw (ex);
}
}
public void LoadSourceDataSet(ref string checkedRequiredField,string supervisorKey)
{
DataSet dsTemp = new DataSet();
dsSource = new DataSet();
foreach (RDLTable rtTable in dsreport.Tables)
{
string search = "";
if (supervisorKey.IsNotNullOrEmpty())
search += "@Supervisor='" +supervisorKey + "',";
foreach (RDLParameter param in rtTable.Parameters)
{
FilterSets fSL = new FilterSets();
string[] items = param.Prompt.Split('_');
if (items.Length == 2)
fSL = filterSetList.Find(item => item.IsParameter && item.ColumnName == items[0]);
else
fSL = filterSetList.Find(item => item.IsParameter && item.ColumnName == param.Prompt);
//FilterSets fSL = filterSetList.Find(item => item.IsParameter);
if (fSL.ColumnActualValue != "")
search += "@" + param.Prompt + "='" + fSL.ColumnActualValue + "',";
if (fSL.ColumnActualValue == "" && fSL.ColumnValue != "")
search += "@" + param.Prompt + "='" + fSL.ColumnValue + "',";
if ((items.Length == 2 && fSL.ColumnActualValue == "") && (items.Length == 2 && fSL.ColumnValue == ""))
{
checkedRequiredField = items[0] + " is required.";
return;
}
//if (items.Length == 2 && fSL.ColumnActualValue == "" && fSL.ColumnValue=="")
//{
// checkedRequiredField = items[0] + " is required.";
// return;
//}
}
if (search != "")
search = search.Length > 0 ? search.Substring(0, search.Length - 1) : string.Empty;
String sql = "EXEC " + rtTable.CommandText + " " + search + "";
LoadReportSourceDataSet(ref dsTemp, sql);
dsTemp.Tables[0].TableName = rtTable.TableName;
dsSource.Tables.Add(dsTemp.Tables[rtTable.TableName].Copy());
}
}
//
public void LoadFilterTable(DataColumnCollection dcCollection)
{
filterSetList = new CustomList<FilterSets>();
FilterSets newFilter;
RDLColumn rc;
foreach (RDLParameter rp in Parameters)
{
newFilter = new FilterSets();
string[] items = rp.Name.Split('_');
if (items.Length == 2)
{
newFilter.ColumnName = items[0];
newFilter.Caption = "*";
}
else
{
newFilter.ColumnName = rp.Name;
}
newFilter.DataType = rp.DbType.ToString();
newFilter.TableName = "Parameter";
newFilter.OrAnd = "And";
newFilter.Operators = "=";
//newFilter.Caption = "***";
newFilter.IsParameter = true;
filterSetList.Add(newFilter);
}
foreach (DataColumn dc in dcCollection)
{
rc = Fields.Find(item => item.Name == dc.ColumnName);
if (rc.IsNotNull())
{
if (filterSetList.Find(item => item.ColumnName == dc.ColumnName && (item.TableName == "Parameter" || item.TableName == rc.TableName)).IsNull())
{
newFilter = new FilterSets();
newFilter.ColumnName = rc.Name;
newFilter.DataType = rc.DataType;
newFilter.TableName = rc.TableName;
newFilter.OrAnd = "And";
newFilter.Operators = "=";
newFilter.IsParameter = false;
filterSetList.Add(newFilter);
}
}
}
//foreach (String tableName in BodyTablesName)
//{
// //Expression
// newFilter = new FilterSets();
// newFilter.ColumnName = "Expression";
// newFilter.DataType = "Expression";
// newFilter.TableName = tableName;
// newFilter.OrAnd = "And";
// newFilter.Operators = "=";
// newFilter.IsParameter = false;
// filterSetList.Add(newFilter);
//}
}
