Пример #1
1
        //-----------------------------------

        public List<Cliente> BuscarClienteD(String apellido, String nombre, String mail, Decimal documento)
        {
            var query = String.Format(@"Select * FROM LA_REVANCHA.CLIENTE WHERE 1 = 1 ");

            if (apellido != "")
            {
                query = query + "AND CLI_APELLIDO = '" + apellido + "' ";
            }
            if (nombre != "")
            {
                query = query + "AND CLI_NOMBRE = '" + nombre + "' ";
            }
            if (documento != 0)
            {
                query = query + "AND CLI_NUMERO_IDENTIFICACION = " + documento;
            }
            if (mail != "")
            {
                query = query + "AND CLI_MAIL = '" + mail + "' ";
            }

            DataRowCollection dataRow = SQLUtils.EjecutarConsultaSimple(query, "LA_REVANCHA.CLIENTE");

                var clientes = dataRow.ToList<Cliente>(this.DataRowToCliente);
                return clientes;
            
        }
Пример #2
0
        public static int Main(String[] args)
        {
            Decimal cy1;
            Decimal cy2;
            Decimal dm3;
            //

            dm3 = new Decimal(-2.34);

            cy1 = new Decimal(2.34);
            cy2 = -dm3;

            Console.WriteLine("cy1 ,cy2 ,dm3: " + cy1 + " ," + cy2 + " ," + dm3);

            if (cy1 != cy2)
            {
                Console.WriteLine("FAIL! (72c)");
                return 1;
            }
            else
            {
                Console.WriteLine("Good. (73g)");
                return 100;
            }
        }
Пример #3
0
        private List<ChangeClass> makeChange(Decimal change,List<CurrencyClass> currencyList)
        {
            List<ChangeClass> results = new List<ChangeClass>();

            foreach (CurrencyClass currency in currencyList)
            {
                //since the list is sorted, we can just start at the top and work down

                int units = 0;
                if (currency.Value > change)
                {
                    continue; //nothing to do for this amount
                }
                else
                {
                    //do the math as integers to capture the whole numbers
                    int changeInt = Convert.ToInt32(Decimal.Round(change*100));
                    int valueInt = Convert.ToInt32(Decimal.Round(currency.Value*100));
                    units = changeInt / valueInt;
                    results.Add(new ChangeClass(units,currency));
                    change = change - units * currency.Value;
                }
            }

            return results;
        }
Пример #4
0
        public static string FormatSeconds(long seconds)
        {
            Decimal time = new Decimal(seconds);

            string suffix;
            if (time > OneDay)
            {
                time /= OneDay;
                suffix = " days";
            }
            else if (time > OneHour)
            {
                time /= OneHour;
                suffix = " hours";
            }
            else if (time > OneMinute)
            {
                time /= OneMinute;
                suffix = " minutes";
            }
            else
            {
                suffix = " seconds";
            }

            return String.Format("{0}{1}", Math.Round(time), suffix);
        }
Пример #5
0
 public static double KmPerDegreeAtLatitude(Decimal latitude)
 {
     double cos = Math.Cos(Convert.ToDouble(latitude) * Math.PI / 180.0);
     //double kmPerDegree = RadiusAtLatitude(latitude) * Math.PI / 180;
     double retVal = KmPerDegree * cos;
     return retVal;
 }
Пример #6
0
 public virtual void AddItem(string IDOP, Decimal Cantidad)
 {
     ItemGuiaRemision Item = new ItemGuiaRemision();
     Item.IDOrdenProduccion = IDOP;
     Item.Cantidad = Cantidad;
     Items.Add(Item);
 }
Пример #7
0
    //----------------------------------------------------------
    //	получить значение колонки для записи в А-файл
    static string  GetColValue(int ColNumber)
    {
        if (ColNumber < 0)
        {
            return("");
        }
        string Result;

        if (AModel.ColOfCsv(ColNumber) < 0)
        {
            Result = AModel[ColNumber];
        }
        else
        {
            Result = TsvFile[AModel.ColOfCsv(ColNumber)];
        }
        if ((ColNumber == CSepAFileInfo.L_PURPOSE) ||
            (ColNumber == CSepAFileInfo.L_DEBITNAME) ||
            (ColNumber == CSepAFileInfo.L_CREDITNAME)
            )
        {
            Result = Result.Trim().Replace(CAbc.BIG_UKR_I, "I").Replace(CAbc.SMALL_UKR_I, "i");
        }
        if (ColNumber == CSepAFileInfo.L_SUMA)
        {
            Result = Result.Trim().Replace(",", ".");
            money Crncy = CCommon.CCur(Result) * 100;
            long  Val   = ( long )Crncy;
            Result = CCommon.Right(Val.ToString(), CSepAFileInfo.Record_Field_Size[CSepAFileInfo.L_SUMA]);
        }
        return(Result);
    }
        public void SaveToDecimalTestCase1()
        {
            var expected = new Decimal( RandomValueEx.GetRandomInt32() );
            var actual = "InvalidValue".SaveToDecimal( expected );

            Assert.AreEqual( expected, actual );
        }
Пример #9
0
        /// <summary>
        /// Request a direct payment session
        /// </summary>
        /// <param name="credentials">PagSeguro credentials</param>
        /// <returns><c cref="T:Uol.PagSeguro.CancelRequestResponse">Result</c></returns>
        public static Installments GetInstallments(Credentials credentials, Decimal amount, String cardBrand)
        {
            PagSeguroTrace.Info(String.Format(CultureInfo.InvariantCulture, "InstallmentService.GetInstallments() - begin"));
            try
            {
                using (HttpWebResponse response = HttpURLConnectionUtil.GetHttpGetConnection(
                    BuildInstallmentURL(credentials, amount, cardBrand)))
                {
                    using (XmlReader reader = XmlReader.Create(response.GetResponseStream()))
                    {

                        Installments result = new Installments();
                        InstallmentsSerializer.Read(reader, result);
                        PagSeguroTrace.Info(String.Format(CultureInfo.InvariantCulture, "InstallmentService.Register({0}) - end", result.ToString()));
                        return result;
                    }
                }
            }
            catch (ArgumentException exception)
            {
                PagSeguroServiceException pse = new PagSeguroServiceException(exception.Message);
                PagSeguroTrace.Error(String.Format(CultureInfo.InvariantCulture, "InstallmentService.Register() - error {0}", exception.Message));
                throw pse;
            }
            catch (WebException exception)
            {
                PagSeguroServiceException pse = HttpURLConnectionUtil.CreatePagSeguroServiceException((HttpWebResponse)exception.Response);
                PagSeguroTrace.Error(String.Format(CultureInfo.InvariantCulture, "InstallmentService.Register() - error {0}", pse));
                throw pse;
            }
        }
Пример #10
0
        public Decimal GET_AMOUNT(Decimal _basic_salary)
        {
            decimal d = 0;
            MySqlCommand cmd = new MySqlCommand();
            db.SET_COMMAND_PARAMS(cmd, "BENEFIT_SELECT_AMOUNT_BYID");
            cmd.Parameters.AddWithValue("_code", code);
            cmd.Parameters.AddWithValue("_basic_salary", _basic_salary);

            DataTable dt = new DataTable();
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            da.Fill(dt);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    DataRow r = dt.Rows[0];
                    d = Convert.ToDecimal(r["amount"].ToString());
                    return d;
                }
                else
                {
                    return 0;
                }
            }
            else {
                return 0;
            }
        }
Пример #11
0
        /// <summary>
        ///     Gets the specified percentage of the number.
        /// </summary>
        /// <param name="number">The number.</param>
        /// <param name="percent">The percent.</param>
        /// <returns>Returns the specified percentage of the number</returns>
        public static Decimal PercentageOf( this Int64 number, Decimal percent )
        {
            if ( number <= 0 )
                throw new DivideByZeroException( "The number must be greater than zero." );

            return number * percent / 100;
        }
