public void CtorTest() { _dt.Rows[1].Delete(); DataTableReader reader = new DataTableReader(_dt); try { int i = 0; while (reader.Read()) i++; reader.Close(); Assert.Equal(2, i); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
protected override void InitForm() { formCode = "RSEmpCardFa"; base.InitForm(); this.Text = title; ItemMoneyText.Enter += TextBoxCurrency_Enter; ItemMoneyText.Leave += TextBoxCurrency_Leave; ItemMoneyText.Text = SystemInfo.CurrencySymbol + "0.00"; Column8.DefaultCellStyle.Format = SystemInfo.CurrencySymbol + "0.00"; Column9.DefaultCellStyle.Format = SystemInfo.CurrencySymbol + "0.00"; StrPosition = Pub.GetResText(formCode, "ItemPosition", ""); StrReading = Pub.GetResText(formCode, "MsgReadingData", ""); OriginSQL = Pub.GetSQL(DBCode.DB_001003, new string[] { "105", OprtInfo.DepartPower }); QuerySQL = Pub.GetSQL(DBCode.DB_001003, new string[] { "113", OriginSQL }); lblMsg.ForeColor = Color.Blue; lblResult.ForeColor = Color.Red; IsFaOk = false; IsFaCard = false; DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "108" })); if (dr.Read()) { CardStatusNormal = dr[0].ToString(); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } LoadData(); ItemCardFill.Visible = SystemInfo.AllowCustomerCardNo; ItemLine3.Visible = SystemInfo.AllowCustomerCardNo; }
public void NoTablesTest() { DataTableReader reader = new DataTableReader(new DataTable [] {}); try { reader.Read(); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
static void PrintTable(DataTable dt) { // Get the DataTableReader type. DataTableReader dtReader = dt.CreateDataReader(); // The DataTableReader works just like the DataReader. while (dtReader.Read()) { for (int i = 0; i < dtReader.FieldCount; i++) { Console.Write("{0}\t", dtReader.GetValue(i).ToString().Trim()); } Console.WriteLine(); } dtReader.Close(); }
static void PrintTable(DataTable aDataTable) // Проход по таблице DataTable через объект чтения { // Создание объекта DataTableReader. DataTableReader dataTableReader = aDataTable.CreateDataReader(); // dataTableReader работает так же, как и DataReader. while (dataTableReader.Read()) { for (int i = 0; i < dataTableReader.FieldCount; i++) { Console.Write("{0}\t", dataTableReader.GetValue(i).ToString().Trim()); } Console.WriteLine(); } dataTableReader.Close(); }
public void RowInAccessibleTest() { DataTableReader reader = new DataTableReader(dt); try { reader.Read(); reader.Read(); // 2nd row dt.Rows [1].Delete(); string value = reader [1].ToString(); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
static void PrintTable(DataTable dt) { // Получтить объект DataTableReader DataTableReader dtReader = dt.CreateDataReader(); // DataTableReader работает в точности как DataReader while (dtReader.Read()) { for (int i = 0; i < dtReader.FieldCount; i++) { Console.Write("{0}\t", dtReader.GetValue(i).ToString().Trim()); } Console.WriteLine(); } dtReader.Close(); }
static void PrintTable(DataTable dt) { // 得到DataTableReader类型 DataTableReader dtReader = dt.CreateDataReader(); // 像数据读取器一样操作DataTableReader while (dtReader.Read()) { for (int i = 0; i < dtReader.FieldCount; i++) { Console.Write("{0}\t", dtReader.GetValue(i).ToString().Trim()); } Console.WriteLine(); } dtReader.Close(); }
public void GetOrdinalTest() { DataTableReader reader = new DataTableReader(_dt); try { Assert.Equal(1, reader.GetOrdinal("name")); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
private static void PrintTable(DataTable dt) { DataTableReader dtReader = dt.CreateDataReader(); while (dtReader.Read()) { for (int i = 0; i < dtReader.FieldCount; i++) { Console.Write("{0} = {1} ", dtReader.GetName(i).Trim(), dtReader.GetValue(i).ToString().Trim()); } Console.WriteLine(); } dtReader.Close(); }
private static void PrintTable(DataTable t) { ForegroundColor = ConsoleColor.DarkYellow; DataTableReader reader = t.CreateDataReader(); while (reader.Read()) { for (var i = 0; i < reader.FieldCount; i++) { Write($"{reader.GetValue(i).ToString().Trim()}\t"); } WriteLine(); } reader.Close(); }
public void DeleteFirstCurrentAndAcceptChangesTest() { DataTableReader reader = new DataTableReader(dt); try { reader.Read(); // first row dt.Rows [0].Delete(); // delete row, where reader points to dt.AcceptChanges(); // accept the action Assert.AreEqual(2, (int)reader [0], "#1 should point to the first row"); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
static void PrintTable(DataTable dt) { //Get the DataTableReader type DataTableReader dtReader = dt.CreateDataReader(); //The DataTableReader works just like the DataReader while (dtReader.Read()) { for (var i = 0; i < dtReader.FieldCount; i++) { Write($"{dtReader.GetValue(i).ToString().Trim()}\t"); } WriteLine(); } dtReader.Close(); }
public IHttpActionResult GetAll() { SQLConexion _conexion = new SQLConexion(); List <SqlParameter> _Parametros = new List <SqlParameter>(); DataTableReader _dtr = null; List <CellPhones> _list = new List <CellPhones>(); try { _conexion.Conectar(System.Configuration.ConfigurationManager.ConnectionStrings["MiBD"].ToString()); _conexion.PrepararProcedimiento("sp_GetAllPhones", _Parametros); _dtr = _conexion.EjecutarTableReader(); if (_dtr.HasRows) { while (_dtr.Read()) { CellPhones _cellPhones = new CellPhones() { //Se recuperan los valores de acuerdo al alias que se definio en el procedimiento almacenado Id = Int32.Parse(_dtr["IdCellPhone"].ToString()), Name = _dtr["NamePhone"].ToString(), Firmware = _dtr["Firmware"].ToString(), Price = Double.Parse(_dtr["Price"].ToString()), Brand = _dtr["Brand"].ToString() }; _list.Add(_cellPhones); //Se agrega elemento 2 //HttpContext.Current.Session["Identificador"] = _user.Id; } //JavaScriptSerializer js = new JavaScriptSerializer(); //Context.Response.Write(js.Serialize(_list)); _dtr.Close(); return(Ok(_list)); } } catch (Exception e) { throw new Exception(e.Message); } finally { _conexion.Desconectar(); _conexion = null; _dtr = null; } return(Ok(_list)); }
/// <summary> /// Se obtiene El reporte completo por medio del identificador del reporte /// </summary> /// <param name="Conexion"> Conexion a la base de datos</param> /// <param name="IDReporte"> Identificador del reporte</param> /// <returns></returns> public ReporteFaltas ObtenerDetalleReporteFaltas(string Conexion, int IDReporte) { try { ReporteFaltas Resultado = new ReporteFaltas(); DataSet Ds = SqlHelper.ExecuteDataset(Conexion, "Reportes.spCSLDB_get_ReporteFaltasXID", IDReporte); if (Ds != null) { if (Ds.Tables.Count == 2) { DataTableReader Dr = Ds.Tables[0].CreateDataReader(); while (Dr.Read()) { Resultado.FechaInicio = !Dr.IsDBNull(Dr.GetOrdinal("FechaInicio")) ? Dr.GetDateTime(Dr.GetOrdinal("FechaInicio")) : DateTime.MinValue; Resultado.FechaFin = !Dr.IsDBNull(Dr.GetOrdinal("FechaFin")) ? Dr.GetDateTime(Dr.GetOrdinal("FechaFin")) : DateTime.MinValue; break; } Dr.Close(); List <ReporteFaltasDetalle> Lista = new List <ReporteFaltasDetalle>(); ReporteFaltasDetalle Item; DataTableReader Dr2 = Ds.Tables[1].CreateDataReader(); while (Dr2.Read()) { Item = new ReporteFaltasDetalle(); Item.IDSucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("id_sucursal")) ? Dr2.GetString(Dr2.GetOrdinal("id_sucursal")) : string.Empty; Item.Sucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("nombreSucursal")) ? Dr2.GetString(Dr2.GetOrdinal("nombreSucursal")) : string.Empty; Item.IDEmpleado = !Dr2.IsDBNull(Dr2.GetOrdinal("id_empleado")) ? Dr2.GetString(Dr2.GetOrdinal("id_empleado")) : string.Empty; Item.Empleado = !Dr2.IsDBNull(Dr2.GetOrdinal("nombreCompleto")) ? Dr2.GetString(Dr2.GetOrdinal("nombreCompleto")) : string.Empty; Item.Fecha = !Dr2.IsDBNull(Dr2.GetOrdinal("fecha")) ? Dr2.GetDateTime(Dr2.GetOrdinal("fecha")) : DateTime.MinValue; Item.EstatusEntrada = !Dr2.IsDBNull(Dr2.GetOrdinal("estatusEntrada")) ? Dr2.GetString(Dr2.GetOrdinal("estatusEntrada")) : string.Empty; Item.EstatusSalida = !Dr2.IsDBNull(Dr2.GetOrdinal("estatusSalida")) ? Dr2.GetString(Dr2.GetOrdinal("estatusSalida")) : string.Empty; Lista.Add(Item); } Dr2.Close(); Resultado.Detalle = Lista; Resultado.Completo = true; } } return(Resultado); } catch (Exception ex) { throw ex; } }
protected override void InitForm() { formCode = "SFAllowanceAdd"; CreateCardGridView(cardGrid); base.InitForm(); this.Text = Title + "[" + CurrentOprt + "]"; txtMoney.Enter += TextBoxCurrency_Enter; txtMoney.Leave += TextBoxCurrency_Leave; double d = 0; txtMoney.Text = d.ToString(SystemInfo.CurrencySymbol + "0.00"); cbbWay.Items.Clear(); DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004006, new string[] { "18" })); while (dr.Read()) { //if (dr["AllowanceWayID"].ToString() == "1") continue; cbbWay.Items.Add(new TCommonType(dr["AllowanceWaySysID"].ToString(), dr["AllowanceWayID"].ToString(), dr["AllowanceWayName"].ToString(), true)); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } cbbWay.Text = SystemInfo.ini.ReadIni("Public", "SFAllowanceWay", ""); if (cbbWay.SelectedIndex == -1 && cbbWay.Items.Count > 0) { cbbWay.SelectedIndex = 0; } dtpFlag.Value = DateTime.Now.Date; }
public ReporteTrabajosRealizados ObtenerDetalleReporteTrabajosRealizados(string Conexion, int IDReporte) { try { ReporteTrabajosRealizados Resultado = new ReporteTrabajosRealizados(); DataSet Ds = SqlHelper.ExecuteDataset(Conexion, "Reportes.spCSLDB_get_ReporteTrabajosRealizadosXID", IDReporte); if (Ds != null) { if (Ds.Tables.Count == 2) { DataTableReader Dr = Ds.Tables[0].CreateDataReader(); while (Dr.Read()) { Resultado.FechaInicio = !Dr.IsDBNull(Dr.GetOrdinal("FechaInicio")) ? Dr.GetDateTime(Dr.GetOrdinal("FechaInicio")) : DateTime.MinValue; Resultado.FechaFin = !Dr.IsDBNull(Dr.GetOrdinal("FechaFin")) ? Dr.GetDateTime(Dr.GetOrdinal("FechaFin")) : DateTime.MinValue; break; } Dr.Close(); List <ReporteTrabajosRealizadosDetalle> Lista = new List <ReporteTrabajosRealizadosDetalle>(); ReporteTrabajosRealizadosDetalle Item; DataTableReader Dr2 = Ds.Tables[1].CreateDataReader(); while (Dr2.Read()) { Item = new ReporteTrabajosRealizadosDetalle(); Item.IDSucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("IDSucursal")) ? Dr2.GetString(Dr2.GetOrdinal("IDSucursal")) : string.Empty; Item.Sucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("Sucursal")) ? Dr2.GetString(Dr2.GetOrdinal("Sucursal")) : string.Empty; Item.IDEmpleado = !Dr2.IsDBNull(Dr2.GetOrdinal("IDEmpleado")) ? Dr2.GetString(Dr2.GetOrdinal("IDEmpleado")) : string.Empty; Item.NombreEmpleado = !Dr2.IsDBNull(Dr2.GetOrdinal("NombreEmpleado")) ? Dr2.GetString(Dr2.GetOrdinal("NombreEmpleado")) : string.Empty; Item.IDServicio = !Dr2.IsDBNull(Dr2.GetOrdinal("IDServicio")) ? Dr2.GetString(Dr2.GetOrdinal("IDServicio")) : string.Empty; Item.NombreServicio = !Dr2.IsDBNull(Dr2.GetOrdinal("NombreServicio")) ? Dr2.GetString(Dr2.GetOrdinal("NombreServicio")) : string.Empty; Item.CantidadServicios = !Dr2.IsDBNull(Dr2.GetOrdinal("CantidadServicios")) ? Dr2.GetInt32(Dr2.GetOrdinal("CantidadServicios")) : 0; Lista.Add(Item); } Dr2.Close(); Resultado.Detalle = Lista; Resultado.Completo = true; } } return(Resultado); } catch (Exception ex) { throw ex; } }
private void LoadData() { dataGrid.Rows.Clear(); DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "101" })); while (dr.Read()) { dataGrid.Rows.Add(); dataGrid[0, dataGrid.RowCount - 1].Value = false; dataGrid[1, dataGrid.RowCount - 1].Value = dr["MacSysID"]; dataGrid[2, dataGrid.RowCount - 1].Value = dr["MacDoorSysID"]; dataGrid[3, dataGrid.RowCount - 1].Value = dr["MacSN"]; dataGrid[4, dataGrid.RowCount - 1].Value = dr["MacDoorID"]; dataGrid[5, dataGrid.RowCount - 1].Value = dr["MacDoorName"]; } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } for (int i = 0; i < doorList.Count; i++) { for (int j = 0; j < dataGrid.RowCount; j++) { if (dataGrid[2, j].Value.ToString() == doorList[i].DoorSysID) { dataGrid[0, j].Value = true; break; } } } }
protected void InitTime() { string ID = "1"; string T1S = "00:00"; string T1E = "23:59"; string T2S = "00:00"; string T2E = "00:00"; string T3S = "00:00"; string T3E = "00:00"; string T4S = "00:00"; string T4E = "00:00"; string T5S = "00:00"; string T5E = "00:00"; string T6S = "00:00"; string T6E = "00:00"; DataTableReader dr = null; string sql = ""; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "403", ID })); if (dr.Read()) { return; } // sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "405", ID, "", T1S, T1E, T2S, T2E, T3S, T3E, //T4S, T4E, T5S, T5E, T6S, T6E, OprtInfo.OprtNo }); else { sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "404", ID, "", T1S, T1E, T2S, T2E, T3S, T3E, T4S, T4E, T5S, T5E, T6S, T6E, OprtInfo.OprtNo }); } SystemInfo.db.ExecSQL(sql); } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
/// <summary> /// Método para obtener el detalle del reporte elegido /// </summary> /// <param name="Conexion">Cadena de conexión a la BD</param> /// <param name="IDReporte">ID del Reporte al que se quiere acceder</param> /// <returns>Retorna una lista con el detalle del reporte seleccionado.</returns> public ReporteComprasCliente ObtenerDetalleReporteComprasCliente(string Conexion, int IDReporte) { try { ReporteComprasCliente Resultado = new ReporteComprasCliente(); DataSet Ds = SqlHelper.ExecuteDataset(Conexion, "Reportes.spCSLDB_get_ReporteComprasClienteXID", IDReporte); if (Ds != null) { if (Ds.Tables.Count == 2) { DataTableReader Dr = Ds.Tables[0].CreateDataReader(); while (Dr.Read()) { Resultado.FechaInicio = !Dr.IsDBNull(Dr.GetOrdinal("FechaInicio")) ? Dr.GetDateTime(Dr.GetOrdinal("FechaInicio")) : DateTime.MinValue; Resultado.FechaFin = !Dr.IsDBNull(Dr.GetOrdinal("FechaFin")) ? Dr.GetDateTime(Dr.GetOrdinal("FechaFin")) : DateTime.MinValue; Resultado.IDCliente = !Dr.IsDBNull(Dr.GetOrdinal("IDCliente")) ? Dr.GetString(Dr.GetOrdinal("IDCliente")) : string.Empty; Resultado.Nombre = !Dr.IsDBNull(Dr.GetOrdinal("Nombre")) ? Dr.GetString(Dr.GetOrdinal("Nombre")) : string.Empty; break; } Dr.Close(); List <ReporteComprasClienteDetalle> Lista = new List <ReporteComprasClienteDetalle>(); ReporteComprasClienteDetalle Item; DataTableReader Dr2 = Ds.Tables[1].CreateDataReader(); while (Dr2.Read()) { Item = new ReporteComprasClienteDetalle(); Item.FolioVenta = !Dr2.IsDBNull(Dr2.GetOrdinal("FolioVenta")) ? Dr2.GetString(Dr2.GetOrdinal("FolioVenta")) : string.Empty; Item.NombreSucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("NombreSucursal")) ? Dr2.GetString(Dr2.GetOrdinal("NombreSucursal")) : string.Empty; Item.FechaVenta = !Dr2.IsDBNull(Dr2.GetOrdinal("FechaVenta")) ? Dr2.GetDateTime(Dr2.GetOrdinal("FechaVenta")) : DateTime.MinValue; Item.Servicios = !Dr2.IsDBNull(Dr2.GetOrdinal("Servicios")) ? Dr2.GetString(Dr2.GetOrdinal("Servicios")) : string.Empty; Item.Total = !Dr2.IsDBNull(Dr2.GetOrdinal("Total")) ? Dr2.GetDecimal(Dr2.GetOrdinal("Total")) : 0; Lista.Add(Item); } Dr2.Close(); Resultado.Detalle = Lista; Resultado.Completo = true; } } return(Resultado); } catch (Exception ex) { throw ex; } }
public Promocion ObtenerDetallePromocion(string Conexion, int IDPromocion) { try { Promocion Resultado = new Promocion(); DataSet Ds = SqlHelper.ExecuteDataset(Conexion, "Produccion.spCSLDB_get_DetallePromocionModificar", IDPromocion); if (Ds != null) { if (Ds.Tables.Count == 2) { DataTableReader Dr = Ds.Tables[0].CreateDataReader(); while (Dr.Read()) { Resultado.IDPromocion = IDPromocion; Resultado.NombrePromocion = !Dr.IsDBNull(Dr.GetOrdinal("NombreProducto")) ? Dr.GetString(Dr.GetOrdinal("NombreProducto")) : string.Empty; Resultado.Lunes = !Dr.IsDBNull(Dr.GetOrdinal("Lunes")) ? Dr.GetBoolean(Dr.GetOrdinal("Lunes")) : false; Resultado.Martes = !Dr.IsDBNull(Dr.GetOrdinal("Martes")) ? Dr.GetBoolean(Dr.GetOrdinal("Martes")) : false; Resultado.Miercoles = !Dr.IsDBNull(Dr.GetOrdinal("Miercoles")) ? Dr.GetBoolean(Dr.GetOrdinal("Miercoles")) : false; Resultado.Jueves = !Dr.IsDBNull(Dr.GetOrdinal("Jueves")) ? Dr.GetBoolean(Dr.GetOrdinal("Jueves")) : false; Resultado.Viernes = !Dr.IsDBNull(Dr.GetOrdinal("Viernes")) ? Dr.GetBoolean(Dr.GetOrdinal("Viernes")) : false; Resultado.Sabado = !Dr.IsDBNull(Dr.GetOrdinal("Sabado")) ? Dr.GetBoolean(Dr.GetOrdinal("Sabado")) : false; Resultado.Domingo = !Dr.IsDBNull(Dr.GetOrdinal("Domingo")) ? Dr.GetBoolean(Dr.GetOrdinal("Domingo")) : false; } Dr.Close(); List <Sucursal> Lista = new List <Sucursal>(); Sucursal Item; DataTableReader Dr2 = Ds.Tables[1].CreateDataReader(); while (Dr2.Read()) { Item = new Sucursal(); Item.IDSucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("IDSucursal")) ? Dr2.GetString(Dr2.GetOrdinal("IDSucursal")) : string.Empty; Item.NombreSucursal = !Dr2.IsDBNull(Dr2.GetOrdinal("NombreSucursal")) ? Dr2.GetString(Dr2.GetOrdinal("NombreSucursal")) : string.Empty; Item.Seleccionado = !Dr2.IsDBNull(Dr2.GetOrdinal("Seleccionado")) ? Dr2.GetBoolean(Dr2.GetOrdinal("Seleccionado")) : false; Lista.Add(Item); } Dr2.Close(); Resultado.ListaSucursales = Lista; } } return(Resultado); } catch (Exception ex) { throw ex; } }
public CompraAlmacenModels ObtenerGridComprasAJAX(string _Conexion, int _Start, int _Length, string _SearchValue, int _OrderBy, string _OrderDirection) { try { CompraAlmacenModels Resultado = new CompraAlmacenModels(); object[] Parametros = { _Start, _Length, _SearchValue, _OrderBy, _OrderDirection }; DataSet Ds = SqlHelper.ExecuteDataset(_Conexion, "spCSLDB_get_CompraAlmcen_DataTable", Parametros); if (Ds != null) { if (Ds.Tables.Count == 2) { DataTableReader Dr = Ds.Tables[0].CreateDataReader(); while (Dr.Read()) { Resultado.SearchRecords = !Dr.IsDBNull(Dr.GetOrdinal("SearchRecords")) ? Dr.GetInt32(Dr.GetOrdinal("SearchRecords")) : 0; Resultado.TotalRecords = !Dr.IsDBNull(Dr.GetOrdinal("TotalRecords")) ? Dr.GetInt32(Dr.GetOrdinal("TotalRecords")) : 0; break; } Dr.Close(); List <CompraAlmacenModels> lista = new List <CompraAlmacenModels>(); DataTableReader dr = Ds.Tables[1].CreateDataReader(); CompraAlmacenModels item; while (dr.Read()) { item = new CompraAlmacenModels(); item.IDCompraAlmacen = dr["id_compraAlmacen"].ToString(); //item.IDCompraAlmacen = !dr.IsDBNull(dr.GetOrdinal("id_compraAlmacen")) ? dr.GetString(dr.GetOrdinal("id_compraAlmacen")) : string.Empty; item.NumFacturaNota = !dr.IsDBNull(dr.GetOrdinal("numFacturaNota")) ? dr.GetString(dr.GetOrdinal("numFacturaNota")) : string.Empty; item.Sucursal.NombreSucursal = !dr.IsDBNull(dr.GetOrdinal("nombreSuc")) ? dr.GetString(dr.GetOrdinal("nombreSuc")) : string.Empty; item.Proveedor.nombreProveedor = !dr.IsDBNull(dr.GetOrdinal("proveedor")) ? dr.GetString(dr.GetOrdinal("proveedor")) : string.Empty; item.IDEstatusCompra = !dr.IsDBNull(dr.GetOrdinal("id_estatusCompra")) ? dr.GetInt16(dr.GetOrdinal("id_estatusCompra")) : 0; item.StatusCompra = !dr.IsDBNull(dr.GetOrdinal("estatus")) ? dr.GetString(dr.GetOrdinal("estatus")) : string.Empty; item.MontoTotal = !dr.IsDBNull(dr.GetOrdinal("montoTotal")) ? dr.GetDecimal(dr.GetOrdinal("montoTotal")) : 0; lista.Add(item); } dr.Close(); Resultado.Lista = lista; } } return(Resultado); } catch (Exception ex) { throw ex; } }
public void AccessBeforeReadTest() { DataTableReader reader = new DataTableReader(dt); try { int i = (int)reader [0]; i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
private void LoadData() { DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } if (SysID != "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "1005", SysID })); if (dr.Read()) { txtMacSN.Text = dr["MacSN"].ToString(); switch (dr["MacConnType"].ToString()) { case MacConnTypeString.Comm: rbComm.Checked = true; cbbCommPort.Text = dr["MacPort"].ToString(); break; case MacConnTypeString.LAN: rbLAN.Checked = true; txtLANIP.Text = dr["MacIpAddress"].ToString(); txtLANPort.Text = dr["MacPort"].ToString(); break; } txtDesc.Text = dr["MacDesc"].ToString(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
public void AddAtPointTest () { DataTableReader reader = new DataTableReader (dt); try { reader.Read (); // first row reader.Read (); // second row DataRow r = dt.NewRow (); r [0] = 0; r [1] = "same point"; dt.Rows.InsertAt (r, 1); dt.Rows.Add (new object [] { 4, "mono 4"}); // should not affect the counter Assert.AreEqual (2, (int) reader [0], "#1 should not affect the current position"); } finally { if (reader != null && !reader.IsClosed) reader.Close (); } }
public void SeeTheModifiedTest() { DataTableReader reader = new DataTableReader(dt); try { reader.Read(); // first row dt.Rows [1] ["name"] = "mono changed"; reader.Read(); string value = reader [1].ToString(); Assert.AreEqual("mono changed", value, "#2 reader should have moved to 3rd row"); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void DeletePreviousAndAcceptChangesTest() { DataTableReader reader = new DataTableReader(dt); try { reader.Read(); // first row reader.Read(); // second row dt.Rows [0].Delete(); dt.AcceptChanges(); Assert.AreEqual(2, (int)reader [0], "#1 should not affect the current position"); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void NoRowsTest() { dt.Rows.Clear(); dt.AcceptChanges(); DataTableReader reader = new DataTableReader(dt); try { Assert.IsFalse(reader.Read(), "#1 there are no rows"); Assert.IsFalse(reader.NextResult(), "#2 there are no further resultsets"); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void IgnoreDeletedRowsDynamicTest() { DataTableReader reader = new DataTableReader(dt); try { reader.Read(); // first row dt.Rows [1].Delete(); reader.Read(); // it should be 3rd row string value = reader [0].ToString(); Assert.AreEqual("3", value, "#1 reader should have moved to 3rd row"); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void ClearTest() { DataTableReader reader = null; try { reader = new DataTableReader(_dt); reader.Read(); // first row reader.Read(); // second row _dt.Clear(); try { int i = (int)reader[0]; i++; // suppress warning Assert.False(true); } catch (RowNotInTableException) { } // clear and add test reader.Close(); reader = new DataTableReader(_dt); reader.Read(); // first row reader.Read(); // second row _dt.Clear(); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); bool success = reader.Read(); Assert.False(success); // clear when reader is not read yet reader.Close(); reader = new DataTableReader(_dt); _dt.Clear(); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); success = reader.Read(); Assert.True(success); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void ClearTest() { DataTableReader reader = null; try { reader = new DataTableReader(dt); reader.Read(); // first row reader.Read(); // second row dt.Clear(); try { int i = (int)reader [0]; i++; // supress warning Assert.Fail("#1 should have thrown RowNotInTableException"); } catch (RowNotInTableException) {} // clear and add test reader.Close(); reader = new DataTableReader(dt); reader.Read(); // first row reader.Read(); // second row dt.Clear(); dt.Rows.Add(new object [] { 8, "mono 8" }); dt.AcceptChanges(); bool success = reader.Read(); Assert.IsFalse(success, "#2 is always invalid"); // clear when reader is not read yet reader.Close(); reader = new DataTableReader(dt); dt.Clear(); dt.Rows.Add(new object [] { 8, "mono 8" }); dt.AcceptChanges(); success = reader.Read(); Assert.IsTrue(success, "#3 should add"); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public void MultipleResultSetsTest() { DataTable dt1 = new DataTable("test2"); dt1.Columns.Add("x", typeof(string)); dt1.Rows.Add(new object[] { "test" }); dt1.Rows.Add(new object[] { "test1" }); dt1.AcceptChanges(); DataTable[] collection = new DataTable[] { _dt, dt1 }; DataTableReader reader = new DataTableReader(collection); try { int i = 0; do { while (reader.Read()) i++; } while (reader.NextResult()); Assert.Equal(5, i); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void IgnoreDeletedRowsDynamicTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row _dt.Rows[1].Delete(); reader.Read(); // it should be 3rd row string value = reader[0].ToString(); Assert.Equal("3", value); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void GetOrdinalTest() { DataTableReader reader = new DataTableReader(_dt); try { Assert.Equal(1, reader.GetOrdinal("name")); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void MultipleDeleteTest() { _dt.Rows.Add(new object[] { 4, "mono 4" }); _dt.Rows.Add(new object[] { 5, "mono 5" }); _dt.Rows.Add(new object[] { 6, "mono 6" }); _dt.Rows.Add(new object[] { 7, "mono 7" }); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); reader.Read(); reader.Read(); reader.Read(); _dt.Rows[3].Delete(); _dt.Rows[1].Delete(); _dt.Rows[2].Delete(); _dt.Rows[0].Delete(); _dt.Rows[6].Delete(); _dt.AcceptChanges(); Assert.Equal(5, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void RowInAccessibleTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); reader.Read(); // 2nd row _dt.Rows[1].Delete(); string value = reader[1].ToString(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void ReadAfterClosedTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); reader.Close(); reader.Read(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void ClearTest() { DataTableReader reader = null; try { reader = new DataTableReader(_dt); reader.Read(); // first row reader.Read(); // second row _dt.Clear(); try { int i = (int)reader[0]; i++; // supress warning Assert.False(true); } catch (RowNotInTableException) { } // clear and add test reader.Close(); reader = new DataTableReader(_dt); reader.Read(); // first row reader.Read(); // second row _dt.Clear(); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); bool success = reader.Read(); Assert.False(success); // clear when reader is not read yet reader.Close(); reader = new DataTableReader(_dt); _dt.Clear(); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); success = reader.Read(); Assert.True(success); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void DeleteFirstCurrentAndAcceptChangesTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row _dt.Rows[0].Delete(); // delete row, where reader points to _dt.AcceptChanges(); // accept the action Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void DeleteLastAndAcceptChangesTest2() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row reader.Read(); // third row _dt.Rows[2].Delete(); // delete row, where reader points to _dt.AcceptChanges(); // accept the action Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void AddAtPointTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row DataRow r = _dt.NewRow(); r[0] = 0; r[1] = "same point"; _dt.Rows.InsertAt(r, 1); _dt.Rows.Add(new object[] { 4, "mono 4" }); // should not affect the counter Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void DeletePreviousAndAcceptChangesTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row _dt.Rows[0].Delete(); _dt.AcceptChanges(); Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void DontSeeTheEarlierRowsTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row // insert a row at position 0 DataRow r = _dt.NewRow(); r[0] = 0; r[1] = "adhi bagavan"; _dt.Rows.InsertAt(r, 0); Assert.Equal(2, reader.GetInt32(0)); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void InvalidIndexTest() { Assert.Throws<ArgumentOutOfRangeException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); int i = (int)reader[90]; // kidding, ;-) i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void AccessBeforeReadTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { int i = (int)reader[0]; i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void SeeTheModifiedTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row _dt.Rows[1]["name"] = "mono changed"; reader.Read(); string value = reader[1].ToString(); Assert.Equal("mono changed", value); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void NoRowsTest() { _dt.Rows.Clear(); _dt.AcceptChanges(); DataTableReader reader = new DataTableReader(_dt); try { Assert.False(reader.Read()); Assert.False(reader.NextResult()); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void GetTest() { _dt.Columns.Add("nullint", typeof(int)); _dt.Rows[0]["nullint"] = 333; DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); int ordinal = reader.GetOrdinal("nullint"); // Get by name Assert.Equal(1, (int)reader["id"]); Assert.Equal(333, reader.GetInt32(ordinal)); Assert.Equal("Int32", reader.GetDataTypeName(ordinal)); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void NoTablesTest() { Assert.Throws<ArgumentException>(() => { DataTableReader reader = new DataTableReader(new DataTable[] { }); try { reader.Read(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void SchemaTest() { DataTable another = new DataTable("another"); another.Columns.Add("x", typeof(string)); another.Rows.Add(new object[] { "test 1" }); another.Rows.Add(new object[] { "test 2" }); another.Rows.Add(new object[] { "test 3" }); DataTableReader reader = new DataTableReader(new DataTable[] { _dt, another }); try { DataTable schema = reader.GetSchemaTable(); Assert.Equal(_dt.Columns.Count, schema.Rows.Count); Assert.Equal(_dt.Columns[1].DataType.ToString(), schema.Rows[1]["DataType"].ToString()); reader.NextResult(); //schema should change here schema = reader.GetSchemaTable(); Assert.Equal(another.Columns.Count, schema.Rows.Count); Assert.Equal(another.Columns[0].DataType.ToString(), schema.Rows[0]["DataType"].ToString()); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void CloseTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { int i = 0; while (reader.Read() && i < 1) i++; reader.Close(); reader.Read(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }