public String Pedidos_CQ_Instant()
{
SessionClass session = new SessionClass();
session.UserLogon("admin", "admin", "PRESU", 2, "BPD_DESA");
OAdQuerydef queryDef = (OAdQuerydef)session.BuildQuery("Pedido_Pago");
queryDef.BuildField("id");
queryDef.BuildField("Importe_Total");
OAdResultset resultset = (OAdResultset)session.BuildResultSet(queryDef);
resultset.Execute();
var Status = resultset.MoveNext();
String data = "";
while (Convert.ToInt32(Status) == 1)
{
data = (String)resultset.GetColumnValue(2);
Status = resultset.MoveNext();
}
return(data);
}
public ArrayList Pedidos_CQ()
{
SessionClass session = new SessionClass();
session.UserLogon("admin", "admin", "PRESU", 2, "BPD_DESA");
OAdQuerydef queryDef = (OAdQuerydef)session.BuildQuery("Pedido_Pago");
queryDef.BuildField("id");
queryDef.BuildField("Importe_Total");
OAdResultset resultset = (OAdResultset)session.BuildResultSet(queryDef);
ArrayList PedidosdePagos = new ArrayList();
resultset.Execute();
var Status = resultset.MoveNext();
while (Convert.ToInt32(Status) == 1)
{
Pedido_Pago data = new Pedido_Pago();
data.id_pedido = (String)resultset.GetColumnValue(1);
data.importe_total = (String)resultset.GetColumnValue(2);
PedidosdePagos.Add(data);
Status = resultset.MoveNext();
}
return(PedidosdePagos);
}
public bool Validate() {
try {
IOAdSession session = new SessionClass();
session.UserLogon(entity.UserName, entity.Password, entity.DataBase, SessionTypePrivate, entity.ConnectionName);
session.SignOff();
return true;
} catch(Exception) {
return false;
}
}