Пример #12
0
 public AccountDTO(Int32 accountID, Decimal balance, CurrencyType currency, Int32 client_ClientID)
 {
     this.AccountID = accountID;
     this.Balance = balance;
     this.Currency = currency;
     this.Client_ClientID = client_ClientID;
 }
        public void BajarCliente(Decimal codigo, int habilitado)
        {
            var query = String.Format(@"UPDATE NINIRODIE.USUARIO SET USU_HABILITADO = " +
                "'{0}' WHERE USU_CODIGO = '{1}'", habilitado, codigo);

            SQLUtils.EjecutarConsultaConEfectoDeLado(query);
        }
        public void BajarEmpresa(Decimal codigo, bool habilitado)
        {
            var query = String.Format(@"UPDATE NINIRODIE.USUARIO SET USU_HABILITADO = " +
                "'{0}' WHERE USU_EMPRESA_ID = '{1}'", habilitado, codigo);

            SQLUtils.EjecutarConsultaConEfectoDeLado(query);
        }
Пример #15
0
        public void ActualizarEscoit(Decimal cod_estadia, Decimal cod_consumible, Decimal cod_item)
        {
            var query = String.Format(@"UPDATE LA_REVANCHA.ESTADIA_CONSUMIBLE_ITEM SET ESCOIT_COD_ITEM = '{0}' WHERE ESCOIT_COD_ESTADIA = '{1}' AND ESCOIT_COD_CONSUMIBLE = '{2}'",
                cod_item, cod_estadia, cod_consumible);

            SQLUtils.EjecutarConsultaConEfectoDeLado(query);
        }
Пример #16
0
        private static int[] TimeUnitsValue = { 1000, 60, 60, 24, 30, 12, 10, 10 }; // Reference unit is millis

        #endregion Fields

        #region Methods

        public static String FormatBytes(long bytes, int precision)
        {
            Decimal size = new Decimal(bytes);

            string suffix;
            if (size > OneGigaByte)
            {
                size /= OneGigaByte;
                suffix = "GB";
            }
            else if (size > OneMegaByte)
            {
                size /= OneMegaByte;
                suffix = "MB";
            }
            else if (size > OneKiloByte)
            {
                size /= OneKiloByte;
                suffix = "kB";
            }
            else
            {
                suffix = "B";
            }

            return String.Format("{0}{1}", Math.Round(size, precision), suffix);
        }
Пример #17
0
        public static List<Decimal> GetIncrements(Decimal lowerBound, Decimal upperBound)
        {
            if (lowerBound >= upperBound)
            {
                return null;
            }
            Decimal range = upperBound - lowerBound;

            int magnitude = (int)Math.Floor(Math.Log10((double)range));
            if (range < 1)
            {
                magnitude++;
            }
            Decimal step = (Decimal)Math.Pow(10, magnitude) / 10;

            Decimal value = (step * (Decimal)Math.Floor((double)(lowerBound / step)));
            if (value < lowerBound)
            {
                value += step;
            }
            List<Decimal> returnList = new List<Decimal>();
            while (value < upperBound + step)
            {
                returnList.Add((Decimal)Math.Round((double)value, 2));
                value += step;
            }
            return returnList;
        }
Пример #18
0
 public WalkingData(Decimal probability, int steps, int x, int y)
 {
     this.Probability = probability;
     this.Steps = steps;
     this.X = x;
     this.Y = y;
 }
        public void SaveToDecimalTestCase3()
        {
            var expected = new Decimal( RandomValueEx.GetRandomInt32() );
            var actual = "InvalidValue".SaveToDecimal( NumberStyles.Any, CultureInfo.InvariantCulture, expected );

            Assert.AreEqual( expected, actual );
        }
Пример #20
0
 public Y_030(String txid, String connectionString, String ac1, String ac2, Decimal amount, String loginAc)
 {
     try
     {
         //this.error = "N";
         dberr = new Data.Dber();
         this.TXID = txid;
         // seq will generate and store transaction reference no.
         seq = new Sequence(TXID);
         this.changeAmount = amount;
         //processTransaction(connectionString, ac1, ac2, amount);
         /*if (!ac1.Equals(loginAc))
         {
             newInitiator = true;
         }*/
         if (processTransaction(connectionString, ac1, ac2, amount, loginAc) != 0)
         {
             this.error = true;
         }
     }
     catch(Exception e)
     {
         this.result = e.ToString();
         this.error = true;
     }
 }
Пример #21
0
 public ParseTest(String str, Decimal d, NumberStyles style)
 {
     this.str = str;
     this.exceptionFlag = false;
     this.style = style;
     this.d = d;
 }
Пример #22
0
        public DataTable ObtenerInformacionParaSemaforoPrincipal(Decimal ID_EMPRESA)
        {
            Conexion conexion = new Conexion(Empresa);
            DataSet _dataSet = new DataSet();
            DataView _dataView = new DataView();
            DataTable _dataTable = new DataTable();
            String sql = null;
            Boolean ejecutar = true;

            sql = "usp_nom_empleados_obtenerSemaforoPrincipalGestionHumana ";

            sql += ID_EMPRESA.ToString();

            if (ejecutar)
            {
                try
                {
                    _dataSet = conexion.ExecuteReader(sql);
                    _dataView = _dataSet.Tables[0].DefaultView;
                    _dataTable = _dataView.Table;
                }
                catch (Exception e)
                {
                    MensajeError = e.Message;
                }
                finally
                {
                    conexion.Desconectar();
                }
            }
            return _dataTable;
        }
        public static DataTable GetAllPERIODOXSETORNOME(
          ConnectionInfo pInfo, Decimal pSET_ID
      )
        {
            string lQuery = "";
            DataTable lTable = new DataTable();

            // lQuery = PERIODOXSETORQD.qPERIODOXSETORList;
            //            lQuery += @" WHERE PERQ_STATUS='A'
            //                         AND S.SET_ID = P.SET_ID
            //                         AND S.SET_STATUS='A'
            //                         AND P.PERQ_DIAINICIO <= SYSDATE
            //                         AND P.PERQ_DATAFIM >= SYSDATE
            //                         AND S.SET_ID = " + pSET_ID;

            lQuery += @"  SELECT S.*,P.*
                          from PERIODOXSETOR P , SETOR S WHERE PERQ_STATUS='A'
                          AND S.SET_ID = P.SET_ID
                          AND S.SET_STATUS='A'
                          AND S.SET_ID = " + pSET_ID;

            SelectCommand lSelect = new SelectCommand(lQuery);
            lTable = lSelect.ReturnData(Instance.CreateDatabase(pInfo));

            return lTable;
        }
Пример #24
0
 private void edtRaiDecimal_ValueChanged(object sender, EventArgs e)
 {
     if (!mChanging)
     {
         Area = edtRaiDecimal.Value * SquareKilometerToRai;
     }
 }
Пример #25
0
 public MakersMatchRank_History()
 {
     _gmid = (0);
     _Score = (0);
     _GameTime = DateTime.Now;
     _Rank = (0);
 }
Пример #26
0
 public Tweet GetTweet(Decimal id)
 {
     Tweet tweet = (from t in _entity.Tweets
                    where t.ID == id
                    select t).FirstOrDefault();
     return tweet;
 }
Пример #27
0
 private void edtSquareKilometer_ValueChanged(object sender, EventArgs e)
 {
     if (!mChanging)
     {
         Area = edtSquareKilometer.Value;
     }
 }
Пример #28
0
 private SqlDecimal(bool isNull)
 {
     _value = Decimal.Zero;
     _isNull = isNull;
     _precision = 38;
     _scale = 0;
 }
