//----------------------------------- 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; }
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; } }
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; }
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); }
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; }
public virtual void AddItem(string IDOP, Decimal Cantidad) { ItemGuiaRemision Item = new ItemGuiaRemision(); Item.IDOrdenProduccion = IDOP; Item.Cantidad = Cantidad; Items.Add(Item); }
//---------------------------------------------------------- // получить значение колонки для записи в А-файл 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 ); }
/// <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; } }
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; } }
/// <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; }
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); }
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); }
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); }
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; }
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 ); }
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; } }
public ParseTest(String str, Decimal d, NumberStyles style) { this.str = str; this.exceptionFlag = false; this.style = style; this.d = d; }
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; }
private void edtRaiDecimal_ValueChanged(object sender, EventArgs e) { if (!mChanging) { Area = edtRaiDecimal.Value * SquareKilometerToRai; } }
public MakersMatchRank_History() { _gmid = (0); _Score = (0); _GameTime = DateTime.Now; _Rank = (0); }
public Tweet GetTweet(Decimal id) { Tweet tweet = (from t in _entity.Tweets where t.ID == id select t).FirstOrDefault(); return tweet; }
private void edtSquareKilometer_ValueChanged(object sender, EventArgs e) { if (!mChanging) { Area = edtSquareKilometer.Value; } }
private SqlDecimal(bool isNull) { _value = Decimal.Zero; _isNull = isNull; _precision = 38; _scale = 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"); } }
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); }
} //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(); }
} //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
} //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
} //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
} //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
partial void OnAverageRateChanging(System.Decimal value);
partial void OnEndOfDayRateChanging(System.Decimal value);
/// <summary> /// Marks the HMDARateSpreadPercent value as null. /// </summary> public virtual void SetHMDARateSpreadPercentNull() { _hmdaratespreadpercent = 0; _hmdaratespreadpercent_isnull = true; }
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; }
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); } }
} // 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
/// <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; }
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); }
} //FOLD00 string StrF(money M) //fold00 { return(__.Right(M.ToString().Replace(",", "."), 13)); } //FOLD00
} //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
// ------------------------------------------------------ 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(); }
partial void OnTotalDueChanging(System.Decimal value);
public void AppendLine(System.Decimal value) { Append(value); AppendLine(); }
partial void OnTaxAmtChanging(System.Decimal value);
partial void OnStandardPriceChanging(System.Decimal value);
partial void OnSubTotalChanging(System.Decimal value);
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>()); } }
partial void OnFreightChanging(System.Decimal value);
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); } }
public static System.Decimal Round(this System.Decimal d) { return(System.Math.Round(d)); }
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);