本文整理汇总了C#中Texfina.Core.Data.DBAccess.ExecuteDatatable方法的典型用法代码示例。如果您正苦于以下问题：C# DBAccess.ExecuteDatatable方法的具体用法？C# DBAccess.ExecuteDatatable怎么用？C# DBAccess.ExecuteDatatable使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Texfina.Core.Data.DBAccess的用法示例。
在下文中一共展示了DBAccess.ExecuteDatatable方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetFactura_rpt01
public DataTable GetFactura_rpt01(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@fechaini", SqlDbType.Char, oc.fechaini));
arrPrm.Add(DBAccess.CreateParameter("@fechafin", SqlDbType.VarChar, oc.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@idcliprov", SqlDbType.VarChar, oc.idProv));
arrPrm.Add(DBAccess.CreateParameter("@local", SqlDbType.VarChar, oc.local));
arrPrm.Add(DBAccess.CreateParameter("@idempresa", SqlDbType.VarChar, oc.IdEmpresa));
DataTable dt = db.ExecuteDatatable("sp_ocfactura_rpt", arrPrm);
return dt;
}示例2: AL_Salida_Detalle_rpt02
public DataTable AL_Salida_Detalle_rpt02(ESalida_Detalle obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@fecha_ini", SqlDbType.DateTime, obj.Fe_creatrec));
arrPrm.Add(DBAccess.CreateParameter("@fecha_fin", SqlDbType.DateTime, obj.Fe_uupdarec));
arrPrm.Add(DBAccess.CreateParameter("@vendedor", SqlDbType.VarChar, 15, obj.Id_vendedor));
arrPrm.Add(DBAccess.CreateParameter("@producto", SqlDbType.VarChar, 20, obj.Id_producto));
arrPrm.Add(DBAccess.CreateParameter("@color", SqlDbType.VarChar, 40, obj.Id_color));
arrPrm.Add(DBAccess.CreateParameter("@cliente", SqlDbType.VarChar, 50, obj._id_cliente));
arrPrm.Add(DBAccess.CreateParameter("@tipo", SqlDbType.VarChar, 20, obj.Id_tipo));
arrPrm.Add(DBAccess.CreateParameter("@dsMercado", SqlDbType.VarChar, 15, obj.Id_mercado));
arrPrm.Add(DBAccess.CreateParameter("@dstipTela", SqlDbType.VarChar, 15, obj.Id_tiptela));
DataTable dt = db.ExecuteDatatable("AL_Salida_Detalle_rpt02", arrPrm);
return dt;
}示例3: MG_Cliente_rpt01
public DataTable MG_Cliente_rpt01(ECliente c)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, c.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@nu_ruc", SqlDbType.Char, 11, c.Nu_ruc.Trim()));
arrPrm.Add(DBAccess.CreateParameter("@ds_raznombre", SqlDbType.Char, 100, c.Ds_raznombre.Trim()));
DataTable dt = db.ExecuteDatatable("MG_Cliente_rpt01", arrPrm);
return dt;
}示例4: GetOrdenCompra_rpt03
// orden de compra por proveedor
public DataTable GetOrdenCompra_rpt03(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@fechaIni", SqlDbType.DateTime, oc.fechaini));
arrPrm.Add(DBAccess.CreateParameter("@fechaFin", SqlDbType.DateTime, oc.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@idcliprov", SqlDbType.VarChar, oc.idProv));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompraXprov_qry03_rpt", arrPrm);
return dt;
}示例5: GetOrdenCompra_rpt04
//reprote de orden de compra por proveedor
public DataTable GetOrdenCompra_rpt04(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@año", SqlDbType.VarChar, 5, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@mes", SqlDbType.VarChar, 16, oc.IdMesIni));
arrPrm.Add(DBAccess.CreateParameter("@prov", SqlDbType.VarChar, 6, oc.idProv));
arrPrm.Add(DBAccess.CreateParameter("@fac", SqlDbType.VarChar, 8, oc.nuFactura));
arrPrm.Add(DBAccess.CreateParameter("@impotacion", SqlDbType.VarChar, 10, oc.nuImportacion));
arrPrm.Add(DBAccess.CreateParameter("@Expotacion", SqlDbType.VarChar, 10, oc.nuExportacion));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompra_qry02_rpt", arrPrm);
return dt;
}示例6: AL_Salida_rpt01
public DataTable AL_Salida_rpt01(ESalida obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, obj.IdPeriodo));
arrPrm.Add(DBAccess.CreateParameter("@pidSalida", SqlDbType.Char, 7, obj.IdSalida));
DataTable dt = db.ExecuteDatatable("AL_Salida_rpt01", arrPrm);
return dt;
}示例7: GetOrdenCompra_rpt02
public DataTable GetOrdenCompra_rpt02(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pchr_idperiodo", SqlDbType.Char, 4, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@pchr_idordenco", SqlDbType.Char, 7, oc.IdOrdenCompra));
arrPrm.Add(DBAccess.CreateParameter("@pdte_empresa", SqlDbType.Char, 3, oc.IdEmpresa));
DataTable dt = db.ExecuteDatatable("RPT_OrdenCompra", arrPrm);
return dt;
}示例8: _AL_Producto_Stock
public DataTable _AL_Producto_Stock(EIngresoDetalle obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@psintypesel", SqlDbType.Char, 1, obj.psintypesel));
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.VarChar, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@ds_raznombre", SqlDbType.VarChar, 60, obj.ds_clipro));
arrPrm.Add(DBAccess.CreateParameter("@ds_producto", SqlDbType.VarChar, 100, obj.ds_producto));
arrPrm.Add(DBAccess.CreateParameter("@ds_vendedor", SqlDbType.VarChar, 60, obj.Ds_Vendedor));
arrPrm.Add(DBAccess.CreateParameter("@ds_color", SqlDbType.VarChar, 60, obj.ds_color));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_Detalle_Stock", arrPrm);
return dt;
}示例9: CO_OrdenCompra_qry09_rpt
public DataTable CO_OrdenCompra_qry09_rpt(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@anio", SqlDbType.VarChar, 4, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@mesIni", SqlDbType.VarChar, 2, oc.IdMesIni));
arrPrm.Add(DBAccess.CreateParameter("@mesFin", SqlDbType.VarChar, 2, oc.IdMesfin));
arrPrm.Add(DBAccess.CreateParameter("@st_aprueba", SqlDbType.VarChar, 1, oc.st_aprueba));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompra_qry09_rpt", arrPrm);
return dt;
}示例10: AL_Ingreso_Detalle_rpt01
public DataTable AL_Ingreso_Detalle_rpt01(EIngresoDetalle oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@feIni", SqlDbType.VarChar, 10, oc.fecha));
arrPrm.Add(DBAccess.CreateParameter("@feFin", SqlDbType.VarChar, 10, oc.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@dsCliente", SqlDbType.VarChar, 60, oc.ds_clipro));
arrPrm.Add(DBAccess.CreateParameter("@dsProducto", SqlDbType.VarChar, 100, oc.ds_producto));
arrPrm.Add(DBAccess.CreateParameter("@dsColor", SqlDbType.VarChar, 80, oc.ds_color));
arrPrm.Add(DBAccess.CreateParameter("@dsMercado", SqlDbType.VarChar, 30, oc.Id_mercado));
arrPrm.Add(DBAccess.CreateParameter("@dsTipTela", SqlDbType.VarChar, 20, oc.Id_tipTela));
arrPrm.Add(DBAccess.CreateParameter("@dsTipIngreso", SqlDbType.VarChar, 30, oc.Id_TipIngreso));
arrPrm.Add(DBAccess.CreateParameter("@dsTipo", SqlDbType.VarChar, 30, oc.Id_Tipo));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_Detalle_rpt01", arrPrm);
return dt;
}示例11: AL_Ingreso_etiqueta03_rpt
public DataTable AL_Ingreso_etiqueta03_rpt(EIngresoDetalle oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@Cod_Bar", SqlDbType.VarChar, oc.Cod_Bar));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_etiqueta03_rpt", arrPrm);
return dt;
}示例12: AL_Ingreso_etiqueta_rpt
public DataTable AL_Ingreso_etiqueta_rpt(EIngreso obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
//arrPrm.Add(DBAccess.CreateParameter("@psintypesel", SqlDbType.Int, tj.psintypesel));
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, obj.IdPeriodo));
arrPrm.Add(DBAccess.CreateParameter("@pidIngreso", SqlDbType.Char, 7, obj.IdIngreso));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_etiqueta_rpt", arrPrm);
return dt;
}示例13: VE_OrdenPedido_qry07_rpt
public DataTable VE_OrdenPedido_qry07_rpt(EParametros obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.idEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, obj.idperiodo));
// arrPrm.Add(DBAccess.CreateParameter("@pidreqsalida", SqlDbType.Char, 7, obj.pidreqsalida));
arrPrm.Add(DBAccess.CreateParameter("@pdte_feordenpeini", SqlDbType.DateTime, obj.fechaIni));
arrPrm.Add(DBAccess.CreateParameter("@pdte_feordenpefin", SqlDbType.DateTime, obj.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@pestado", SqlDbType.Char, 1, obj.estado));
DataTable dt = db.ExecuteDatatable("VE_OrdenPedido_qry07_rpt", arrPrm);
return dt;
}示例14: GetOrdenPedido_rpt01
public DataTable GetOrdenPedido_rpt01(EOrdPedido op)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, op.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, op.IdPeriodo));
arrPrm.Add(DBAccess.CreateParameter("@pidreqsalida", SqlDbType.Char, 7, op.Idreqsalida));
DataTable dt = db.ExecuteDatatable("VE_OrdenPedido_rpt01", arrPrm);
return dt;
}示例15: GetFctura_rpt02
public DataTable GetFctura_rpt02(EParOCFillrpt fac)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idPeriodo", SqlDbType.Char, 5, fac.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, fac.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@fechaini", SqlDbType.Char, 10, fac.fechaini ));
arrPrm.Add(DBAccess.CreateParameter("@fechafin", SqlDbType.Char, 10, fac.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@exportacion", SqlDbType.Char, 7, fac.nuExportacion));
arrPrm.Add(DBAccess.CreateParameter("@importacion", SqlDbType.Char, 7, fac.nuImportacion));
arrPrm.Add(DBAccess.CreateParameter("@nuFactura", SqlDbType.Char, 12, fac.nuFactura));
arrPrm.Add(DBAccess.CreateParameter("@idOrden", SqlDbType.Char, 10,fac.IdOrdenCompra));
DataTable dt = db.ExecuteDatatable("CO_Factura_rpt", arrPrm);
return dt;
}