Пример #29
0
 public void SetMPG(Decimal urban, Decimal combined, Decimal extraUrban)
 {
     if (!(urban < combined && combined < extraUrban))
     {
         throw new Exception("Invalid MPG values detected, maybe you have a Volkswagen");
     }
 }
Пример #30
0
        public Window(DockingManager manager)
        {
            // Must provide a valid manager instance
            if (manager == null)
                throw new ArgumentNullException("DockingManager");

            // Default object state
            _state = State.Floating;
            _parentZone = null;
            _zoneArea = 100m;
            _minimalSize = new Size(0,0);
            _manager = manager;
            _autoDispose = true;
            _fullTitle = "";
            _redockAllowed = true;
            _floatingCaption = true;
            _contentCaption = true;

            // Create collection of window details
            _windowDetails = new WindowDetailCollection();

            // We want notification when window details are added/removed/cleared
            _windowDetails.Clearing += new CollectionClear(OnDetailsClearing);
            _windowDetails.Inserted += new CollectionChange(OnDetailInserted);
            _windowDetails.Removing += new CollectionChange(OnDetailRemoving);
        }
Пример #31
0
    }                         //FOLD00

    void    MapAmountFields() //fold00
    {
        Amounts_Id          = __.CLng(Amounts["Id"]);
        Amounts_Tag         = Amounts["Tag"].Trim();
        Amounts_IBAN        = Amounts["IBAN"].Trim();
        Amounts_Kind        = __.CInt(Amounts["Kind"]);
        Amounts_StateCode   = Amounts["StateCode"].Trim();
        Amounts_ClientName  = __.FixUkrI(Amounts["ClientName"]);
        Amounts_UserId      = __.CInt(Amounts["UserId"]);
        Amounts_UserName    = __.FixUkrI(Amounts["UserName"]);
        Amounts_Name        = __.FixUkrI(Amounts["Name"]);
        Amounts_LastDate    = __.CInt(Amounts["LastDate"]);
        Amounts_RestDate    = __.CInt(Amounts["RestDate"]);
        Amounts_DateInto    = __.CInt(Amounts["DateInto"]);
        Amounts_MainBefore  = __.CCur(Amounts["MainBefore"]);
        Amounts_MainAfter   = __.CCur(Amounts["MainAfter"]);
        Amounts_CrncyBefore = __.CCur(Amounts["CrncyBefore"]);
        Amounts_CrncyAfter  = __.CCur(Amounts["CrncyAfter"]);
        Amounts_Pieces      = __.CInt(Amounts["Pieces"]);
        Amounts_RateBefore  = __.CCur(Amounts["RateBefore"]);
        Amounts_RateAfter   = __.CCur(Amounts["RateAfter"]);
        Amounts_DateBefore  = __.CInt(Amounts["DateBefore"]);
        Amounts_DateAfter   = __.CInt(Amounts["DateAfter"]);
        Amounts_SubRate     = __.CCur(Amounts["SubRate"]);
    }                           //FOLD00
 /// <summary>Initializes a new instance of the <see cref="SalesOrderHeader"/> class.</summary>
 public SalesOrderHeader() : base()
 {
     _salesOrderId = default(System.Int32);
     _salesOrderNumber = default(System.String);
     _totalDue = default(System.Decimal);
     OnCreated();
 }
Пример #33
0
    }                      //FOLD00

    void    PrintAccount() //FOLD00
    {
        bool NeedTotals = true;

        if (Amounts.Open(GetCmdText(2)))
        {
            if (Amounts.Read())
            {
                do
                {
                    TotalMain    = 0;
                    TotalMainDeb = 0;
                    TotalMainCre = 0;
                    TotalCur     = 0;
                    TotalCurDeb  = 0;
                    TotalCurCre  = 0;
                    TotalEqDeb   = 0;
                    TotalEqCre   = 0;
                    IsCorrect    = false;
                    NeedTotals   = false;
                    MapAmountFields();
                    PrintHead();
                    if (Accounts_RootId != 0)                                                   // Если счет валютный
                    {
                        if (Transfers.Open(GetCmdText(3)))                                      // тогда выводим переоценку
                        {
                            if (Transfers.Read())
                            {
                                do
                                {
                                    MapTransferFields();
                                    PrintOverVal();
                                    NeedTotals = true;
                                } while (Transfers.Read());
                                o("-------------------------------------------------- ----------------- ----------------- ----------------- -----------------", CRLF);
                                o("Проводок", __.StrI(TotalMain, 6), __.Replicate(OneSpace, 37), EmptyM, OneSpace, EmptyM, OneSpace, StrM(TotalMainDeb), OneSpace, StrM(TotalMainCre), CRLF, CRLF);
                            }
                        }
                    }
                    if (Transfers.Open(GetCmdText(4)))
                    {
                        if (Transfers.Read())
                        {
                            do
                            {
                                MapTransferFields();
                                PrintTransfer();
                                NeedTotals = true;
                            } while (Transfers.Read());
                        }
                    }
                    if (NeedTotals || AllAmounts)
                    {
                        PrintTotals();
                    }
                } while (Amounts.Read());
            }
        }
    }                             //FOLD00
Пример #34
0
    }                     //FOLD00

    string  StrM(money M) //fold00
    {
        if (CoolSum)
        {
            return(__.StrM(M, 17));
        }
        else
        {
            return(__.StrN(M, 17));
        }
    }                     //FOLD00
    }    //FOLD00

    //  Подготовка столбцов к обработке
    void            PrepareFields()      //fold00
    {
        for (int I = 0; I < TOTAL_FIELDS; I++)
        {
            if (FieldFromFile[I] > 0)
            {
                FieldValues[I] = Reader[FieldFromFile[I]];
            }
        }
        money Suma = __.CCur(FieldValues[FLD_SUMA].Trim().Replace(" ", CAbc.EMPTY)) * 100;

        FieldValues[FLD_SUMA]       = __.CLng(__.Trunc(Suma)).ToString();
        FieldValues[FLD_CODE]       = (__.CInt("0" + FieldValues[FLD_CODE].Trim()) + 1).ToString();
        FieldValues[FLD_PURPOSE]    = __.FixUkrI(FieldValues[FLD_PURPOSE]);
        FieldValues[FLD_DEBITNAME]  = __.FixUkrI(FieldValues[FLD_DEBITNAME]);
        FieldValues[FLD_CREDITNAME] = __.FixUkrI(FieldValues[FLD_CREDITNAME]);
    }    //FOLD00
Пример #36
0
    }                      //FOLD00

    void    PrintOverVal() //fold00
    {
        TotalMain++;
        if (Transfers_IsCorrect == 1)
        {
            if (!IsCorrect)
            {
                IsCorrect = true;
                o(__.Replicate("-", 124), CRLF
                  , "                                             Коригуючi проводки"
                  , CRLF, __.Replicate("-", 124), CRLF
                  );
            }
        }
        if (Transfers_Side == 1)
        {
            TotalMainDeb += Transfers_MainAmount;
            o(__.StrD(Transfers_DayDate, 8, 8), OneSpace
              , __.Left(Transfers_DocCode, 8), OneSpace
              , __.Left(Transfers_BankCode, 6), OneSpace
              , __.Left(Transfers_Code, 14), OneSpace
              , __.Left(Transfers_StateCode, 10), OneSpace
              , EmptyM, OneSpace
              , EmptyM, OneSpace
              , StrM(Transfers_MainAmount), OneSpace
              , EmptyM, CRLF
              );
        }
        else
        {
            TotalMainCre += Transfers_MainAmount;
            o(__.StrD(Transfers_DayDate, 8, 8), OneSpace
              , __.Left(Transfers_DocCode, 8), OneSpace
              , __.Left(Transfers_BankCode, 6), OneSpace
              , __.Left(Transfers_Code, 14), OneSpace
              , __.Left(Transfers_StateCode, 10), OneSpace
              , EmptyM, OneSpace
              , EmptyM, OneSpace
              , EmptyM, OneSpace
              , StrM(Transfers_MainAmount), CRLF
              );
        }
        PrintPurpose(false);
    }                       //FOLD00
