private void form_cargar_datos(String posicion)
{
try
{
limpiar_documento();
var BL = new tb_cm_liquidacabBL();
var BE = new tb_cm_liquidacab();
var dt = new DataTable();
BE.moduloid = moduloiddes.SelectedValue.ToString();
BE.local = local.Trim();
BE.tipdoc = tipdoc.Text.Trim();
BE.serdoc = moduloiddes.SelectedValue.ToString();
if (serdoc.Text.Trim().Length == 0)
{
if (posicion.Trim().Length > 0)
{
MessageBox.Show("Seleccionar el Tipo de Documento !!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return;
}
var n_doc = string.Empty;
if (numdoc.Text.Trim().Length > 0)
{
n_doc = numdoc.Text.Trim().PadLeft(6, '0');
}
BE.numdoc = serdoc.Text.ToString().Trim() + n_doc.ToString().Trim();
BE.posicion = posicion.Trim();
dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
activeDoc = false;
limpiar_documento();
form_bloqueado(false);
ssModo = "EDIT";
var BL2 = new tb_60movimientoscabBL();
var BE2 = new tb_60movimientoscab();
var dt2 = new DataTable();
var n = dt.Rows[0]["numdoc"].ToString().Trim();
serdoc.Text = Equivalencias.Left(n, 4);
numdoc.Text = Equivalencias.Right(n, 6);
tipguia.Text = dt.Rows[0]["tipref"].ToString().Trim();
serguia.Text = dt.Rows[0]["serref"].ToString().Trim();
numguia.Text = dt.Rows[0]["numref"].ToString().Trim();
cif.Text = dt.Rows[0]["cif"].ToString().Trim();
dua.Text = dt.Rows[0]["dua"].ToString().Trim();
gas_impo.Text = dt.Rows[0]["gas_impo"].ToString().Trim();
gas_financ.Text = dt.Rows[0]["gas_financ"].ToString().Trim();
tot_bimp.Text = dt.Rows[0]["tot_bimp"].ToString().Trim();
factorincre.Text = dt.Rows[0]["factorincre"].ToString().Trim();
moduloiddes.SelectedValue = dt.Rows[0]["moduloid"].ToString().Trim();
data_cbo_localdes(dominioiddes, moduloiddes.SelectedValue.ToString());
localdes.SelectedValue = dt.Rows[0]["local"].ToString().Trim();
BE2.moduloid = moduloiddes.SelectedValue.ToString();
BE2.local = localdes.SelectedValue.ToString();
BE2.tipodoc = tipguia.Text.ToString();
BE2.serdoc = serguia.Text.ToString();
BE2.numdoc = numguia.Text;
dt2 = BL2.GetAll2(EmpresaID, BE2).Tables[0];
if (dt2.Rows.Count > 0)
{
tipfac.Text = dt2.Rows[0]["tipfac"].ToString();
serfac.Text = dt2.Rows[0]["serfac"].ToString();
numfac.Text = dt2.Rows[0]["numfac"].ToString();
tipref.Text = dt2.Rows[0]["tipref"].ToString();
numdococ1.Text = Equivalencias.Left(dt2.Rows[0]["numref"].ToString(), 4);
numdococ.Text = Equivalencias.Right(dt2.Rows[0]["numref"].ToString(), 6);
ctacte.Text = dt2.Rows[0]["ctacte"].ToString();
ctactename.Text = dt2.Rows[0]["ctactename"].ToString();
}
_CargarDetalleImportacion();
if (dt.Rows[0]["status"].ToString().Trim() != "9")
{
btn_nuevo.Enabled = true;
btn_editar.Enabled = true;
btn_eliminar.Enabled = true;
btn_imprimir.Enabled = true;
btn_primero.Enabled = true;
btn_anterior.Enabled = true;
btn_siguiente.Enabled = true;
btn_ultimo.Enabled = true;
btn_salir.Enabled = true;
pictureEdit1.Visible = false;
}
else
{
ssModo = "ANULADO";
if (TablaDetalleImportacion2.Rows.Count > 0)
{
TablaDetalleImportacion2.Clear();
}
dgb_importacion2.DataSource = TablaDetalleImportacion2;
pictureEdit1.Visible = true;
btn_editar.Enabled = false;
btn_eliminar.Enabled = false;
btn_nuevo.Enabled = true;
btn_imprimir.Enabled = true;
btn_primero.Enabled = true;
btn_anterior.Enabled = true;
btn_siguiente.Enabled = true;
btn_ultimo.Enabled = true;
btn_salir.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected internal void numguia_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
var num = string.Empty;
num = numguia.Text.ToString().PadLeft(10, '0');
numguia.Text = num;
var BL = new tb_60movimientoscabBL();
var BE = new tb_60movimientoscab();
var dt = new DataTable();
BE.moduloid = moduloiddes.SelectedValue.ToString();
BE.local = localdes.SelectedValue.ToString();
BE.tipodoc = tipguia.Text.ToString();
BE.serdoc = serguia.Text.ToString();
BE.numdoc = numguia.Text;
dt = BL.GetAll2(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["moneda"].ToString() == "S")
{
MessageBox.Show("Documento de referencia no puede ser en Moneda Nacional, verifique ...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var xfechdoc = Convert.ToDateTime(dt.Rows[0]["fechdoc"]);
if (Convert.ToString(xfechdoc.Year) != serdoc.Text.ToString().Trim())
{
MessageBox.Show("Documento de Referencia NO ES DEL PERIODO ACTUAL, verifique ...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
tipfac.Text = dt.Rows[0]["tipfac"].ToString();
serfac.Text = dt.Rows[0]["serfac"].ToString();
numfac.Text = dt.Rows[0]["numfac"].ToString();
tipref.Text = dt.Rows[0]["tipref"].ToString();
numdococ1.Text = Equivalencias.Left(dt.Rows[0]["numref"].ToString(), 4);
numdococ.Text = Equivalencias.Right(dt.Rows[0]["numref"].ToString(), 6);
ctacte.Text = dt.Rows[0]["ctacte"].ToString();
ctactename.Text = dt.Rows[0]["ctactename"].ToString();
_validaPais();
}
else
{
MessageBox.Show("NO SE UBICÓ documento de referencia ó se encuentra ANULADO, verifique ...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
_CargarDetalle();
if (dt.Rows.Count > 0)
{
for (var i = 0; i < dgb_importacion1.RowCount ; i++)
{
var codi = dgb_importacion1.GetRowCellValue(i, "conceptoid").ToString();
if (codi.Trim() == "101")
{
dgb_importacion1.SetRowCellValue(i, "ctacte", dt.Rows[0]["ctacte"].ToString());
dgb_importacion1.SetRowCellValue(i, "proveedor", dt.Rows[0]["ctactename"].ToString());
dgb_importacion1.SetRowCellValue(i, "tipbou", dt.Rows[0]["tipfac"].ToString());
dgb_importacion1.SetRowCellValue(i, "serbou", dt.Rows[0]["serfac"].ToString());
dgb_importacion1.SetRowCellValue(i, "numbou", dt.Rows[0]["numfac"].ToString());
dgb_importacion1.SetRowCellValue(i, "fechbou", dt.Rows[0]["fechfac"].ToString());
dgb_importacion1.SetRowCellValue(i, "tipcamb", dt.Rows[0]["tcamb"].ToString());
dgb_importacion1.SetRowCellValue(i, "migv", dt.Rows[0]["igv"].ToString());
dgb_importacion1.SetRowCellValue(i, "bimp_sunat2", dt.Rows[0]["valventa"].ToString());
Decimal ximp_me = 0;
Decimal ximp_mn = 0;
Decimal xtcamb = 0;
ximp_me = Convert.ToDecimal(dt.Rows[0]["valventa"].ToString());
xtcamb = Convert.ToDecimal(dt.Rows[0]["tcamb"].ToString());
xvalventa = (ximp_me * xtcamb) + ximp_mn;
dgb_importacion1.SetRowCellValue(i, "pven", xvalventa);
}
}
}
else
{
limpiar_documento();
}
dgb_importacion1.Focus();
}
}