public DataTable get_poslog(string caja, string nro_ticket)
{
DataTable dtdoc = null;
string sqlquery = "SELECT * FROM TRN_POSLOG_DATA where trans_seq=" + nro_ticket.ToString() + " and WKSTN_ID=" + caja + "";
try
{
object results = new object[1];
Database db = new OracleDatabase(Ent_Acceso_BD.conn());
//string bus = "0103001000036-1";
DbCommand dbCommandWrapper = db.GetSqlStringCommand(sqlquery);
dtdoc = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
}
catch (Exception exc)
{
dtdoc = null;
}
return(dtdoc);
}
public DataTable get_documento(string nro_doc, ref string _mensaje)
{
DataTable dtdoc = null;
string sqlquery = "select * from trn_trans where trans_typcode='RETAIL_SALE' and fiscal_number like '%" + nro_doc + "%' AND TRANS_STATCODE='COMPLETE'";
try
{
object results = new object[1];
Database db = new OracleDatabase(Ent_Acceso_BD.conn());
//string bus = "0103001000036-1";
DbCommand dbCommandWrapper = db.GetSqlStringCommand(sqlquery);
dtdoc = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
_mensaje = "Conexion exitosa.";
}
catch (Exception exc)
{
dtdoc = null;
_mensaje = "Error en conexion: " + exc.Message + Environment.NewLine + exc.ToString();
}
return(dtdoc);
}