Пример #37
0
    }                           //FOLD00

    void    MapTransferFields() //fold00
    {
        Transfers_Id          = __.CLng(Transfers["Id"]);
        Transfers_Side        = __.CInt(Transfers["Side"]);
        Transfers_DayDate     = __.CInt(Transfers["DayDate"]);
        Transfers_ActionId    = __.CLng(Transfers["ActionId"]);
        Transfers_OrgDate     = __.CInt(Transfers["OrgDate"]);
        Transfers_DocCode     = Transfers["DocCode"].Trim();
        Transfers_Ctrls       = Transfers["Ctrls"].Trim();
        Transfers_IBAN        = Transfers["IBAN"].Trim();
        Transfers_MainAmount  = __.CCur(Transfers["MainAmount"]);
        Transfers_CrncyAmount = __.CCur(Transfers["CrncyAmount"]);
        Transfers_CurrencyTag = Transfers["CurrencyTag"].Trim();
        Transfers_BankCode    = Transfers["BankCode"].Trim();
        Transfers_BankName    = __.FixUkrI(Transfers["BankName"]);
        Transfers_Code        = __.GetMonikerByCode(Transfers["Code"]);
        Transfers_Name        = __.FixUkrI(Transfers["Name"]);
        Transfers_Purpose     = __.FixUkrI(Transfers["Purpose"]);
        Transfers_StateCode   = Transfers["StateCode"].Trim();
        Transfers_IsCorrect   = __.CInt(Transfers["IsCorrect"]);
    }                   //FOLD00
Пример #38
0
 partial void OnAverageRateChanging(System.Decimal value);
Пример #39
0
 partial void OnEndOfDayRateChanging(System.Decimal value);
 /// <summary>
 /// Marks the HMDARateSpreadPercent value as null.
 /// </summary>
 public virtual void SetHMDARateSpreadPercentNull()
 {
     _hmdaratespreadpercent        = 0;
     _hmdaratespreadpercent_isnull = true;
 }
Пример #41
0
 public ACCESO_ROLL(System.Decimal ID_ACCESO, System.Decimal ID_ROLL, System.String ACTIVO, System.Decimal IDUSUARIOCREO,
                    System.DateTime FECHACREO, System.Decimal IDUSUARIOMODIFICO, System.DateTime FECHAMODIFICO)
 {
     _ID_ACCESO         = ID_ACCESO;
     _ID_ROLL           = ID_ROLL;
     _ACTIVO            = ACTIVO;
     _IDUSUARIOCREO     = IDUSUARIOCREO;
     _FECHACREO         = FECHACREO;
     _IDUSUARIOMODIFICO = IDUSUARIOMODIFICO;
     _FECHAMODIFICO     = FECHAMODIFICO;
 }
Пример #42
0
        public static bool ACCESO_ROLLEliminarbyID_ACCESO_ROLL(System.Decimal ID_ACCESO_ROLL, System.Decimal IDUSUARIOMODIFICO, System.DateTime FECHAMODIFICO)
        {
            try
            {
                string TableName = "ACCESO_ROLL";
                string SqlText   = @"Update " + TableName + @" set 
                     IDUSUARIOMODIFICO = " + IDUSUARIOMODIFICO + @",
                     FECHAMODIFICO = convert(datetime, '" + FECHAMODIFICO.Year + "-" + FECHAMODIFICO.Month + "-" + FECHAMODIFICO.Day + " " + FECHAMODIFICO.Hour
                                   + ":" + FECHAMODIFICO.Minute + ":" + FECHAMODIFICO.Second + @"', 120),
                     ACTIVO = 'NO'
					where ID_ACCESO_ROLL = "                     + ID_ACCESO_ROLL + "";

                conexionSQL DBAdmin = new conexionSQL();
                DBAdmin.executeComando(SqlText);

                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
Пример #43
0
        }         // Data_DeleteGHSF_GHSF_PATIENTINFO

        #endregion

        #region Data_GHSF_PATIENTINFO_UpdateGHSF_GHSF_PATIENTINFO
        ///
        /// 对于UpdateGHSF_GHSF_PATIENTINFO的类的实现(数据库操作)。
        ///
        public int Data_GHSF_PATIENTINFO_UpdateGHSF_GHSF_PATIENTINFO(System.String VPATIENTID, System.DateTime DCREATEDATE, System.String VNAME, System.String PINYINMA, System.String WUBIMA, System.Decimal NSEX, System.DateTime DBIRTHDATE, System.String VBIRTHPLACE, System.String VBIRTHPLACEDETAIL, System.String VNATION, System.String VNATIONNAME, System.String VIDTYPE, System.String VIDNO, System.String VUNITINCONTRACT, System.String VUNITINCONTRACTNAME, System.String VMAILINGADDRESS, System.String VZIPID, System.String VPHONENUMBERHOME, System.String VPHONENUMBERBUSINESS, System.String VLINKMAN, System.String VRELATIONSHIP, System.String VNEXTOFKINADDR, System.String VNEXTOFKINZIPID, System.String VPHONE, System.DateTime DLASTVISITDATE, System.Decimal NVIPINDICATOR, System.String VOPERATORID, System.String VDEGREE, System.String VRACE, System.String VRELIGION, System.String VMOTHERLANGUAGE, System.String VFOREIGNLANGUAGE, System.String VVIPNO, System.String VENGLISHNAME, System.String VREMARKS, System.Decimal NCOUNTRY, System.Decimal NPROVINCES, System.Decimal NCITY, System.Decimal NSTREET, System.Decimal NPROFESSIONID, System.String NIDENTITY, System.String VPRESENTADDRESS, System.String VISITNO, System.Decimal NMARRY, System.String VORGAN, System.Decimal NDICAREAID, System.String VDIAGNOSE, System.Decimal NDISEASEID, System.Decimal NZYZEXZ, System.Decimal NZYYPXZ, System.String OLDVPATIENTID)
        {
            int  iRtn;
            bool isExistTrans = db.IsInTransaction();

            if (!isExistTrans)
            {
                db.BeginTrans();
            }
            SS_GHSF_PATIENTINFO_UpdateGHSF_GHSF_PATIENTINFO ss = new SS_GHSF_PATIENTINFO_UpdateGHSF_GHSF_PATIENTINFO();

            ss.VPATIENTID = VPATIENTID;

            ss.DCREATEDATE = DCREATEDATE;

            ss.VNAME = VNAME;

            ss.PINYINMA = PINYINMA;

            ss.WUBIMA = WUBIMA;

            ss.NSEX = NSEX;

            ss.DBIRTHDATE = DBIRTHDATE;

            ss.VBIRTHPLACE = VBIRTHPLACE;

            ss.VBIRTHPLACEDETAIL = VBIRTHPLACEDETAIL;

            ss.VNATION = VNATION;

            ss.VNATIONNAME = VNATIONNAME;

            ss.VIDTYPE = VIDTYPE;

            ss.VIDNO = VIDNO;

            ss.VUNITINCONTRACT = VUNITINCONTRACT;

            ss.VUNITINCONTRACTNAME = VUNITINCONTRACTNAME;

            ss.VMAILINGADDRESS = VMAILINGADDRESS;

            ss.VZIPID = VZIPID;

            ss.VPHONENUMBERHOME = VPHONENUMBERHOME;

            ss.VPHONENUMBERBUSINESS = VPHONENUMBERBUSINESS;

            ss.VLINKMAN = VLINKMAN;

            ss.VRELATIONSHIP = VRELATIONSHIP;

            ss.VNEXTOFKINADDR = VNEXTOFKINADDR;

            ss.VNEXTOFKINZIPID = VNEXTOFKINZIPID;

            ss.VPHONE = VPHONE;

            ss.DLASTVISITDATE = DLASTVISITDATE;

            ss.NVIPINDICATOR = NVIPINDICATOR;

            ss.VOPERATORID = VOPERATORID;

            ss.VDEGREE = VDEGREE;

            ss.VRACE = VRACE;

            ss.VRELIGION = VRELIGION;

            ss.VMOTHERLANGUAGE = VMOTHERLANGUAGE;

            ss.VFOREIGNLANGUAGE = VFOREIGNLANGUAGE;

            ss.VVIPNO = VVIPNO;

            ss.VENGLISHNAME = VENGLISHNAME;

            ss.VREMARKS = VREMARKS;

            ss.NCOUNTRY = NCOUNTRY;

            ss.NPROVINCES = NPROVINCES;

            ss.NCITY = NCITY;

            ss.NSTREET = NSTREET;

            ss.NPROFESSIONID = NPROFESSIONID;

            ss.NIDENTITY = NIDENTITY;

            ss.VPRESENTADDRESS = VPRESENTADDRESS;

            ss.VISITNO = VISITNO;

            ss.NMARRY = NMARRY;

            ss.VORGAN = VORGAN;

            ss.NDICAREAID = NDICAREAID;

            ss.VDIAGNOSE = VDIAGNOSE;

            ss.NDISEASEID = NDISEASEID;

            ss.NZYZEXZ = NZYZEXZ;

            ss.NZYYPXZ = NZYYPXZ;

            ss.OLDVPATIENTID = OLDVPATIENTID;

            try
            {
                iRtn = db.exeSql(ss);
                if (!isExistTrans)
                {
                    db.CommitTrans();
                }
            }
            catch (Exception e)
            {
                if (isExistTrans)
                {
                    db.RollbackTrans();
                }
                throw e;
            }
            return(iRtn);
        }         // Data_UpdateGHSF_GHSF_PATIENTINFO
Пример #44
0
        /// <summary>
        ///     Gets rows from the datasource based on the PK_tblFrmType index.
        /// </summary>
        /// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
        /// <param name="_id"></param>
        /// <param name="start">Row number at which to start reading.</param>
        /// <param name="pageLength">Number of rows to return.</param>
        /// <param name="count">out parameter to get total records for query.</param>
        /// <returns>Returns an instance of the <see cref="LibraryManagement.Domain.FrmType"/> class.</returns>
        /// <remarks></remarks>
        /// <exception cref="System.Exception">The command could not be executed.</exception>
        /// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception>
        /// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception>
        public override LibraryManagement.Domain.FrmType GetById(TransactionManager transactionManager, System.Decimal _id, int start, int pageLength, out int count)
        {
            SqlDatabase database       = new SqlDatabase(this._connectionString);
            DbCommand   commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.tblFrmType_GetById", _useStoredProcedure);

            database.AddInParameter(commandWrapper, "@Id", DbType.Decimal, _id);

            IDataReader     reader = null;
            TList <FrmType> tmp    = new TList <FrmType>();

            try
            {
                //Provider Data Requesting Command Event
                OnDataRequesting(new CommandEventArgs(commandWrapper, "GetById", tmp));

                if (transactionManager != null)
                {
                    reader = Utility.ExecuteReader(transactionManager, commandWrapper);
                }
                else
                {
                    reader = Utility.ExecuteReader(database, commandWrapper);
                }

                //Create collection and fill
                Fill(reader, tmp, start, pageLength);
                count = -1;
                if (reader.NextResult())
                {
                    if (reader.Read())
                    {
                        count = reader.GetInt32(0);
                    }
                }

                //Provider Data Requested Command Event
                OnDataRequested(new CommandEventArgs(commandWrapper, "GetById", tmp));
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close();
                }

                commandWrapper = null;
            }

            if (tmp.Count == 1)
            {
                return(tmp[0]);
            }
            else if (tmp.Count == 0)
            {
                return(null);
            }
            else
            {
                throw new DataException("Cannot find the unique instance of the class.");
            }

            //return rows;
        }
Пример #45
0
        public void EqualsSameTypes()
        {
            byte    b1   = 35;
            sbyte   sb2  = 35;
            decimal d4   = 35;
            double  d5   = 35;
            float   f6   = 35;
            int     i7   = 35;
            uint    u8   = 35;
            long    l9   = 35;
            short   s10  = 35;
            ushort  us11 = 35;

            System.Byte    b12  = 35;
            System.SByte   sb13 = 35;
            System.Decimal d14  = 35;
            System.Double  d15  = 35;
            System.Single  s16  = 35;
            System.Int32   i17  = 35;
            System.UInt32  ui18 = 35;
            System.Int64   i19  = 35;
            System.UInt64  ui20 = 35;
            System.Int16   i21  = 35;
            System.UInt16  i22  = 35;

            Assert.AreEqual(35, b1);
            Assert.AreEqual(35, sb2);
            Assert.AreEqual(35, d4);
            Assert.AreEqual(35, d5);
            Assert.AreEqual(35, f6);
            Assert.AreEqual(35, i7);
            Assert.AreEqual(35, u8);
            Assert.AreEqual(35, l9);
            Assert.AreEqual(35, s10);
            Assert.AreEqual(35, us11);

            Assert.AreEqual(35, b12);
            Assert.AreEqual(35, sb13);
            Assert.AreEqual(35, d14);
            Assert.AreEqual(35, d15);
            Assert.AreEqual(35, s16);
            Assert.AreEqual(35, i17);
            Assert.AreEqual(35, ui18);
            Assert.AreEqual(35, i19);
            Assert.AreEqual(35, ui20);
            Assert.AreEqual(35, i21);
            Assert.AreEqual(35, i22);

            byte?   b23  = 35;
            sbyte?  sb24 = 35;
            decimal?d25  = 35;
            double? d26  = 35;
            float?  f27  = 35;
            int?    i28  = 35;
            uint?   u29  = 35;
            long?   l30  = 35;
            short?  s31  = 35;
            ushort? us32 = 35;

            Assert.AreEqual(35, b23);
            Assert.AreEqual(35, sb24);
            Assert.AreEqual(35, d25);
            Assert.AreEqual(35, d26);
            Assert.AreEqual(35, f27);
            Assert.AreEqual(35, i28);
            Assert.AreEqual(35, u29);
            Assert.AreEqual(35, l30);
            Assert.AreEqual(35, s31);
            Assert.AreEqual(35, us32);
        }
Пример #46
0
    }                     //FOLD00

    string  StrF(money M) //fold00
    {
        return(__.Right(M.ToString().Replace(",", "."), 13));
    }                      //FOLD00
