示例#1
0
 public virtual int FillPage(S_OS_BILANCA_STANJA_NA_DANDataSet dataSet, DateTime dATUM, string sORT, short vrsta, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.S_OS_BILANCA_STANJA_NA_DANSet = dataSet;
     this.rowS_OS_BILANCA_STANJA_NA_DAN = this.S_OS_BILANCA_STANJA_NA_DANSet.S_OS_BILANCA_STANJA_NA_DAN.NewS_OS_BILANCA_STANJA_NA_DANRow();
     this.SetFillParameters(dATUM, sORT, vrsta);
     this.AV8DATUM  = DateTimeUtil.ResetTime(dATUM);
     this.AV9SORT   = sORT;
     this.AV10vrsta = vrsta;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }
示例#2
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2 = this.connDefault.GetCommand("S_OS_BILANCA_STANJA_NA_DAN", true);
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Clear();
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DATUM", this.AV8DATUM));
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@SORT", this.AV9SORT));
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vrsta", this.AV10vrsta));
            this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.ErrorMask |= ErrorMask.Lock;
            this.S_OS_BILANCA_STANJA_NA_DANSelect2              = this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.FetchData();
            while (this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows = this.S_OS_BILANCA_STANJA_NA_DANSelect2.Read();
            }
            int num = 0;

            while (this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows && (num != maxRows))
            {
                this.rowS_OS_BILANCA_STANJA_NA_DAN["NAZIVOS"]            = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["NAZIVOS"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["INVBROJ"]            = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["INVBROJ"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["KOLICINA"]           = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KOLICINA"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["NABAVNA"]            = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["NABAVNA"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["ISPRAVAK"]           = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["ISPRAVAK"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["SADASNJA"]           = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["SADASNJA"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["KTOISPRAVKAIDKONTO"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KTOISPRAVKAIDKONTO"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["KTONABAVKEIDKONTO"]  = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KTONABAVKEIDKONTO"]);
                this.rowS_OS_BILANCA_STANJA_NA_DAN["KTOIZVORAIDKONTO"]   = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KTOIZVORAIDKONTO"]);
                this.AddRowS_os_bilanca_stanja_na_dan();
                num++;
                this.rowS_OS_BILANCA_STANJA_NA_DAN = this.S_OS_BILANCA_STANJA_NA_DANSet.S_OS_BILANCA_STANJA_NA_DAN.NewS_OS_BILANCA_STANJA_NA_DANRow();
                this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows = this.S_OS_BILANCA_STANJA_NA_DANSelect2.Read();
            }
            this.S_OS_BILANCA_STANJA_NA_DANSelect2.Close();
            this.Cleanup();
        }