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); }
private void ProcessRRNumber(RegistroDeReforma registroDeReforma) { RrResponse response = new RrResponse(); var task = new GenericTask() .WithPreExecuteProcess((b) => { Program.Main.ShowLoading(); }).WithBackGroundProcess((b, t) => { try { var request = new RrRequest(); request.Item = Convert.ToInt32(registroDeReforma.NumeroItem); request.Registro = Convert.ToInt32(registroDeReforma.NumeroRR); request.PasswordBD = ConfigurationBase.Instance.PasswordBD; request.Url = ConfigurationBase.Instance.ApiUrl; request.UserId = ConfigurationBase.Instance.UserIdBD; response = RrApi.Instance.GetRr(request); } catch (Exception ex) { Program.Main.ShowMessage("Ocorreu um erro ao buscar a RR", ToastLength.Long, ToastMessageType.Error); } }).WithPosExecuteProcess((b, t) => { if (response.Success) { txtClientName.Text = response.NomeCliente; txtData.Text = response.DataAbertura; txtEquipamentoDescription.Text = response.DescricaoEquipamento; txtNroNota.Text = response.NumeroNF.ToString(); LoadDataRegistroDeReforma(response); } Program.Main.HideLoading(); }).Execute(); }