Пример #47
0
    }                       //FOLD00

    void    PrintTransfer() //fold00
    {
        if (Accounts_RootId == 0)
        {
            TotalMain++;
            if (Transfers_IsCorrect == 1)
            {
                if (!IsCorrect)
                {
                    IsCorrect = true;
                    if (DateFrom == DateInto)
                    {
                        o(__.Replicate("-", 77), CRLF
                          , "                        Коригуючi проводки"
                          , CRLF, __.Replicate("-", 77), CRLF
                          );
                    }
                    else
                    {
                        o(__.Replicate("-", 84), CRLF
                          , "                        Коригуючi проводки"
                          , CRLF, __.Replicate("-", 84), CRLF
                          );
                    }
                }
            }
            if (DateFrom != DateInto)
            {
                o(__.StrD(Transfers_DayDate, 8, 8), OneSpace);
            }
            if (Transfers_Side == 1)
            {
                TotalMainDeb += Transfers_MainAmount;
                o(__.Left(Transfers_DocCode, 8), OneSpace
                  , __.Left(Transfers_BankCode, 6), OneSpace
                  , __.Left(Transfers_Code, 14), OneSpace
                  , __.Left(Transfers_StateCode, 10), OneSpace
                  , StrM(Transfers_MainAmount), OneSpace
                  , EmptyM, CRLF
                  );
            }
            else
            {
                TotalMainCre += Transfers_MainAmount;
                o(__.Left(Transfers_DocCode, 8), OneSpace
                  , __.Left(Transfers_BankCode, 6), OneSpace
                  , __.Left(Transfers_Code, 14), OneSpace
                  , __.Left(Transfers_StateCode, 10), OneSpace
                  , EmptyM, OneSpace
                  , StrM(Transfers_MainAmount), CRLF
                  );
            }
            PrintPurpose(DateFrom == DateInto);
        }
        else
        {
            TotalCur++;
            if (Transfers_IsCorrect == 1)
            {
                if (!IsCorrect)
                {
                    IsCorrect = true;
                    o(__.Replicate("-", 124), CRLF
                      , "                                             Коригуючi проводки"
                      , CRLF, __.Replicate("-", 124), CRLF
                      );
                }
            }
            if (Transfers_Side == 1)
            {
                o(__.StrD(Transfers_DayDate, 8, 8), OneSpace
                  , __.Left(Transfers_DocCode, 8), OneSpace
                  , __.Left(Transfers_BankCode, 6), OneSpace
                  , __.Left(Transfers_Code, 14), OneSpace
                  , __.Left(Transfers_StateCode, 10), OneSpace
                  , StrM(Transfers_CrncyAmount), OneSpace
                  , EmptyM, OneSpace
                  , StrM(Transfers_MainAmount), OneSpace
                  , EmptyM, CRLF
                  );
                TotalEqDeb  += Transfers_MainAmount;
                TotalCurDeb += Transfers_CrncyAmount;
            }
            else
            {
                o(__.StrD(Transfers_DayDate, 8, 8), OneSpace
                  , __.Left(Transfers_DocCode, 8), OneSpace
                  , __.Left(Transfers_BankCode, 6), OneSpace
                  , __.Left(Transfers_Code, 14), OneSpace
                  , __.Left(Transfers_StateCode, 10), OneSpace
                  , EmptyM, OneSpace
                  , StrM(Transfers_CrncyAmount), OneSpace
                  , EmptyM, OneSpace
                  , StrM(Transfers_MainAmount), CRLF
                  );
                TotalEqCre  += Transfers_MainAmount;
                TotalCurCre += Transfers_CrncyAmount;
            }
            PrintPurpose(false);
        }
    }                     //FOLD00
Пример #48
0
    // ------------------------------------------------------
    static void    Chk_Misc(int PrevDate, int DayDate)
    {
        int   Kind        = 0;
        int   OldKind     = 0;
        money Acc1200Main = 0;
        //money		Acc1200Brc	=	0;
        money       AccVFile       = 0;
        string      BugInfo        = CAbc.EMPTY;
        string      BugName        = CAbc.EMPTY;
        CTextWriter TextWriter     = new   CTextWriter();
        CConnection Connection2    = null;
        CRecordSet  RecordSet2     = null;
        string      DELIMITER1     = "--------------------------------+--------------------------------------------" + CAbc.CRLF;
        string      DELIMITER2     = "-----------+--------------+-----------------------" + CAbc.CRLF;
        string      DELIMITER3     = "--------------------------------+-------------+------------------+------------------+-------------------------" + CAbc.CRLF;
        string      DELIMITER4     = "--------------+--------------+--------------------+--------------------+--------------------------------------" + CAbc.CRLF;
        string      DELIMITER5     = "---------------------------------------------------+------------------" + CAbc.CRLF;
        string      DELIMITER6     = "...................................................." + CAbc.CRLF;
        string      ReportFileName = ScroogeOut + "\\" + __.StrD(DayDate, 10, 10).Replace("/", "").Replace(".", "");
        string      VFileName      = __.StrD(PrevDate, 8, 8).Substring(6, 2)
                                     + __.StrD(PrevDate, 8, 8).Substring(3, 2)
                                     + __.StrD(PrevDate, 8, 8).Substring(0, 2);

        TextWriter.Create(ReportFileName + ".err", CAbc.CHARSET_DOS);
        TextWriter.Add(__.Now().ToString() + CAbc.CRLF);
        TextWriter.Close();
        // -------------------------------------------------------------
        Connection = new   CConnection(ConnectionString);
        if (!Connection.IsOpen())
        {
            __.Print("  Ошибка подключения к серверу !");
            return;
        }
        LookForSertificates();
        RecordSet         = new   CRecordSet(Connection);
        RecordSet.Timeout = 599;
        // -------------------------------------------------------------
        if (!MainBank)
        {
            goto    CHECK_MISC;
        }
        // -------------------------------------------------------------
        if (RecordSet.Open(" exec dbo.Mega_Day_Open;7 "))
        {
            if (RecordSet.Read())
            {
                VFileName = RecordSet[0].Trim() + "\\" + VFileName;
            }
        }
        VFileName += "\\$V*.G*";
        string[] VFiles = __.GetFileList(VFileName);
        string   Tmps   = CAbc.EMPTY;

        VFileName = CAbc.EMPTY;
        if (VFiles != null)
        {
            if (VFiles.Length > 0)
            {
                VFileName = VFiles[VFiles.Length - 1];
            }
        }
        if (VFileName != CAbc.EMPTY)
        {
            CVFileReader VFileReader = new   CVFileReader();
            if (VFileReader.Open(VFileName, CAbc.CHARSET_DOS))
            {
                if (VFileReader.Read())
                {
                    AccVFile = __.CCur(VFileReader.Head().Substring(264, 16)) / 100;
                }
            }
            VFileReader.Close();
        }
        // -------------------------------------------------------------
        __.Print(" Результаты проверки сводного баланса - в " + ReportFileName + ".err");
        if (RecordSet.Open(" exec  dbo.Mega_Check_Balance;2  @FromDate = " + PrevDate.ToString() + " , @ToDate = " + PrevDate.ToString()))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
                TextWriter.Add(CAbc.CRLF, CAbc.CRLF, " ОШИБКИ ПРИ ПРОВЕРКЕ СВОДНОГО БАЛАНСА " + CAbc.CRLF);
                TextWriter.Add(DELIMITER6, CAbc.CRLF);
                do
                {
                    TextWriter.Add(RecordSet[0], CAbc.CRLF);
                }while   (RecordSet.Read());
                TextWriter.Add(DELIMITER6, CAbc.CRLF, CAbc.CRLF);
                TextWriter.Close();
            }
        }
        // -------------------------------------------------------------
        __.Print(" Сверяю корсчета на ГК и БРЦ ");
        if (RecordSet.Open(" exec  Mega_Day_Close;4 " + PrevDate.ToString()))
        {
            if (RecordSet.Read())
            {
                Acc1200Main = __.CCur(RecordSet[0]);
            }
        }

        /*	Сверка корсчета с БРЦ
         * Connection2		= new	CConnection( BrcConnStr );
         * if      (  Connection.IsOpen() ) {
         *      RecordSet2	= new	CRecordSet( Connection2 );
         *      if	( RecordSet2.Open(" exec  Mega_Day_Close;4 " + PrevDate.ToString() ) )
         *              if	( RecordSet2.Read() )
         *                      Acc1200Brc	=	__.CCur( RecordSet2[0] );
         *      if	( Acc1200Brc == 0 )
         *              __.Print(" Ошибка вычитки корсчета на БРЦ ");
         *      else
         *              if	( Acc1200Brc != Acc1200Main )
         *                      CConsole.GetBoxChoice("","Неравенство корсчетов на ГК и БРЦ !","");
         *      RecordSet2.Close();
         * }
         * else
         *      __.Print("  Ошибка подключения к БРЦ !");
         * Connection2.Close();
         */
        TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
        TextWriter.Add(CAbc.CRLF + "..... Сверка корсчетов ....." + CAbc.CRLF);
        TextWriter.Add("Корсчет на конец " + __.StrD(PrevDate, 8, 8) + " ( ГК     ) =" + __.StrM(Acc1200Main, 19) + CAbc.CRLF);
        // TextWriter.Add( "Корсчет на конец " + __.StrD( PrevDate , 8 , 8 ) + " ( БРЦ    ) =" + __.StrM( Acc1200Brc , 19 ) + CAbc.CRLF  );
        if (AccVFile != 0)
        {
            TextWriter.Add("Корсчет по последнему V-файлу        =" + __.StrM(AccVFile, 19) + CAbc.CRLF);
        }
        TextWriter.Add("........................................................." + CAbc.CRLF);
        TextWriter.Close();
        // -------------------------------------------------------------
        __.Print(" Вывожу черный список ЕМА в файл " + ReportFileName + ".ema");
        if (RecordSet.Open(" exec dbo.Mega_CheckEMA_StopList "))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".ema", CAbc.CHARSET_DOS);
                TextWriter.Add(CAbc.CRLF + " Клиенты, включеные в черный список ЕМА " + CAbc.CRLF);
                TextWriter.Add(" По состоянию на " + __.Now().ToString() + CAbc.CRLF);
                TextWriter.Add(DELIMITER2);
                TextWriter.Add(" Внутр.код | Идент.код кл.| Имя клиента " + CAbc.CRLF);
                TextWriter.Add(DELIMITER2);
                do
                {
                    TextWriter.Add(__.Left(RecordSet[1], 11));
                    TextWriter.Add("|");
                    TextWriter.Add(__.Left(RecordSet[0], 14));
                    TextWriter.Add("|");
                    TextWriter.Add(__.Left(__.FixUkrI(RecordSet[2]), 64));
                    TextWriter.Add(CAbc.CRLF);
                } while (RecordSet.Read());
                TextWriter.Add(DELIMITER2);
                TextWriter.Close();
            }
        }
        // -------------------------------------------------------------
