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();
}
});
}