public DataTable ReportDesigner_I(ToolsBase ToolsBase)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@ReportName", ToolsBase.ReportName),
new MyParameter("@ReportRole", ToolsBase.Role),
new MyParameter("@ReportLayout", ToolsBase.ReportLayout),
new MyParameter("@ReportSql", ToolsBase.ExecuteSql),
new MyParameter("@ReportID", ToolsBase.ReportID),
new MyParameter("@WholeLayout", ToolsBase.WholeLayout)
};
Common.Set_Procedures("ReportDesigner_I");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public ActionResult LoadTableColumnsTreeNode_ReportDesign(ToolsBase ToolsBase)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = toolsDL.LoadTableColumnsTreeNode_ReportDesign(ToolsBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public ActionResult ReportDesigner_I(ToolsBase ToolsBase)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = toolsDL.ReportDesigner_I(ToolsBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public DataTable LoadDataTablesTree_ReportDesign(ToolsBase ToolsBase)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@GroupName", ToolsBase.GroupName)
};
Common.Set_Procedures("LoadDataTablesTree_ReportDesign");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public DataTable ReportSQL_Load(ToolsBase ToolsBase)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@ReportID", ToolsBase.ReportID)
};
Common.Set_Procedures("ReportSQL_Load");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public DataTable ExecuteReport_Sql(ToolsBase ToolsBase)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@datacolumn", ToolsBase.ExecuteSql)
};
Common.Set_Procedures("ExecuteReport_Sql");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