CHECK_MISC:
        __.Print(" Выполняются проверки дня " + __.StrD(PrevDate, 8, 8) + "  (Check_Misc) ...");
        if (RecordSet.Open(" exec dbo.Mega_Check_Misc " + PrevDate.ToString()))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
                TextWriter.Add(CAbc.CRLF + " Ошибки,обнаруженные при проверке дня " + __.StrD(PrevDate, 8, 8) + CAbc.CRLF);
                TextWriter.Add(CAbc.CRLF);
                do
                {
                    Kind    = __.CInt(RecordSet[0]);
                    BugInfo = RecordSet[2];
                    BugName = __.FixUkrI(RecordSet[3]);
                    if ((OldKind > 0) && (OldKind == Kind))
                    {
                        BugInfo = CAbc.EMPTY;
                    }
                    else
                    {
                        TextWriter.Add(DELIMITER1);
                    }
                    OldKind = Kind;
                    TextWriter.Add(__.Left(BugInfo, 32));
                    TextWriter.Add("|");
                    TextWriter.Add(__.Left(BugName, 44));
                    TextWriter.Add(CAbc.CRLF);
                } while (RecordSet.Read());
                TextWriter.Add(DELIMITER1);
                TextWriter.Add(CAbc.CRLF);
                TextWriter.Close();
            }
        }
        // ----------------------------------------------------------
        __.Print(" Выполняются проверки дня " + __.StrD(PrevDate, 8, 8) + "  (Check_Heap) ...");
        if (RecordSet.Open(" exec dbo.Mega_Check_Heap " + PrevDate.ToString()))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
                TextWriter.Add(" ...дополнительные проверки... ");
                TextWriter.Add(CAbc.CRLF);
                do
                {
                    Kind    = __.CInt(RecordSet[0]);
                    BugInfo = RecordSet[2];
                    BugName = __.FixUkrI(RecordSet[3]);
                    if ((OldKind > 0) && (OldKind == Kind))
                    {
                        BugInfo = CAbc.EMPTY;
                    }
                    else
                    {
                        TextWriter.Add(DELIMITER1);
                    }
                    OldKind = Kind;
                    TextWriter.Add(__.Left(BugInfo, 32));
                    TextWriter.Add("|");
                    TextWriter.Add(__.Left(BugName, 44));
                    TextWriter.Add(CAbc.CRLF);
                } while (RecordSet.Read());
                TextWriter.Add(DELIMITER1);
                TextWriter.Add(CAbc.CRLF);
                TextWriter.Close();
            }
        }
        // ----------------------------------------------------------
        if (!MainBank)
        {
            goto    END_OF_PROC;
        }
        // ----------------------------------------------------------
        __.Print(" Ошибки в настройках регуляных платежей - в " + ReportFileName + ".err");
        if (RecordSet.Open(" exec  dbo.Mega_Pst_ERC_CheckReport"))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
                TextWriter.Add(CAbc.CRLF + " Ошибки в настройках регуляных платежей " + CAbc.CRLF);
                TextWriter.Add(DELIMITER3);
                TextWriter.Add("          Название ошибки       | Код клиента |   Номер счета    |      Название клиента " + CAbc.CRLF);
                TextWriter.Add(DELIMITER3);
                do
                {
                    TextWriter.Add(__.Left(RecordSet["ErrorText"], 32));
                    TextWriter.Add("|");
                    TextWriter.Add(__.Left(RecordSet["Code"], 12));
                    TextWriter.Add(" | ");
                    TextWriter.Add(__.Left(RecordSet["Moniker"], 17));
                    TextWriter.Add("| ");
                    TextWriter.Add(__.FixUkrI(RecordSet["Name"]));
                    TextWriter.Add(CAbc.CRLF);
                } while (RecordSet.Read());
                TextWriter.Add(DELIMITER3);
                TextWriter.Add(CAbc.CRLF);
                TextWriter.Close();
            }
        }
        // --------------------------------------------------------
        __.Print(" Ошибки в договорах залогов - в  " + ReportFileName + ".err");
        if (RecordSet.Open(" exec  dbo.Mega_CheckTreatyPawnDate "))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
                TextWriter.Add(CAbc.CRLF + CAbc.CRLF + " Ошибки в договорах залогов " + CAbc.CRLF);
                TextWriter.Add(DELIMITER4);
                TextWriter.Add("  Id договора |   Id залога  |   Номер договора   |    Номер залога    |   Название клиента" + CAbc.CRLF);
                TextWriter.Add(DELIMITER4);
                do
                {
                    TextWriter.Add(__.Right(RecordSet[0], 13));
                    TextWriter.Add(" |");
                    TextWriter.Add(__.Right(RecordSet[3], 13));
                    TextWriter.Add(" |");
                    TextWriter.Add(__.Left(RecordSet[1], 20));
                    TextWriter.Add("|");
                    TextWriter.Add(__.Left(RecordSet[4], 20));
                    TextWriter.Add("|");
                    TextWriter.Add(__.FixUkrI(RecordSet[2]));
                    TextWriter.Add(CAbc.CRLF);
                } while (RecordSet.Read());
                TextWriter.Add(DELIMITER4);
                TextWriter.Add(CAbc.CRLF);
                TextWriter.Close();
            }
        }
        // --------------------------------------------------------
        __.Print(" Ведомость невынесенных на просрочку - в " + ReportFileName + ".err");
        if (RecordSet.Open(" exec  dbo.Mega_Treaty_Check_Prosroch_Control "))
        {
            if (RecordSet.Read())
            {
                TextWriter.OpenForAppend(ReportFileName + ".err", CAbc.CHARSET_DOS);
                TextWriter.Add(CAbc.CRLF + " Не вынесенные на просрочку договора " + CAbc.CRLF);
                TextWriter.Add(DELIMITER5);
                TextWriter.Add("                Описание ошибки                    ¦ ID договора " + CAbc.CRLF);
                TextWriter.Add(DELIMITER5);
                do
                {
                    TextWriter.Add(__.Left(RecordSet[0], 51));
                    TextWriter.Add("| ");
                    TextWriter.Add(__.Right(RecordSet[1], 13));
                    TextWriter.Add(CAbc.CRLF);
                } while (RecordSet.Read());
                TextWriter.Add(DELIMITER5);
                TextWriter.Add(CAbc.CRLF);
                TextWriter.Close();
            }
        }
        // --------------------------------------------------------
