Beispiel #1
0
 public DataSet GetDatas(bool limited, params string[] parameters)
 {
     this.paramsForReport = new string[parameters.Length];
     this.i = 0;
     this.k = 0;
     for (; this.i < this.sqls.Length; ++this.i)
     {
         if (this.sqls[this.i].IndexOf("@") != -1)
         {
             string[] strArray = this.sqls[this.i].Split("@".ToCharArray());
             string   str      = "";
             if (parameters.Length == strArray.Length - 1)
             {
                 for (this.j = 0; this.j < strArray.Length - 1; ++this.j)
                 {
                     str = string.Join(parameters[this.j], strArray, this.j, 2);
                     strArray[this.j + 1] = str;
                 }
             }
             else
             {
                 this.infoMsg += "Error: el nmero de parmetros no coincide<br>";
             }
             this.sqls[this.i] = str;
         }
     }
     this.i = 0;
     this.k = 0;
     for (; this.i < this.sqls.Length; ++this.i)
     {
         DatasForReport datasForReport = this;
         string         str            = datasForReport.infoMsg + this.sqls[this.i] + "<br>";
         datasForReport.infoMsg = str;
     }
     this.ds = new DataSet();
     this.i  = 0;
     this.k  = 0;
     for (; this.i < this.sqls.Length; ++this.i)
     {
         this.ds = limited ? DBFunctions.Request(this.ds, IncludeSchema.NO, this.sqls[this.i] + " FETCH FIRST " + this.limitedSelection.ToString() + " ROWS ONLY") : DBFunctions.Request(this.ds, IncludeSchema.NO, this.sqls[this.i]);
     }
     this.infoMsg += DBFunctions.exceptions;
     return(this.ds);
 }