public List <OtDTO> listarOtPago(String codent, String cliente) { List <OtDTO> objLista = new List <OtDTO>(); OtDTO obj; Database db = DatabaseFactory.CreateDatabase("Conta"); DbCommand dbCommand = db.GetStoredProcCommand("sp_getDatosOt", new object[] { codent, cliente }); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { obj = new OtDTO(); obj.CodigoOt = dataReader["CodOt"].ToString(); obj.EstadoOt = dataReader["estado"].ToString().Trim(); obj.Importe = convertToDouble(dataReader["Impot"].ToString()); obj.Item = Convert.ToInt32(dataReader["item"].ToString()); obj.NumeroOt = dataReader["NroOt"].ToString(); obj.Porcentaje = convertToDouble(dataReader["PorOt"].ToString()); obj.Tabla = dataReader["Tabla"].ToString(); obj.CuentaContable = dataReader["CuentaContable"].ToString(); obj.ProductoCodigo = dataReader["CodProd"].ToString(); obj.UnidadMedida = dataReader["UMsunat"].ToString(); obj.ProductoDescripcion = dataReader["desProd"].ToString(); objLista.Add(obj); } } return(objLista); }
private void GrdSolicita_DoubleClick(object sender, EventArgs e) { index = grdSolicita.SelectedCells[0].RowIndex; obj = objListTotal[index]; emisionForm.setOt(obj.NumeroOt, obj.DirOt, obj.CodigoOt); this.Close(); }
private void GrdOt_DoubleClick(object sender, EventArgs e) { index = grdOt.SelectedCells[0].RowIndex; obj = objListTotal[index]; cajaChicaForm.setOt(obj.NumeroOt, obj.Descripcion, obj.CodigoOt); this.Close(); }
public BuscarOt(String cliente) { InitializeComponent(); objOt = new OtDTO(); objOtDAO = new OtDAO(); gridParams(); objListOt = objOtDAO.listarOtPago(Ventas.UNIDADNEGOCIO, cliente); grdOt.DataSource = objListOt; facturaForm = Factura.formFactura; grdOt.DoubleClick += GrdOt_DoubleClick; grdOt.CellClick += GrdOt_CellClick; txt_BuscarDocumento.TextChanged += Txt_BuscarDocumento_TextChanged; objListBusquedaTotal = objListOt; }
public LoVOt() { InitializeComponent(); this.Text = "OT/ CENTRO DE COSTO"; this.StartPosition = FormStartPosition.Manual; this.Location = new Point(50, 20); obj = new OtDTO(); objLoVDao = new LoVDAO(); objListOt = objLoVDao.getLovOt(Ventas.UNIDADNEGOCIO); gridParams(); grdOt.DataSource = objListOt; cajaChicaForm = Caja.CajaChica.formCajachica; grdOt.DoubleClick += GrdOt_DoubleClick; txt_Busqueda.TextChanged += Txt_Busqueda_TextChanged; objListTotal = objListOt; }
public LoVOtSite() { InitializeComponent(); this.Text = "OT/CC"; this.StartPosition = FormStartPosition.Manual; this.Location = new Point(50, 20); emisionForm = Caja.EmisionVoucher.formEmision; objLoVDao = new LoVDAO(); obj = new OtDTO(); this.ActiveControl = txt_Busqueda; gridParams(); objListOt = objLoVDao.getLovOtSite(Ventas.UNIDADNEGOCIO); objListTotal = objListOt; grdSolicita.DataSource = objListOt; grdSolicita.Refresh(); txt_Busqueda.TextChanged += Txt_Busqueda_TextChanged; grdSolicita.DoubleClick += GrdSolicita_DoubleClick; }
public List <OtDTO> getLovOtSite(String CodEnt) { List <OtDTO> objList = new List <OtDTO>(); OtDTO obj; Database db = DatabaseFactory.CreateDatabase("Conta"); DbCommand dbCommand = db.GetStoredProcCommand("sp_lovOtSite", new object[] { CodEnt }); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { obj = new OtDTO(); obj.NumeroOt = dataReader["NroOt"].ToString().Trim(); obj.CodigoOt = dataReader["codot"].ToString().Trim(); obj.DirOt = dataReader["DesOt"].ToString().Trim().ToUpper(); objList.Add(obj); } } return(objList); }