private void Insert() { try { var BE = new tb_cm_liquidacab(); var BL = new tb_cm_liquidacabBL(); BE.tipdoc = tipdoc.Text.Trim(); BE.serdoc = moduloiddes.SelectedValue.ToString(); BE.numdoc = serdoc.Text.Trim() + numdoc.Text.Trim(); BE.moduloid = moduloiddes.SelectedValue.ToString(); BE.local = localdes.SelectedValue.ToString(); BE.tipref = tipguia.Text.Trim(); BE.serref = serguia.Text.Trim(); BE.numref = numguia.Text.Trim(); BE.fecre = Convert.ToDateTime(fechdoc.Text); BE.cif = Convert.ToDecimal(cif.Text.Trim()); BE.dua = Convert.ToDecimal(dua.Text.Trim()); BE.gas_impo = Convert.ToDecimal(gas_impo.Text.Trim()); BE.gas_financ = Convert.ToDecimal(gas_financ.Text.Trim()); BE.tot_bimp = Convert.ToDecimal(tot_bimp.Text.Trim()); BE.factorincre = Convert.ToDecimal(factorincre.Text.Trim()); BE.usuar = VariablesPublicas.Usuar.Trim(); BE.status = "0"; if (TablaDetalleImportacion2 != null) { TablaDetalleImportacion2.Clear(); } for (var i = 0; i < dgb_importacion1.RowCount; i++) { row = TablaDetalleImportacion2.NewRow(); row["tipdoc"] = tipdoc.Text.Trim(); row["serdoc"] = moduloiddes.SelectedValue.ToString(); row["numdoc"] = serdoc.Text.Trim() + numdoc.Text.Trim(); row["conceptoid"] = dgb_importacion1.GetRowCellValue(i, "conceptoid").ToString().Trim(); row["ctacte"] = dgb_importacion1.GetRowCellValue(i, "ctacte").ToString().Trim(); row["tipbou"] = dgb_importacion1.GetRowCellValue(i, "tipbou").ToString().Trim(); row["serbou"] = dgb_importacion1.GetRowCellValue(i, "serbou").ToString().Trim(); row["numbou"] = dgb_importacion1.GetRowCellValue(i, "numbou").ToString().Trim(); var fecha = dgb_importacion1.GetRowCellValue(i, "fechbou").ToString().Trim(); if (fecha.ToString().Trim().Length > 0 && fecha.ToString().Trim() != "-") { row["fechbou"] = dgb_importacion1.GetRowCellValue(i, "fechbou").ToString().Trim(); } row["bimp_sunat2"] = dgb_importacion1.GetRowCellValue(i, "bimp_sunat2").ToString().Trim(); row["tipcamb"] = dgb_importacion1.GetRowCellValue(i, "tipcamb").ToString().Trim(); row["bimp_sunat1"] = dgb_importacion1.GetRowCellValue(i, "bimp_sunat1").ToString().Trim(); row["pven"] = dgb_importacion1.GetRowCellValue(i, "pven").ToString().Trim(); row["status"] = "0".ToString().Trim(); row["usuar"] = VariablesPublicas.Usuar.Trim(); TablaDetalleImportacion2.Rows.Add(row); } if (BL.Insert(EmpresaID, BE, TablaDetalleImportacion2)) { MessageBox.Show("Datos Grabados Correctamente !!!", "InformaciĆ³n", MessageBoxButtons.OK, MessageBoxIcon.Information); form_bloqueado(false); tipdoc.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); } }
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); } }