Ejemplo n.º 1
0
 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);
 }
Ejemplo n.º 2
0
 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);
 }
Ejemplo n.º 3
0
 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);
 }
Ejemplo n.º 4
0
 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);
 }
Ejemplo n.º 5
0
 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);
 }
Ejemplo n.º 6
0
 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);
 }