private void _numdoc_Properties_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Enter)
{
String numdo = "";
if (_numdoc.Text.Trim().Length > 0)
{
numdo = _numdoc.Text.Trim().PadLeft(10, '0');
}
_numdoc.Text = numdo;
dgb_codigos.Focus();
Add_Detalle();
tb_me_movimientosdetBL BL = new tb_me_movimientosdetBL();
tb_me_movimientosdet BE = new tb_me_movimientosdet();
DataTable dt = new DataTable();
BE.moduloid = modulo;
BE.local = local;
BE.tipodoc = Equivalencias.Left(cbo_tipodoc.Text,2);
BE.serdoc = _serdoc.Text.Trim();
BE.numdoc = _numdoc.Text.Trim();
dt = BL.GetAll_datosdetalle(EmpresaID, BE).Tables[0];
try
{
if (dt.Rows.Count > 0)
{
int cont = 0;
foreach (DataRow fila in dt.Rows)
{
cont = cont + 1;
if (this.dgb_codigos.RowCount > 0)
{
int nFilaAnt = dgb_codigos.RowCount - 1;
if (cont > 1)
{
TablaProductos = new DataTable();
ArmarTabla();
for (int j = 0; j < dgb_codigos.RowCount; j++)
{
row = TablaProductos.NewRow();
row["productid"] = dgb_codigos.GetRowCellValue(j, "productid").ToString();
row["productname"] = dgb_codigos.GetRowCellValue(j, "productname").ToString();
row["nserie"] = dgb_codigos.GetRowCellValue(j, "nserie").ToString();
row["lineaid"] = dgb_codigos.GetRowCellValue(j, "lineaid").ToString();
row["lineaname"] = dgb_codigos.GetRowCellValue(j, "lineaname").ToString();
row["grupoid"] = dgb_codigos.GetRowCellValue(j, "grupoid").ToString();
row["gruponame"] = dgb_codigos.GetRowCellValue(j, "gruponame").ToString();
row["subgrupoid"] = dgb_codigos.GetRowCellValue(j, "subgrupoid").ToString();
row["subgrupoartic"] = dgb_codigos.GetRowCellValue(j, "subgrupoartic").ToString();
row["cantidad"] = "1".ToString();
TablaProductos.Rows.Add(row);
}
AddRowTable();
mdi_dgbcodigos.DataSource = TablaProductos;
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "productid", fila["productid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "productname", fila["productname"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "nserie", fila["nserie"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "lineaid", fila["lineaid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "lineaname", fila["lineaname"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "grupoid", fila["grupoid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "gruponame", fila["gruponame"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "subgrupoid", fila["subgrupoid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "subgrupoartic", fila["subgrupoartic"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt + 1, "cantidad","1".ToString());
}
else
{
dgb_codigos.SetRowCellValue(nFilaAnt, "productid", fila["productid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "productname", fila["productname"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "nserie", fila["nserie"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "lineaid", fila["lineaid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "lineaname", fila["lineaname"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "grupoid", fila["grupoid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "gruponame", fila["gruponame"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "subgrupoid", fila["subgrupoid"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "subgrupoartic", fila["subgrupoartic"].ToString());
dgb_codigos.SetRowCellValue(nFilaAnt, "cantidad", "1".ToString());
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void data_Tabladetallemovmov()
{
_cal_Igv();
try
{
Decimal xxprecventa = 0, xxcostoultimo = 0, xxstock = 0, xxcostopromed = 0;
griddetallemov.AutoGenerateColumns = false;
tb_me_movimientosdetBL BL = new tb_me_movimientosdetBL();
tb_me_movimientosdet BE = new tb_me_movimientosdet();
DataTable dt = new DataTable();
BE.moduloid = modulo;
BE.local = local;
BE.tipodoc = tipodoc.SelectedValue.ToString().Trim();
BE.serdoc = serdoc.Text.Trim().PadLeft(4, '0');
BE.numdoc = numdoc.Text.Trim().PadLeft(6, '0');
dt = BL.GetAll_datosdetalle(EmpresaID, BE).Tables[0];
//datos incluido IGV
if (dt.Rows.Count > 0)
{
statcostopromed = dt.Rows[0]["statcostopromed"].ToString();
tiptransac = dt.Rows[0]["tiptransac"].ToString();
incprec = dt.Rows[0]["incprec"].ToString().Trim();
//tipoperef = dt.Rows[0]["tipoperef"].ToString();
}
if (Tabladetallemov != null)
{
Tabladetallemov.Clear();
}
foreach (DataRow fila in dt.Rows)
{
tb_me_local_stockBL BL2 = new tb_me_local_stockBL();
tb_me_local_stock BE2 = new tb_me_local_stock();
DataTable dt2 = new DataTable();
BE2.moduloid = modulo;
BE2.local = local;
BE2.productid = fila["productid"].ToString();
dt2.Clear();
dt2 = BL2.GetAll(EmpresaID, BE2).Tables[0];
if (dt2.Rows.Count > 0)
{
if (almacaccionid.Trim() == "20" || almacaccionid.Trim() == "21")
{
lbl_valor.Text = "Cost.Prom";
xxprecventa = 0;// Convert.ToDecimal(dt2.Rows[0]["precventa"]);
xxcostopromed = Convert.ToDecimal(dt2.Rows[0]["costopromed"]);
}
else if (almacaccionid.Trim() == "10" || almacaccionid.Trim() == "11")
{
lbl_valor.Text = "Cost.Ultm";
xxcostoultimo = Convert.ToDecimal(dt2.Rows[0]["costoultimo"]);
}
xxstock = Convert.ToDecimal(dt2.Rows[0]["stock"]);
}
row = Tabladetallemov.NewRow();
row["itemref"] = fila["itemref"].ToString();
row["items"] = fila["items"].ToString();
row["productid"] = fila["productid"].ToString().Trim();
row["productname"] = fila["productname"].ToString().Trim();
row["rollo"] = fila["rollo"].ToString();
row["stock"] = xxstock;
row["stock_old"] = xxstock;
row["precventa"] = xxprecventa;
row["costoultimo"] = xxcostoultimo;
row["costopromed"] = xxcostopromed;
//row["cantidad"] = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4);
//row["cantidad_c"] = Math.Round(Convert.ToDecimal(fila["cantidad_c"]), 4);
Decimal cantidad = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4);
Decimal cantidadcta = Math.Round(Convert.ToDecimal(fila["cantidadcta"]), 4);
Decimal total;
total = cantidad - cantidadcta;
row["cantidad"] = total;
//row["cantidad_old"] = Math.Round(Convert.ToDecimal(fila["cantidad"]), 4);
row["cantidad_old"] = Convert.ToDecimal(fila["cantidad"]);
row["precunit"] = Math.Round(Convert.ToDecimal(Convert.ToDecimal(fila["precunit"]).ToString("###,###,##0.000000")), 6);
row["importfac"] = Math.Round(Convert.ToDecimal(fila["importfac"]), 2);
row["valor"] = Math.Round(Convert.ToDecimal(fila["valor"]), 6);
row["importe"] = Math.Round(Convert.ToDecimal(fila["importe"]), 6);
row["totimpto"] = Math.Round(Math.Round(Convert.ToDecimal(fila["importe"]), 6) * (Convert.ToDecimal(igv) / 100), 6);
row["almacaccionid"] = almacaccionid.Trim();
row["unmed"] = fila["unmed"].ToString().Trim();
row["nserie"] = fila["nserie"].ToString().Trim();
row["ubicacion"] = fila["ubicacion"].ToString().Trim();
row["nostock"] = xnostock;
Tabladetallemov.Rows.Add(row);
}
griddetallemov.DataSource = Tabladetallemov;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
