protected void BindSuministro()
{
DataSet dsSuministros = ApoyoBD.BuscarSuministro(Busqueda.Text);
dgSuministros.DataSource = dsSuministros;
dgSuministros.DataBind();
}
protected void BindAnalisis()
{
DataSet dsAnalisis = ApoyoBD.BuscarAnalisis(Numero.Text);
dgAnalisis.DataSource = dsAnalisis;
dgAnalisis.DataBind();
}
protected void DataGrid_Edit(object sender, DataGridCommandEventArgs e)
{
if (e.CommandName.ToString() == "Editar")
{
dgAnalisis.EditItemIndex = e.Item.ItemIndex;
BindAnalisis();
}
if (e.CommandName.ToString() == "Guardar")
{
string strCodigo = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string strDescripcion = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
string strCantidad = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
string strPrecio1 = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
string strPrecio2 = ((TextBox)e.Item.Cells[7].Controls[0]).Text;
string strPrecio3 = ((TextBox)e.Item.Cells[9].Controls[0]).Text;
string strObservaciones = ((TextBox)e.Item.Cells[12].Controls[0]).Text;
ApoyoBD.Actualizar(strCodigo, strDescripcion, strCantidad, strPrecio1, strPrecio2, strPrecio3, strObservaciones, Numero.Text);
dgAnalisis.EditItemIndex = -1;
BindAnalisis();
}
if (e.CommandName.ToString() == "Eliminar")
{
string strCodigo = e.Item.Cells[2].Text;
ApoyoBD.Eliminar(strCodigo, Numero.Text);
BindAnalisis();
}
}
protected void Insertar_Suministro(object sender, DataGridCommandEventArgs e)
{
if (e.CommandName.ToString() == "Select")
{
ApoyoBD.Crear(e.Item.Cells[2].Text, e.CommandArgument.ToString(), Numero.Text);
BindAnalisis();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// Introducir aquí el código de usuario para inicializar la página
if (Page.IsPostBack == false)
{
DataSet dsProveedores = ApoyoBD.ObtenerProveedores();
foreach (DataRow dr in dsProveedores.Tables[0].Rows)
{
tdl_Proveedor1.Items.Add(dr[0].ToString());
tdl_Proveedor2.Items.Add(dr[0].ToString());
tdl_Proveedor3.Items.Add(dr[0].ToString());
}
}
}
protected override void Create()
{
fd = new FontDef(this, "Arial");
FontProp fp = new FontPropMM(fd, 1.9);
FontProp fp_Encabezado = new FontPropMM(fd, 1.9);
fp_Encabezado.bBold = true;
TableLayoutManager tlm = new TableLayoutManager(fp_Encabezado);
tlm.rContainerHeightMM = 50; //rPosInferior - rPosSuperior;
tlm.headerCellDef.rAlignV = RepObj.rAlignCenter;
//tlm.cellDef.pp_LineBottom = new PenProp(this, 0.05, Color.LightGray);
tlm.pp_LineV = null;
tlm.pp_LineH = null;
tlm.eNewContainer += new TableLayoutManager.NewContainerEventHandler(Tlm_NewContainer);
TableLayoutManager.Column col;
col = new TableLayoutManager.ColumnMM(tlm, "Nro.", 15);
col = new TableLayoutManager.ColumnMM(tlm, "Fecha", 18);
col.cellDef.rAlignH = RepObj.rAlignRight;
col = new TableLayoutManager.ColumnMM(tlm, "Proveedor", 54);
col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine;
col = new TableLayoutManager.ColumnMM(tlm, "Partida", 22);
col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine;
col = new TableLayoutManager.ColumnMM(tlm, "Unidad Solicitante", 69);
col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine;
col = new TableLayoutManager.ColumnMM(tlm, "Observaciones", 69);
col.cellDef.textMode = TableLayoutManager.TextMode.MultiLine;
col = new TableLayoutManager.ColumnMM(tlm, "Monto", 23);
col.cellDef.rAlignH = RepObj.rAlignRight;
BrushProp bp_Anulada = new BrushProp(this, Color.FromArgb(255, 255, 200));
//rDatos = ComprasSuministrosBD.ObtenerOrdenesCompras(rSector, rDesde, rHasta);
rDatos = ApoyoBD.ObtenerAnalisisDePrecios(rSector);
int nTotal = 0;
while ((rDatos.Read()) && (nTotal <= 88))
//rDatos.Read();
{
//tlm.cellDef.bp_Back = ((rDatos["Indi_Anulacion"].ToString() == "1") ? bp_Anulada : null);
tlm.NewRow();
tlm.Add(0, new RepString(fp, nTotal.ToString()));
tlm.Add(1, new RepString(fp, " "));
tlm.Add(2, new RepString(fp, " "));
tlm.Add(3, new RepString(fp, " "));
//tlm.Add(4, new RepString(fp, " " ));
//tlm.Add(5, new RepString(fp, " " ));
//tlm.Add(6, new RepString(fp, rDatos["Monto"].ToString()));
//tlm.Add(6, new RepString(fp, "Monto" ));
nTotal += 1;
}
rDatos.Close();
foreach (Page page in enum_Page)
{
Double rY = rPosInferior + 1.5;
page.SetLandscape();
page.AddLT_MM(rPosIzquierda, rY, new RepString(fp, DateTime.Now.ToShortDateString() +
" " + DateTime.Now.ToShortTimeString() + " " + nTotal.ToString()));
page.AddRT_MM(rPosDerecha, rY, new RepString(fp, page.iPageNo + " / " + iPageCount));
}
}