Ejemplo n.º 1
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmsp_RSOBRAZACSelect2 = this.connDefault.GetCommand("S_RSM_OBRAZAC", true);
            this.cmsp_RSOBRAZACSelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmsp_RSOBRAZACSelect2.IDbCommand.Parameters.Clear();
            this.cmsp_RSOBRAZACSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOBRACUN", this.AV8IDOBRAC));
            this.cmsp_RSOBRAZACSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@dd", this.AV9dd));
            this.cmsp_RSOBRAZACSelect2.ErrorMask |= ErrorMask.Lock;
            this.sp_RSOBRAZACSelect2              = this.cmsp_RSOBRAZACSelect2.FetchData();
            while (this.cmsp_RSOBRAZACSelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmsp_RSOBRAZACSelect2.HasMoreRows = this.sp_RSOBRAZACSelect2.Read();
            }
            int num = 0;

            while (this.cmsp_RSOBRAZACSelect2.HasMoreRows && (num != maxRows))
            {
                this.rowsp_RSOBRAZAC["REDNIBROJ"]      = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["REDNIBROJ"]);
                this.rowsp_RSOBRAZAC["IDRADNIK"]       = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IDRADNIK"]);
                this.rowsp_RSOBRAZAC["PREZIMEIIME"]    = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["PREZIMEIIME"]);
                this.rowsp_RSOBRAZAC["MBGOSIGURANIKA"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["MBGOSIGURANIKA"]);
                this.rowsp_RSOBRAZAC["SIFRAGRADARADA"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["SIFRAGRADARADA"]);
                this.rowsp_RSOBRAZAC["OO"]             = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["OO"]);
                this.rowsp_RSOBRAZAC["B"]   = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["B"]);
                this.rowsp_RSOBRAZAC["OD"]  = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["OD"]);
                this.rowsp_RSOBRAZAC["DOO"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["DOO"]);
                this.rowsp_RSOBRAZAC["IZNOSOBRACUNANEPLACERSMB"]     = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IZNOSOBRACUNANEPLACERSMB"]);
                this.rowsp_RSOBRAZAC["IZNOSOSNOVICEZADOPRINOSERSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IZNOSOSNOVICEZADOPRINOSERSMB"]);
                this.rowsp_RSOBRAZAC["IDDOPRINOSMIO1"]          = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IDDOPRINOSMIO1"]);
                this.rowsp_RSOBRAZAC["STOPAMIO1"]               = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["STOPAMIO1"]);
                this.rowsp_RSOBRAZAC["MIO1RSMB"]                = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["MIO1RSMB"]);
                this.rowsp_RSOBRAZAC["IDDOPRINOSMIO2"]          = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IDDOPRINOSMIO2"]);
                this.rowsp_RSOBRAZAC["STOPAMIO2"]               = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["STOPAMIO2"]);
                this.rowsp_RSOBRAZAC["MIO2RSMB"]                = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["MIO2RSMB"]);
                this.rowsp_RSOBRAZAC["POREZIPRIREZ"]            = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["POREZIPRIREZ"]);
                this.rowsp_RSOBRAZAC["IZNOSISPLACENEPLACERSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IZNOSISPLACENEPLACERSMB"]);
                this.rowsp_RSOBRAZAC["OIB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["OIB"]);
                this.AddRowSp_rsobrazac();
                num++;
                this.rowsp_RSOBRAZAC = this.sp_RSOBRAZACSet.sp_RSOBRAZAC.Newsp_RSOBRAZACRow();
                this.cmsp_RSOBRAZACSelect2.HasMoreRows = this.sp_RSOBRAZACSelect2.Read();
            }
            this.sp_RSOBRAZACSelect2.Close();
            this.Cleanup();
        }
Ejemplo n.º 2
0
 public virtual int FillPage(sp_RSOBRAZACDataSet dataSet, string iDOBRACUN, short dd, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault     = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.sp_RSOBRAZACSet = dataSet;
     this.rowsp_RSOBRAZAC = this.sp_RSOBRAZACSet.sp_RSOBRAZAC.Newsp_RSOBRAZACRow();
     this.SetFillParameters(iDOBRACUN, dd);
     this.AV8IDOBRAC = iDOBRACUN;
     this.AV9dd      = dd;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }