public ObservationResponse GetIdObservacao(ObservationRequest model) { var command = string.Format("select max(itemobs) as ultimo from obsrr where registro={0} and item={1} and parte = 0", model.Registro, model.Item); var response = RrBD.GetIdObservacao(command, model.UserId, model.PasswordBD, model.Url); return(response); }
public RrResponse GetRr(RrRequest model) { var command = string.Format("select a.dataabe,a.numeronf,b.nomcli,c.descprod,b.apecli,b.cidcli," + "(a.registro||'-'||c.item||'-'||'0') as RR from tdadosgerais a " + "inner join e085cli@sapprot_orcl b on a.codcli = b.codcli " + "inner join tequipamentos c on a.registro = c.registro and c.parte=0 " + "where a.registro = {0} and c.item = {1}", model.Registro, model.Item); var response = RrBD.GetRr(command, model.UserId, model.PasswordBD, model.Url); return(response); }
public bool InsertObservacao(ObservationRequest model) { var command = string.Format("insert into obsrr values({0}, {1}, 0, {2}, '{3}', '{4}', '{5}', '{6}')", model.Registro, model.Item, model.IdObservacao, model.Texto, DateTime.Today.ToShortDateString(), DateTime.Today.ToShortTimeString(), model.Usuario); var response = RrBD.InsertObservacao(command, model.UserId, model.PasswordBD, model.Url); return(response); }