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);
}