private void Recibedetallemov(DataTable resultado) { if (resultado.Rows.Count > 0) { if (Tabladetallemov.Rows.Count > 0) { Tabladetallemov.Rows.Clear(); } foreach (DataRow fila in resultado.Rows) { var BL = new tb_60local_stock_inventario_rollo_cargaBL(); var BE = new tb_60local_stock_inventario_rollo_carga(); var dt = new DataTable(); BE.rollo = fila["rollo"].ToString(); dt = BL.GetAll_rollo(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { row = DataError.NewRow(); row["error"] = "» ROLLO: " + dt.Rows[0]["rollo"].ToString() + " --> " + dt.Rows[0]["tipodoc"].ToString() + " - " + dt.Rows[0]["serdoc"].ToString() + " - " + dt.Rows[0]["numdoc"].ToString(); DataError.Rows.Add(row); } else { row = Tabladetallemov.NewRow(); row["rollo"] = fila["rollo"].ToString(); row["productid"] = fila["productid"].ToString(); row["productname"] = fila["productname"].ToString(); row["stocklibros"] = fila["stocklibros"].ToString(); row["stockfisico"] = fila["stockfisico"].ToString(); row["diferencia"] = fila["diferencia"].ToString(); Tabladetallemov.Rows.Add(row); } } griddetallemov.DataSource = Tabladetallemov; calcular_totales(); } }
private void ValidaTabladetallemovmov(String xrollo) { var rowrollo = Tabladetallemov.Select("rollo='" + xrollo + "'"); if (rowrollo.Length > 0) { MessageBox.Show("Rollo Ya Existe !!!!!!!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Decimal xstocklibros = 0, xstockfisico = 0, xdiferencia = 0; griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["productname"].Value = string.Empty; if (xrollo.Trim().Length == 10) { var BL2 = new tb_60local_stock_inventario_rollo_cargaBL(); var BE2 = new tb_60local_stock_inventario_rollo_carga(); var dt2 = new DataTable(); BE2.rollo = xrollo; dt2 = BL2.GetAll_rollo(EmpresaID, BE2).Tables[0]; if (dt2.Rows.Count > 0) { var Mensaje = "» ROLLO: " + dt2.Rows[0]["rollo"].ToString() + "\n\n" + " »» TipDoc: " + dt2.Rows[0]["tipodoc"].ToString() + "\n" + " »» SerDoc: " + dt2.Rows[0]["serdoc"].ToString() + "\n" + " »» NumDoc: " + dt2.Rows[0]["numdoc"].ToString(); MessageBox.Show(Mensaje, "» Rollos Existentes ..."); return; } var BE = new tb_60local_stock_inventario_rollo(); var BL = new tb_60local_stock_inventario_rolloBL(); var dt = new DataTable(); BE.rollo = xrollo; dt = BL.GetAll_Rollo(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["rollo"].Value = dt.Rows[0]["rollo"].ToString().Trim(); griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["productid"].Value = dt.Rows[0]["productid"].ToString().Trim(); griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["productname"].Value = dt.Rows[0]["productname"].ToString().Trim(); griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["stocklibros"].Value = dt.Rows[0]["stocklibros"].ToString().Trim(); griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["stockfisico"].Value = dt.Rows[0]["stockfisico"].ToString().Trim(); xstocklibros = Convert.ToDecimal(dt.Rows[0]["stocklibros"].ToString()); xstockfisico = Convert.ToDecimal(dt.Rows[0]["stockfisico"].ToString()); xdiferencia = xstocklibros - xstockfisico; griddetallemov.Rows[griddetallemov.CurrentCell.RowIndex].Cells["diferencia"].Value = xdiferencia; Tabladetallemov.AcceptChanges(); griddetallemov.CurrentCell = griddetallemov.Rows[griddetallemov.RowCount - 1].Cells["stockfisico"]; } else { MessageBox.Show("Rollo no Existe en Tabla Inventario !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Rollo no Existe !!! ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void CargarComboFechas() { var BL = new tb_60local_stock_inventario_rollo_cargaBL(); var BE = new tb_60local_stock_inventario_rollo_carga(); var dt = new DataTable(); dt = BL.GetAll_fechas(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { cmb_fechas.DataSource = dt; cmb_fechas.DisplayMember = "fecha"; cmb_fechas.ValueMember = "fecha"; } }