/// <summary>
/// 获取数据源
/// </summary>
/// <param name="entity"></param>
/// <param name="list"></param>
/// <returns></returns>
public DataSet GetDataSource(ReportsEntity entity, List <ReportParamsEntity> list)
{
DataCommand command = null;
DataSet ds = null;
if (entity.DsType == (int)EDataSourceType.SQL)
{
command = DataCommandManager.CreateCustomDataCommand("GitWMS", CommandType.Text, entity.DataSource);
}
else
{
command = DataCommandManager.CreateCustomDataCommand("GitWMS", CommandType.StoredProcedure, entity.DataSource);
}
if (list != null)
{
foreach (ReportParamsEntity item in list)
{
DbType dbType = DbType.String;
if (item.ParamType == "datetime" || item.ParamType == "date")
{
dbType = DbType.DateTime;
item.DefaultValue = string.IsNullOrEmpty(item.DefaultValue) ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : item.DefaultValue;
}
else if (item.ParamType == "int")
{
dbType = DbType.Int32;
item.DefaultValue = string.IsNullOrEmpty(item.DefaultValue) ? "0" : item.DefaultValue;
}
else
{
item.DefaultValue = string.IsNullOrEmpty(item.DefaultValue) ? "" : item.DefaultValue;
}
command.AddParameterValue(item.ParamName, item.DefaultValue, dbType);
}
}
ds = command.ExecuteDataSet();
return(ds);
}