END_OF_PROC:
        RecordSet.Close();
        Connection.Close();
    }
 public void AppendLine(System.Decimal value, StandardFormat format)
 {
     Append(value, format);
     AppendLine();
 }
Пример #50
0
 partial void OnTotalDueChanging(System.Decimal value);
 public void AppendLine(System.Decimal value)
 {
     Append(value);
     AppendLine();
 }
Пример #52
0
 partial void OnTaxAmtChanging(System.Decimal value);
Пример #53
0
 partial void OnStandardPriceChanging(System.Decimal value);
Пример #54
0
 partial void OnSubTotalChanging(System.Decimal value);
Пример #55
0
        public static List <DCACCESO_ROLL> ACCESO_ROLLObtenerbyCriterio(System.Decimal ID_ROLL, System.Decimal IDUSUARIO)
        {
            try
            {
                string TableName = "ACCESO_ROLL";
                string SqlText   = @"select ID_ACCESO_ROLL, ID_ACCESO, ID_ROLL, ACTIVO, IDUSUARIOCREO, 
FECHACREO, IDUSUARIOMODIFICO, FECHAMODIFICO from ACCESO_ROLL WHERE ACTIVO = 'SI' AND ID_ROLL = " + ID_ROLL;

                conexionSQL DBAdmin2 = new conexionSQL();
                DBAdmin2.obtenerDataTable(SqlText);
                dtrespuesta = conexionSQL.DTGLOBAL;
                List <DCACCESO_ROLL> lst = new List <DCACCESO_ROLL>();

                for (int i = 0; i < dtrespuesta.Rows.Count; i++)
                {
                    lst.Add
                    (
                        new DCACCESO_ROLL
                        (
                            Convert.ToDecimal(dtrespuesta.Rows[i]["ID_ACCESO_ROLL"].Equals(System.DBNull.Value) ? 0 : dtrespuesta.Rows[i]["ID_ACCESO_ROLL"]),
                            Convert.ToDecimal(dtrespuesta.Rows[i]["ID_ACCESO"].Equals(System.DBNull.Value) ? 0 : dtrespuesta.Rows[i]["ID_ACCESO"]),
                            Convert.ToDecimal(dtrespuesta.Rows[i]["ID_ROLL"].Equals(System.DBNull.Value) ? 0 : dtrespuesta.Rows[i]["ID_ROLL"]),
                            (System.String)(dtrespuesta.Rows[i]["ACTIVO"].Equals(System.DBNull.Value) ? "" : dtrespuesta.Rows[i]["ACTIVO"]),
                            Convert.ToDecimal(dtrespuesta.Rows[i]["IDUSUARIOCREO"].Equals(System.DBNull.Value) ? 0 : dtrespuesta.Rows[i]["IDUSUARIOCREO"]),
                            Convert.ToDateTime(dtrespuesta.Rows[i]["FECHACREO"].Equals(System.DBNull.Value) ? new DateTime() : dtrespuesta.Rows[i]["FECHACREO"]),
                            Convert.ToDecimal(dtrespuesta.Rows[i]["IDUSUARIOMODIFICO"].Equals(System.DBNull.Value) ? 0 : dtrespuesta.Rows[i]["IDUSUARIOCREO"]),
                            Convert.ToDateTime(dtrespuesta.Rows[i]["FECHAMODIFICO"].Equals(System.DBNull.Value) ? new DateTime() : dtrespuesta.Rows[i]["FECHAMODIFICO"])
                        )
                    );
                }
                return(lst);
            }
            catch (Exception ex)
            {
                return(new List <DCACCESO_ROLL>());
            }
        }
Пример #56
0
 partial void OnFreightChanging(System.Decimal value);
Пример #57
0
        public static decimal ACCESO_ROLLRegistrar(System.Decimal ID_ACCESO_ROLL, System.Decimal ID_ACCESO,
                                                   System.Decimal ID_ROLL, System.String ACTIVO, System.Decimal IDUSUARIOCREO,
                                                   System.DateTime FECHACREO, System.Decimal IDUSUARIOMODIFICO, System.DateTime FECHAMODIFICO)
        {
            try
            {
                if (ID_ACCESO_ROLL == 0)
                {
                    object Id;
                    //inserta en la tabla sin retornar valor.
                    string TableName = "ACCESO_ROLL";
                    string SqlText   = @"Insert into " + TableName + @" (ID_ACCESO, ID_ROLL, ACTIVO, IDUSUARIOCREO, 
FECHACREO, IDUSUARIOMODIFICO, FECHAMODIFICO) 
values (" + ID_ACCESO + ", " + ID_ROLL + ", '" + ACTIVO + "', " + IDUSUARIOCREO +
                                       ", convert(datetime, '" + FECHACREO.Year + "-" + FECHACREO.Month + "-" + FECHACREO.Day + " " + FECHACREO.Hour
                                       + ":" + FECHACREO.Minute + ":" + FECHACREO.Second + "', 120), " + IDUSUARIOMODIFICO +
                                       ", convert(datetime, '" + FECHACREO.Year + "-" + FECHACREO.Month + "-" + FECHACREO.Day + " " + FECHACREO.Hour
                                       + ":" + FECHACREO.Minute + ":" + FECHACREO.Second + "', 120))";

                    conexionSQL DBAdmin = new conexionSQL();
                    DBAdmin.executeComando(SqlText);

                    string SqlText2 = "select max(ID_ACCESO_ROLL) ID_ACCESO_ROLL FROM ACCESO_ROLL where IDUSUARIOCREO = " + IDUSUARIOCREO;

                    conexionSQL DBAdmin2 = new conexionSQL();
                    DBAdmin2.obtenerDataTable(SqlText2);
                    decimal IDSELECCIONADO = Convert.ToDecimal(dtrespuesta.Rows[0]["ID_ACCESO_ROLL"]);
                    return(IDSELECCIONADO);
                }
                else
                {
                    return(ID_ACCESO_ROLL);
                }
            }
            catch (Exception ex)
            {
                return(0);
            }
        }
Пример #58
0
 public static System.Decimal Round(this System.Decimal d)
 {
     return(System.Math.Round(d));
 }
Пример #59
0
            public ProductsRow AddProductsRow(string ProductName, int SupplierID, CategoriesRow parentCategoriesRowByCategoriesProducts, string QuantityPerUnit, System.Decimal UnitPrice, short UnitsInStock, short UnitsOnOrder, short ReorderLevel, bool Discontinued)
            {
                ProductsRow rowProductsRow = ((ProductsRow)(this.NewRow()));

                rowProductsRow.ItemArray = new object[] {
                    null,
                    ProductName,
                    SupplierID,
                    parentCategoriesRowByCategoriesProducts[0],
                    QuantityPerUnit,
                    UnitPrice,
                    UnitsInStock,
                    UnitsOnOrder,
                    ReorderLevel,
                    Discontinued
                };
                this.Rows.Add(rowProductsRow);
                return(rowProductsRow);
            }
 partial void OnSalesQuotaChanging(System.Decimal value);