private void FgItems_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (FgItems.Col == 1) { //int n_idtipexi = 0; DataTable dtResul = new DataTable(); string c_dato = ""; dtResul = funDatos.DataTableFiltrar(dtItem, "n_idtipexi IN (1, 2)"); dtResul = objIte.BuscarItem("", "n_id", dtResul, 2); if (dtResul != null) { if (dtResul.Rows.Count != 0) { c_dato = dtResul.Rows[0]["c_despro"].ToString(); // MOSTRAMOS LA DESCRIPCION DEL ITEM FgItems.SetData(FgItems.Row, 1, c_dato); c_dato = dtResul.Rows[0]["n_id"].ToString(); // MOSTRAMOS EL ID DEL ITEM FgItems.SetData(FgItems.Row, 2, c_dato); FgItems.Rows.Count = FgItems.Rows.Count + 1; } } } }
void VerRegistro(Int64 n_IdRegistro) { objMovimientos.mysConec = mysConec; BE_Movimiento = objMovimientos.TraerRegistro(n_IdRegistro); txtFchIng.Text = BE_Movimiento.d_fching.ToString(); TxtFchDoc.Text = BE_Movimiento.d_fchdoc.ToString(); CboTipDoc.SelectedValue = BE_Movimiento.n_idtipdoc; TxtNumDoc.Text = BE_Movimiento.c_numdoc; TxtNumSer.Text = BE_Movimiento.c_numser; CboProveedor.SelectedValue = BE_Movimiento.n_idclipro; CboAlmacen.SelectedValue = BE_Movimiento.n_idalm; TxtObs.Text = BE_Movimiento.c_obs; funFlex.FlexMostrarDatos(FgItems, arrCabeceraFlex1, BE_Movimiento.lst_items, 2, false); int n_fila = 2; foreach (BE_ALM_MOVIMIENTOSDET_CONSULTA element in BE_Movimiento.lst_items) { FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(n_fila, 1, element.c_tipexides); FgItems.SetData(n_fila, 2, element.c_itedes); FgItems.SetData(n_fila, 3, element.c_itepredes); FgItems.SetData(n_fila, 4, element.n_can); n_fila++; } }
void VerRegistro(int n_IdRegistro) { objTransferencias.mysConec = mysConec; BE_Transferencia = objTransferencias.TraerRegistro(n_IdRegistro); txtFchIng.Text = BE_Transferencia.d_fching.ToString(); TxtFchDoc.Text = BE_Transferencia.d_fchdoc.ToString(); TxtNumDoc.Text = BE_Transferencia.c_numdoc; TxtNumSer.Text = BE_Transferencia.c_numser; CboAlmacenOrigen.SelectedValue = BE_Transferencia.n_idalmorig; CboAlmacenDestino.SelectedValue = BE_Transferencia.n_idalmdest; TxtObs.Text = BE_Transferencia.c_obs; CboResponsable.SelectedValue = BE_Transferencia.n_idresp; funFlex.FlexMostrarDatos(FgItems, arrCabeceraFlex1, BE_Transferencia.lst_items, 2, false); int n_fila = 2; foreach (BE_ALM_TRANSFERENCIASDET element in BE_Transferencia.lst_items) { FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(n_fila, 1, element.c_tipexides); FgItems.SetData(n_fila, 2, element.c_itedes); FgItems.SetData(n_fila, 3, element.c_itepredes); FgItems.SetData(n_fila, 4, element.c_numlot); FgItems.SetData(n_fila, 6, element.n_can); FgItems.SetData(n_fila, 7, element.n_preuni); FgItems.SetData(n_fila, 8, element.n_pretot); FgItems.SetData(n_fila, 9, element.h_horsal); n_fila++; } }
private void FgItems_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (booAgregando == true) { return; } if (n_QueHace == 3) { return; } if (e.Col == 6) { string c_valor = FgItems.GetData(FgItems.Row, 6).ToString(); FgItems.SetData(FgItems.Row, 7, Convert.ToDouble(c_valor).ToString("0.00")); Calcular(FgItems.Row); } if (e.Col == 7) { string c_valor = FgItems.GetData(FgItems.Row, 7).ToString(); FgItems.SetData(FgItems.Row, 6, Convert.ToDouble(c_valor).ToString("0.00")); Calcular(FgItems.Row); } SumarColumnas(); }
private void FgItems_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (n_QueHace == 3) { return; } double n_valor = 0; double n_precio = 0; double n_tasigv = 0; if (FgItems.Col == 4) { n_valor = Convert.ToDouble(FgItems.GetData(e.Row, 4)); n_tasigv = Convert.ToDouble(FgItems.GetData(e.Row, 5)); n_precio = n_valor * ((n_tasigv / 100) + 1); FgItems.SetData(e.Row, 6, n_precio.ToString("0.00")); } if (FgItems.Col == 6) { n_valor = Convert.ToDouble(FgItems.GetData(e.Row, 6)); n_tasigv = Convert.ToDouble(FgItems.GetData(e.Row, 5)); n_precio = n_valor / ((n_tasigv / 100) + 1); FgItems.SetData(e.Row, 4, n_precio.ToString("0.00")); } }
private void FgItems_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (n_QueHace == 3) { return; } if (booAgregando == true) { return; } if (Convert.ToDouble(funFunciones.NulosN(LblTc.Text)) == 0) { MessageBox.Show("! No ha especificado el tipo de cambio ", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); return; } if (FgItems.Col == 1) { DataTable dtResult = new DataTable(); dtResult = objPlaCue.BuscarCuenta(dtPlaCue); if (dtResult != null) { FgItems.SetData(FgItems.Row, 1, dtResult.Rows[0]["c_cuecon"].ToString()); FgItems.SetData(FgItems.Row, 2, dtResult.Rows[0]["c_des"].ToString()); FgItems.SetData(FgItems.Row, 7, dtResult.Rows[0]["n_id"].ToString()); } } }
void MostrarPedidos() { int n_row = 0; CN_vta_pedidocen miFun = new CN_vta_pedidocen(); DataTable dtLista = new DataTable(); miFun.mysConec = mysConec; b_agregando = true; miFun.TraerPendienteEnvio(STU_SISTEMA.EMPRESAID, STU_SISTEMA.MESTRABAJO, STU_SISTEMA.ANOTRABAJO); dtLista = miFun.dtLista; if (dtLista.Rows.Count == 0) { MessageBox.Show("¡ No hay pedidos pendiente, no se puede emitir guias !", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); return; } FgItems.Rows.Count = 2; for (n_row = 0; n_row <= dtLista.Rows.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(FgItems.Rows.Count - 1, 1, dtLista.Rows[n_row]["c_numped"].ToString()); FgItems.SetData(FgItems.Rows.Count - 1, 2, dtLista.Rows[n_row]["d_fchemi"].ToString()); FgItems.SetData(FgItems.Rows.Count - 1, 3, dtLista.Rows[n_row]["d_fchent"].ToString()); FgItems.SetData(FgItems.Rows.Count - 1, 4, dtLista.Rows[n_row]["c_punvendes"].ToString()); FgItems.SetData(FgItems.Rows.Count - 1, 5, dtLista.Rows[n_row]["c_punentdes"].ToString()); FgItems.SetData(FgItems.Rows.Count - 1, 10, dtLista.Rows[n_row]["n_id"].ToString()); FgItems.SetData(FgItems.Rows.Count - 1, 11, dtLista.Rows[n_row]["n_idcli"].ToString()); } TxtPunVen.Text = FgItems.GetData(FgItems.Row, 4).ToString(); TxtPunEnt.Text = FgItems.GetData(FgItems.Row, 5).ToString(); b_agregando = false; }
private void FgItems_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (FgItems.Col == 1) { int n_idtipexi = 0; DataTable dtResul = new DataTable(); string c_dato = ""; b_Agregando = true; dtResul = objItems.BuscarItem("", "n_id", dtItems, n_idtipexi); if (dtResul != null) { if (dtResul.Rows.Count != 0) { c_dato = dtResul.Rows[0]["c_despro"].ToString(); // MOSTRAMOS LA DESCRIPCION DEL ITEM FgItems.SetData(FgItems.Row, 1, c_dato); c_dato = dtResul.Rows[0]["n_id"].ToString(); // MOSTRAMOS EL ID DEL ITEM FgItems.SetData(FgItems.Row, 4, c_dato); c_dato = dtResul.Rows[0]["n_idunimed"].ToString(); // MOSTRAMOS LA UNIDAD DE MEDIDA DEL ITEM FgItems.SetData(FgItems.Row, 5, c_dato); } } b_Agregando = false; } }
void Calcular(int n_row) { double n_valor = Convert.ToDouble(FgItems.GetData(n_row, 7).ToString()); double n_tasa = Convert.ToDouble(TxtTasRet.Text); n_valor = (n_valor * (n_tasa / 100)); FgItems.SetData(n_row, 9, n_valor.ToString("0.00")); }
private void FgItems_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (FgItems.Col == 2) { int n_idtipexi = 3; DataTable dtResul = new DataTable(); string c_dato = ""; // OBTNEMOS LA DESCRIPCION DEL TIPO DE PRODUCTO string strDesTipPro = funFunciones.NulosC(FgItems.GetData(FgItems.Row, 1)); if (strDesTipPro == "") { n_idtipexi = 0; } // OBTENEMOS EL ID DEL TIPO DE PRODUCTO dtResul = funDatos.DataTableFiltrar(dtTipoExis, "c_des = '" + strDesTipPro + "'"); if (dtResul.Rows.Count != 0) { n_idtipexi = Convert.ToInt32(dtResul.Rows[0]["n_id"].ToString()); } booAgregando = true; dtResul = objItems.BuscarItem("", "n_id", dtItems, n_idtipexi); if (dtResul != null) { if (dtResul.Rows.Count != 0) { c_dato = dtResul.Rows[0]["c_despro"].ToString(); // MOSTRAMOS LA DESCRIPCION DEL ITEM FgItems.SetData(FgItems.Row, 2, c_dato); c_dato = dtResul.Rows[0]["n_id"].ToString(); // MOSTRAMOS LA PRESENTACION DEL ITEM c_dato = funDatos.DataTableBuscar(dtPresentaItem, "n_idite", "c_abrpre", c_dato, "N").ToString(); FgItems.SetData(FgItems.Row, 3, c_dato); } } booAgregando = false; } if (n_QueHace == 3) { FgItems.AllowEditing = false; return; } if (booAgregando == true) { return; } if (FgItems.Col == 5) { FgItems.Select(FgItems.Row - 1, 2); return; } }
void VerRegistro(Int64 n_IdRegistro) { objMovimientos.mysConec = mysConec; BE_Movimiento = objMovimientos.TraerRegistro(n_IdRegistro); CboProveedor.SelectedValue = BE_Movimiento.n_idpro; TxtFchEmi.Text = BE_Movimiento.f_fchdoc.ToString(); CboMoneda.SelectedValue = BE_Movimiento.n_idmon; CboTipDoc.SelectedValue = BE_Movimiento.n_idtipdoc; TxtNumDoc.Text = BE_Movimiento.c_numdoc; TxtNumSer.Text = BE_Movimiento.c_numser; CboTipPro.SelectedValue = BE_Movimiento.n_idtippro; CboCondPag.SelectedValue = BE_Movimiento.n_idconpag; TxtFchVen.Text = BE_Movimiento.f_fchven.ToString(); TxtGlosa.Text = BE_Movimiento.c_glosa; LblTipCam.Text = BE_Movimiento.n_tc.ToString("0.00"); TxtImp1.Text = BE_Movimiento.n_impbru.ToString("0.00"); TxtImp2.Text = BE_Movimiento.n_impbru2.ToString("0.00"); TxtImp3.Text = BE_Movimiento.n_impbru3.ToString("0.00"); TxtImp4.Text = BE_Movimiento.n_impinaf.ToString("0.00"); TxtIgv1.Text = BE_Movimiento.n_impigv.ToString("0.00"); TxtIgv2.Text = BE_Movimiento.n_impigv2.ToString("0.00"); TxtIgv3.Text = BE_Movimiento.n_impigv3.ToString("0.00"); TxtOtrCarg.Text = BE_Movimiento.n_impotr.ToString("0.00"); TxtISC.Text = BE_Movimiento.n_impisc.ToString("0.00"); TxtTotal.Text = BE_Movimiento.n_imptotcom.ToString("0.00"); intTasaIGV = BE_Movimiento.n_tasaigv; funFlex.FlexMostrarDatos(FgItems, arrCabeceraFlex1, BE_Movimiento.lst_items, 2, false); int n_fila = 2; foreach (BE_COM_COMPRASDET_CONSULTA element in BE_Movimiento.lst_items) { FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(n_fila, 1, element.c_despro); FgItems.SetData(n_fila, 2, element.c_desprepro); FgItems.SetData(n_fila, 3, element.n_canpro.ToString("0.00")); FgItems.SetData(n_fila, 4, element.n_preuni.ToString("0.000000")); FgItems.SetData(n_fila, 6, element.n_imptot.ToString("0.00")); FgItems.SetData(n_fila, 13, element.n_idtipcom.ToString()); FgItems.SetData(n_fila, 14, element.n_iditem.ToString()); FgItems.SetData(n_fila, 15, element.n_idunimed.ToString()); n_fila++; } }
private void FgItems_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (n_QueHace == 3) { return; } //if ((FgItems.Col == 12) || (FgItems.Col == 13) || (FgItems.Col == 14)) if (FgItems.Col == 14) { double n_valor = Convert.ToDouble(funFunciones.NulosN(FgItems.GetData(FgItems.Row, 14))); double n_impbru = (n_valor / 1.18); double n_impigv = (n_valor - (n_valor / 1.18)); FgItems.SetData(FgItems.Row, 12, n_impbru.ToString("0.00")); FgItems.SetData(FgItems.Row, 13, n_impigv.ToString("0.00")); } }
void VerRegistro(int n_IdRegistro) { int n_fil = 0; string c_dato = ""; DataTable dtresult = new DataTable(); int n_idcli = Convert.ToInt32(DgLista.Columns["n_id"].CellValue(DgLista.Row).ToString()); // OBTENEMOS EL ID DEL REGISTRO QUE SE DESEA ELIMINAR CN_mae_cliproitems o_items = new CN_mae_cliproitems(); o_items.mysConec = mysConec; o_items.Listar(n_idcli); dtresult = o_items.dtListar; objRegistros.mysConec = mysConec; BE_Registro = objRegistros.TraerRegistro(n_IdRegistro); CboDocIde.SelectedValue = BE_Registro.n_idtipdoc; TxtNumDocIde.Text = BE_Registro.c_numdoc; TxtNomEmp.Text = BE_Registro.c_nombre; FgItems.Rows.Count = 2; for (n_fil = 0; n_fil <= dtresult.Rows.Count - 1; n_fil++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = dtresult.Rows[n_fil]["c_codpro"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = dtresult.Rows[n_fil]["c_despro"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = dtresult.Rows[n_fil]["c_abrpre"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); c_dato = Convert.ToDouble(dtresult.Rows[n_fil]["n_prebru"]).ToString("0.00000"); FgItems.SetData(FgItems.Rows.Count - 1, 4, c_dato); c_dato = Convert.ToDouble(dtresult.Rows[n_fil]["n_tasigv"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); c_dato = Convert.ToDouble(dtresult.Rows[n_fil]["n_prenet"]).ToString("0.000000"); FgItems.SetData(FgItems.Rows.Count - 1, 6, c_dato); c_dato = Convert.ToInt32(dtresult.Rows[n_fil]["n_idite"]).ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 7, c_dato); } }
void ListarEstado() { if (Convert.ToInt32(CboModulo.SelectedValue) == 0) { return; } int n_idmodulo = Convert.ToInt32(CboModulo.SelectedValue); int n_row = 0; string c_dato = ""; int n_valor = 0; if (n_idmodulo == 0) { return; } FgItems.Rows.Count = 2; DataTable dtresult = new DataTable(); dtresult = funDatos.DataTableFiltrar(dtLista, "n_idmod = " + n_idmodulo.ToString() + ""); if (dtresult.Rows.Count != 0) { for (n_row = 0; n_row <= dtresult.Rows.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = dtresult.Rows[n_row]["c_mesdes"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); n_valor = Convert.ToInt32(dtresult.Rows[n_row]["n_estado"]); if (n_valor == 0) { FgItems.SetData(FgItems.Rows.Count - 1, 2, false); } if (n_valor == 1) { FgItems.SetData(FgItems.Rows.Count - 1, 2, true); } c_dato = dtresult.Rows[n_row]["n_idmes"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); } } }
void ConfigurarFlex() { booAgregando = true; FgItems.Rows.Count = 2; FgItems.Rows.Count = 14; FgItems.SetData(2, 1, "ENERO"); FgItems.SetData(3, 1, "FEBRERO"); FgItems.SetData(4, 1, "MARZO"); FgItems.SetData(5, 1, "ABRIL"); FgItems.SetData(6, 1, "MAYO"); FgItems.SetData(7, 1, "JUNIO"); FgItems.SetData(8, 1, "JULIO"); FgItems.SetData(9, 1, "AGOSTO"); FgItems.SetData(10, 1, "SETIEMBRE"); FgItems.SetData(11, 1, "OCTUBRE"); FgItems.SetData(12, 1, "NOVIEMBRE"); FgItems.SetData(13, 1, "DICIEMBRE"); booAgregando = false; }
private void FgItems_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (n_QueHace == 3) { FgItems.AllowEditing = false; return; } if (booAgregando == true) { return; } string c_dato = ""; if (FgItems.Col == 3) { c_dato = FgItems.GetData(FgItems.Row, 3).ToString(); c_dato = (Convert.ToDouble(c_dato) / Convert.ToDouble(LblTc.Text)).ToString("0.00"); FgItems.SetData(FgItems.Row, 5, c_dato); } if (FgItems.Col == 4) { c_dato = FgItems.GetData(FgItems.Row, 4).ToString(); c_dato = (Convert.ToDouble(c_dato) / Convert.ToDouble(LblTc.Text)).ToString("0.00"); FgItems.SetData(FgItems.Row, 6, c_dato); } if (FgItems.Col == 5) { c_dato = FgItems.GetData(FgItems.Row, 5).ToString(); c_dato = (Convert.ToDouble(c_dato) * Convert.ToDouble(LblTc.Text)).ToString("0.00"); FgItems.SetData(FgItems.Row, 3, c_dato); } if (FgItems.Col == 6) { c_dato = FgItems.GetData(FgItems.Row, 6).ToString(); c_dato = (Convert.ToDouble(c_dato) * Convert.ToDouble(LblTc.Text)).ToString("0.00"); FgItems.SetData(FgItems.Row, 4, c_dato); } SumarColumnas(); }
private void FgItems_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (n_QueHace == 3) { FgItems.AllowEditing = false; return; } DataTable dtResul = new DataTable(); string c_dato = ""; if (b_Agregando == true) { return; } if (FgItems.Col == 1) { // FILTRAMOS LAS PRESENTACIONES DEL ITEM SELECCIONADO c_dato = FgItems.GetData(FgItems.Row, 4).ToString(); // OBTENEMOS EL ID DEL ITEM dtResul = funDatos.DataTableFiltrar(dtUniMed, "n_idite = " + c_dato + ""); funFlex.FlexColumnaCombo(FgItems, dtResul, "c_abrpre", 2); // UNIDADES DEL MEDIDA DEL ITEMS FgItems.AllowEditing = true; FgItems.Select(FgItems.Row - 1, 2); return; } if (FgItems.Col == 2) { CalcularTotalFila(); FgItems.Select(FgItems.Row - 1, 4); return; } if (FgItems.Col == 4) { FgItems.Select(FgItems.Row - 1, 1); FgItems.SetData(FgItems.Row + 1, 1, FgItems.GetData(FgItems.Row, 1)); return; } }
void CalcularTotalFila() { double n_importe = Convert.ToDouble(FgItems.GetData(FgItems.Row, 2)); double n_impuesto = 0; b_Agregando = true; FgItems.SetData(FgItems.Row, 3, n_importe.ToString("0.00")); TxtImponible.Text = n_importe.ToString("0.00"); if (ChkAfecto.Checked == true) { n_impuesto = ((n_importe * ((n_por4ta / 100) + 1)) - n_importe); TxtImpuesto.Text = n_impuesto.ToString("0.00"); } else { TxtImpuesto.Text = "0.00"; } TxtImpTot.Text = (n_importe - n_impuesto).ToString("0.00"); b_Agregando = false; }
private void FgItems_KeyUp(object sender, KeyEventArgs e) { if (FgItems.Col == 1) { if (e.KeyCode.ToString() == "Delete") { booAgregando = true; FgItems.SetData(FgItems.Row, 1, ""); FgItems.SetData(FgItems.Row, 2, ""); FgItems.SetData(FgItems.Row, 3, ""); FgItems.SetData(FgItems.Row, 4, ""); FgItems.SetData(FgItems.Row, 5, ""); FgItems.SetData(FgItems.Row, 6, ""); //Calcularfila(FgItems.Row); booAgregando = false; } } if (e.KeyCode.ToString() == "Insert") { if (funFunciones.NulosC(FgItems.GetData(FgItems.Rows.Count - 1, 1)) == "") { return; } FgItems.Rows.Count = FgItems.Rows.Count + 1; } if (e.KeyCode.ToString() == "Delete") { if (FgItems.Rows.Count <= 2) { return; } FgItems.RemoveItem(FgItems.Row); } }
private void CmdAddItem_Click(object sender, EventArgs e) { int n_row = 0; DataTable dtResult = new DataTable(); CN_alm_inventario o_item = new CN_alm_inventario(); string c_dato = ""; o_item.mysConec = mysConec; string c_cadIN = funFlex.Flex_ObtenerDatosCol(FgItems, 7); dtResult = o_item.FiltrarSelccionarItems(STU_SISTEMA.EMPRESAID, c_cadIN); if (dtResult != null) { if (dtResult.Rows.Count != 0) { for (n_row = 0; n_row <= dtResult.Rows.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = dtResult.Rows[n_row]["c_codpro"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = dtResult.Rows[n_row]["c_despro"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = dtResult.Rows[n_row]["c_abrpre"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); FgItems.SetData(FgItems.Rows.Count - 1, 4, "0.00"); c_dato = "18.00"; FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); FgItems.SetData(FgItems.Rows.Count - 1, 6, "0.00"); c_dato = Convert.ToInt32(dtResult.Rows[n_row]["n_id"]).ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 7, c_dato); } } } }
void VerRegistro(int n_IdRegistro) { string c_dato = ""; int n_dato = 0; booAgregando = true; Blanquea(); FgItems.Rows.Count = 2; objRegistros.mysConec = mysConec; objRegistros.TraerRegistro(n_IdRegistro); entRegistro = objRegistros.entRegistro; LstDetalle = objRegistros.LstDetalle; TxtFchDes.Text = ""; TxtNumOrd.Text = entRegistro.c_numped; c_dato = entRegistro.c_codcli; c_dato = funDatos.DataTableBuscar(dtCliPro, "c_codcen", "c_nombre", c_dato, "C").ToString(); TxtCliente.Text = c_dato; c_dato = entRegistro.c_codcli; c_dato = funDatos.DataTableBuscar(dtCliPro, "c_codcen", "n_id", c_dato, "C").ToString(); LblIdCliente.Text = c_dato; c_dato = entRegistro.c_codpunven; //c_dato = funDatos.DataTableBuscar(dtPunVen, "c_codcen", "c_des", c_dato, "C").ToString(); TxtPunVen.Text = c_dato; c_dato = entRegistro.c_codpunven; n_dato = Convert.ToInt32(funDatos.DataTableBuscar(dtPunVen, "c_codcen", "n_id", c_dato, "C")); CboPunVen.SelectedValue = n_dato; c_dato = entRegistro.c_codpunent; //c_dato = funDatos.DataTableBuscar(dtPunVen, "c_codcen", "c_des", c_dato, "C").ToString(); TxtLugEnt.Text = c_dato; c_dato = entRegistro.c_codpunent; n_dato = Convert.ToInt32(funDatos.DataTableBuscar(dtPunVen, "c_codcen", "n_id", c_dato, "C")); CboPunlle.SelectedValue = n_dato; TcxtFchPed.Text = Convert.ToDateTime(entRegistro.d_fchemi).ToString("dd/MM/yyyy"); TxtFchEnt.Text = Convert.ToDateTime(entRegistro.d_fchent).ToString("dd/MM/yyyy"); double n_can = 0; string c_idite = ""; foreach (BE_VTA_PEDIDOCENDET element in LstDetalle) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = element.c_coditecen; n_can = element.n_canpro; FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_idite = funDatos.DataTableBuscar(dtItemCen, "c_codcen", "n_iditem", c_dato, "C").ToString(); c_dato = funDatos.DataTableBuscar(dtItems, "n_id", "c_despro", c_idite, "N").ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = funDatos.DataTableBuscar(dtPresentaItem, "n_idite", "c_abrpre", c_idite, "N").ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); FgItems.SetData(FgItems.Rows.Count - 1, 4, n_can.ToString("0.00")); } booAgregando = false; }
void VerRegistro(int n_IdRegistro) { int n_row = 0; string c_dato = ""; double n_valor = 0; objRegistros.mysConec = mysConec; objRegistros.TraerRegistro(n_IdRegistro); e_Proviciones = objRegistros.e_Provicion; l_ProvicionesDet = objRegistros.l_ProvicionDet; CboLib.SelectedValue = e_Proviciones.n_idlib; CboSubLib.SelectedValue = e_Proviciones.n_idsublib; CboMon.SelectedValue = e_Proviciones.n_idmon; TxtFchDoc.Text = e_Proviciones.d_fchdoc.ToString("dd/MM/yyyy"); CboTipDoc.SelectedValue = e_Proviciones.n_idtipdoc; TxtNumSer.Text = e_Proviciones.c_numser; TxtNumDoc.Text = e_Proviciones.c_numdoc; TxtGlosa.Text = e_Proviciones.c_glosa; LblNumRegCon.Text = e_Proviciones.c_numreg; LblTc.Text = e_Proviciones.n_tc.ToString("0.000"); FgItems.Rows.Count = 2; booAgregando = true; for (n_row = 0; n_row <= l_ProvicionesDet.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = funDatos.DataTableBuscar(dtPlaCue, "n_id", "c_cuecon", l_ProvicionesDet[n_row].n_idcuecon.ToString(), "N").ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = funDatos.DataTableBuscar(dtPlaCue, "n_id", "c_des", l_ProvicionesDet[n_row].n_idcuecon.ToString(), "N").ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); //if (e_Proviciones.n_idmon == 115) //{ // MOSTRANOS EL DATO EN SOLES Y HACEMOS LA CONVERCION A DOLARES if (l_ProvicionesDet[n_row].n_tipo == 1) { FgItems.SetData(FgItems.Rows.Count - 1, 3, l_ProvicionesDet[n_row].n_impsol.ToString("0.00")); FgItems.SetData(FgItems.Rows.Count - 1, 4, "0.00"); //n_valor =(l_ProvicionesDet[n_row].n_importe / e_Proviciones.n_tc); FgItems.SetData(FgItems.Rows.Count - 1, 5, l_ProvicionesDet[n_row].n_impdol.ToString("0.00")); FgItems.SetData(FgItems.Rows.Count - 1, 6, "0.00"); } else { FgItems.SetData(FgItems.Rows.Count - 1, 3, "0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 4, l_ProvicionesDet[n_row].n_impsol.ToString("0.00")); //n_valor = (l_ProvicionesDet[n_row].n_importe / e_Proviciones.n_tc); FgItems.SetData(FgItems.Rows.Count - 1, 5, "0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 6, l_ProvicionesDet[n_row].n_impdol.ToString("0.00")); } //} //else //{ // // MOSTRANOS EL DATO EN DOLARES Y HACEMOS LA CONVERCION A SOLES // if (l_ProvicionesDet[n_row].n_tipo == 1) // { // FgItems.SetData(FgItems.Rows.Count - 1, 5, l_ProvicionesDet[n_row].n_importe.ToString("0.00")); // FgItems.SetData(FgItems.Rows.Count - 1, 6, "0.00"); // n_valor = (l_ProvicionesDet[n_row].n_importe / e_Proviciones.n_tc); // FgItems.SetData(FgItems.Rows.Count - 1, 3, n_valor.ToString("0.00")); // FgItems.SetData(FgItems.Rows.Count - 1, 4, "0.00"); // } // else // { // FgItems.SetData(FgItems.Rows.Count - 1, 5, "0.00"); // FgItems.SetData(FgItems.Rows.Count - 1, 6, l_ProvicionesDet[n_row].n_importe.ToString("0.00")); // n_valor = (l_ProvicionesDet[n_row].n_importe / e_Proviciones.n_tc); // FgItems.SetData(FgItems.Rows.Count - 1, 3, "0.00"); // FgItems.SetData(FgItems.Rows.Count - 1, 4, n_valor.ToString("0.00")); // } //} } booAgregando = false; SumarColumnas(); }
void VerRegistro(int n_IdRegistro) { int n_row = 0; string c_dato = ""; DataTable dtDet = new DataTable(); DataTable dtres = new DataTable(); objRegistros.mysConec = mysConec; objRegistros.TraerRegistro(n_IdRegistro); e_Ret = objRegistros.e_Retencion; dtDet = objRegistros.dtDetalle; booAgregando = true; LblIdPro.Text = e_Ret.n_idcli.ToString(); TxtPro.Text = funDatos.DataTableBuscar(dtPro, "n_id", "c_nombre", LblIdPro.Text, "N").ToString(); TxtTc.Text = e_Ret.n_tc.ToString("0.000"); TxtFchEmi.Text = e_Ret.d_fchemi.ToString(); TxtNumSer.Text = e_Ret.c_numser; TxtNumDoc.Text = e_Ret.c_numdoc; CboMon.SelectedValue = e_Ret.n_idmon; TxtTc.Text = e_Ret.n_tc.ToString("0.000"); CboTipRet.SelectedValue = e_Ret.n_idret; TxtTasRet.Text = e_Ret.n_tas.ToString("0.00"); TxtGlo.Text = e_Ret.c_glo; LblNumAsi.Text = e_Ret.c_numreg; // OBTENEMOS EL ID DE LA CUENTA DEL DOCUMENTO dtres = funDatos.DataTableFiltrar(dtdoc, "n_idtipdoc = 21 AND n_idmon = " + Convert.ToInt32(CboMon.SelectedValue).ToString() + " AND n_idemp = " + STU_SISTEMA.EMPRESAID.ToString() + ""); if (dtres.Rows.Count != 0) { N_CTADOC = Convert.ToInt32(dtres.Rows[0]["n_idcueven"]); } // OBTENEMOS EL ID DE LA CUENTA DEL IGV dtres = funDatos.DataTableFiltrar(dtdocimp, "n_idtipdoc = 21 AND n_idemp = " + STU_SISTEMA.EMPRESAID.ToString() + ""); if (dtres.Rows.Count != 0) { N_CTAIGV = Convert.ToInt32(dtres.Rows[0]["n_idcueven"]); } FgItems.Rows.Count = 2; for (n_row = 0; n_row <= dtDet.Rows.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = dtDet.Rows[n_row]["c_numdoc"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = dtDet.Rows[n_row]["c_desmon"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = dtDet.Rows[n_row]["c_docdes"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); c_dato = Convert.ToDateTime(dtDet.Rows[n_row]["d_fchdoc"]).ToString("dd/MM/yyyy"); FgItems.SetData(FgItems.Rows.Count - 1, 4, c_dato); c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_imptotven"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impcob"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 6, c_dato); c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impcob"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 7, c_dato); c_dato = TxtTasRet.Text; FgItems.SetData(FgItems.Rows.Count - 1, 8, c_dato); c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impret"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 9, c_dato); c_dato = dtDet.Rows[n_row]["n_iddoc"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 10, c_dato); } booAgregando = false; SumarColumnas(); }
void MostrarDocVenta() { string[,] arrCabeceraDg1 = new string[8, 5]; CN_vta_ventas objVenta = new CN_vta_ventas(); DataTable DtVentas = new DataTable(); DataTable dtResult = new DataTable(); DataTable dtresulpre = new DataTable(); DataTable dtItemFiltro = new DataTable(); objVenta.mysConec = mysConec; DtVentas = objVenta.DocumentosRetencion(STU_SISTEMA.EMPRESAID, Convert.ToInt32(LblIdPro.Text)); arrCabeceraDg1[0, 0] = "T.D."; arrCabeceraDg1[0, 1] = "40"; arrCabeceraDg1[0, 2] = "C"; arrCabeceraDg1[0, 3] = ""; arrCabeceraDg1[0, 4] = "c_tipdoc"; arrCabeceraDg1[1, 0] = "Nº Documento"; arrCabeceraDg1[1, 1] = "100"; arrCabeceraDg1[1, 2] = "C"; arrCabeceraDg1[1, 3] = ""; arrCabeceraDg1[1, 4] = "c_numdoc"; arrCabeceraDg1[2, 0] = "Moneda"; arrCabeceraDg1[2, 1] = "40"; arrCabeceraDg1[2, 2] = "C"; arrCabeceraDg1[2, 3] = ""; arrCabeceraDg1[2, 4] = "c_desmon"; arrCabeceraDg1[3, 0] = "Fch. Emision"; arrCabeceraDg1[3, 1] = "70"; arrCabeceraDg1[3, 2] = "F"; arrCabeceraDg1[3, 3] = ""; arrCabeceraDg1[3, 4] = "d_fchemi"; arrCabeceraDg1[4, 0] = "Importe"; arrCabeceraDg1[4, 1] = "80"; arrCabeceraDg1[4, 2] = "N"; arrCabeceraDg1[4, 3] = "0.00"; arrCabeceraDg1[4, 4] = "n_importe"; arrCabeceraDg1[5, 0] = "Saldo"; arrCabeceraDg1[5, 1] = "80"; arrCabeceraDg1[5, 2] = "N"; arrCabeceraDg1[5, 3] = "0.00"; arrCabeceraDg1[5, 4] = "n_saldo"; arrCabeceraDg1[6, 0] = "Sel"; arrCabeceraDg1[6, 1] = "40"; arrCabeceraDg1[6, 2] = "B"; arrCabeceraDg1[6, 3] = "0.00"; arrCabeceraDg1[6, 4] = "n_sel"; arrCabeceraDg1[7, 0] = "IdDoc"; arrCabeceraDg1[7, 1] = "0"; arrCabeceraDg1[7, 2] = "N"; arrCabeceraDg1[7, 3] = ""; arrCabeceraDg1[7, 4] = "n_id"; Genericas xFun = new Genericas(); xFun.Filtrar_CampoBusqueda = "n_id"; xFun.Filtrar_CampoOrden = "c_numdoc"; xFun.Filtrar_ColumnaBusqueda = 8; xFun.Filtrar_ColumnaCheck = 7; dtResult = xFun.Filtrar(arrCabeceraDg1, DtVentas); if (dtResult == null) { return; } if (dtResult.Rows.Count == 0) { return; } int n_row = 0; string c_dato = ""; double n_valor = 0; booAgregando = true; for (n_row = 0; n_row <= dtResult.Rows.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = dtResult.Rows[n_row]["c_numdoc"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = dtResult.Rows[n_row]["c_desmon"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = dtResult.Rows[n_row]["c_tipdoc"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); c_dato = Convert.ToDateTime(dtResult.Rows[n_row]["d_fchemi"]).ToString("dd/MM/yyyy"); FgItems.SetData(FgItems.Rows.Count - 1, 4, c_dato); c_dato = Convert.ToDouble(dtResult.Rows[n_row]["n_importe"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); c_dato = Convert.ToDouble(dtResult.Rows[n_row]["n_saldo"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 6, c_dato); c_dato = Convert.ToDouble(dtResult.Rows[n_row]["n_saldo"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 7, c_dato); c_dato = TxtTasRet.Text; FgItems.SetData(FgItems.Rows.Count - 1, 8, c_dato); n_valor = Convert.ToDouble(dtResult.Rows[n_row]["n_saldo"]); n_valor = (n_valor * (Convert.ToDouble(TxtTasRet.Text) / 100)); FgItems.SetData(FgItems.Rows.Count - 1, 9, n_valor.ToString()); c_dato = Convert.ToDouble(dtResult.Rows[n_row]["n_id"]).ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 10, c_dato); } booAgregando = false; SumarColumnas(); }
void VerRegistro(int n_IdRegistro) { int n_row = 0; string c_dato = ""; b_Agregando = true; objRegistros.mysConec = mysConec; l_Detalle.Clear(); l_Documentos.Clear(); if (objRegistros.TraerRegistro(n_IdRegistro) == true) { e_Cabecera = objRegistros.e_Compras; l_Detalle = objRegistros.e_ComprasDet; } LblNumAsi.Text = e_Cabecera.c_numreg; TxtFchEmi.Text = e_Cabecera.d_fchdoc.ToString("dd/MM/yyyy"); CboMoneda.SelectedValue = e_Cabecera.n_idmon; CboTipOpe.SelectedValue = e_Cabecera.n_idtipope; LblIdPro.Text = e_Cabecera.n_idpro.ToString(); TxtNumRuc.Text = funDatos.DataTableBuscar(dtPro, "n_id", "c_numdoc", e_Cabecera.n_idpro.ToString(), "N").ToString(); TxtProv.Text = funDatos.DataTableBuscar(dtPro, "n_id", "c_nombre", e_Cabecera.n_idpro.ToString(), "N").ToString(); TxtTipCam.Text = e_Cabecera.n_tc.ToString("0.000"); CboTipDoc.SelectedValue = e_Cabecera.n_idtipdoc; TxtNumSer.Text = e_Cabecera.c_numser; TxtNumDoc.Text = e_Cabecera.c_numdoc; CboConPag.SelectedValue = e_Cabecera.n_idconpag; TxtFchVen.Text = e_Cabecera.d_fchven.ToString("dd/MM/yyyy"); TxtGlo.Text = e_Cabecera.c_glosa; CboTipOpe.SelectedValue = e_Cabecera.n_idtipope; //TxtBasImp1.Text = e_Cabecera.n_impbru.ToString("0.00"); //TxtBasImp2.Text = e_Cabecera.n_impbru2.ToString("0.00"); //TxtBasImp3.Text = e_Cabecera.n_impbru3.ToString("0.00"); //TxtInafec.Text = e_Cabecera.n_impinaf.ToString("0.00"); //TxtIgv1.Text = e_Cabecera.n_impigv.ToString("0.00"); ; //TxtIgv2.Text = e_Cabecera.n_impigv2.ToString("0.00"); ; //TxtIgv3.Text = e_Cabecera.n_impigv3.ToString("0.00"); ; TxtImpTot.Text = e_Cabecera.n_impbru.ToString("0.00"); TxtImpuesto.Text = e_Cabecera.n_imp4ta.ToString("0.00"); TxtImponible.Text = e_Cabecera.n_imptotcom.ToString("0.00"); //n_por4ta = e_Cabecera.n_tasa4ta; if (e_Cabecera.n_tasa4ta != 0) { ChkAfecto.Checked = true; } else { ChkAfecto.Checked = false; } b_Agregando = true; // VOLVEMOS A ASIGNAR LA VARIABLE PORQUE SE LIMPIA EN OTRA FUINCION TxtImpuesto.Text = e_Cabecera.n_imp4ta.ToString("0.00"); FgItems.Rows.Count = 2; for (n_row = 0; n_row <= l_Detalle.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = l_Detalle[n_row].n_iditem.ToString(); // DESCRIPCION DEL ITEM c_dato = funDatos.DataTableBuscar(dtItems, "n_id", "c_despro", c_dato, "N").ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = l_Detalle[n_row].n_preunibru.ToString("0.000000"); // PRECIO UNITARIO DEL ITEM FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = l_Detalle[n_row].n_imptot.ToString("0.00"); // IMPORTE TOTAL DEL ITEM FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); c_dato = l_Detalle[n_row].n_iditem.ToString("0.00"); // ID DEL ITEM FgItems.SetData(FgItems.Rows.Count - 1, 4, c_dato); c_dato = l_Detalle[n_row].n_idunimed.ToString("0.00"); // ID DE LA UNIDAD DE MEDIDA DEL ITEM FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); } b_Agregando = false; }
void MostrarDatos(DataTable dtIngresos, DataTable dtSalidas) { int n_fil = 0; int n_col = 0; int n_reg = 0; string c_nomcol = ""; int n_columna = 0; C1.Win.C1FlexGrid.CellRange rng; n_fil = 2; FgItems.Cols.Count = 3; FgItems.Rows.Count = 2; FgItems.Cols.Count = 66; FgItems.Rows.Count = 2; n_col = 6; for (n_reg = 0; n_reg <= dtIngresos.Rows.Count - 1; n_reg++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(n_fil, 1, dtIngresos.Rows[n_reg]["TARJETA_TMP"].ToString()); FgItems.SetData(n_fil, 2, dtIngresos.Rows[n_reg]["APENOM"].ToString()); FgItems.SetData(n_fil, 3, dtIngresos.Rows[n_reg]["AREA"].ToString()); n_columna = 4; for (n_col = 6; n_col <= dtIngresos.Columns.Count - 1; n_col++) { c_nomcol = dtIngresos.Columns[n_col].ColumnName; if (n_reg == 0) { FgItems.Cols[n_columna].Width = 45; FgItems.Cols[n_columna + 1].Width = 45; FgItems.Cols[n_columna].TextAlignFixed = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter; FgItems.Cols[n_columna + 1].TextAlignFixed = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter; FgItems.Rows[0].AllowMerging = true; rng = FgItems.GetCellRange(0, n_columna, 0, n_columna + 1); if (c_nomcol.Length == 5) { rng.Data = "DIA " + c_nomcol.Substring(4, 1); } else { rng.Data = "DIA " + c_nomcol.Substring(4, 2); } FgItems.SetData(1, n_columna, "Ingreso"); FgItems.SetData(1, n_columna + 1, "Salida"); } FgItems.SetData(n_fil, n_columna, dtIngresos.Rows[n_reg][c_nomcol].ToString()); n_columna = n_columna + 1; if (ChkOpcion.Checked == true) // AQUI IMPRIME EL FORMTATO PREPARADO MISTRANDO LAS HORAS FORMALES DE TRABAJO { string c_newhor; string c_ing = ""; string c_sal = ""; if (dtIngresos.Rows[n_reg][c_nomcol].ToString() != "") { c_ing = dtIngresos.Rows[n_reg][c_nomcol].ToString(); } if (dtSalidas.Rows[n_reg][c_nomcol].ToString() != "") { c_sal = dtSalidas.Rows[n_reg][c_nomcol].ToString(); } c_newhor = Hora_HallarSalidaFormal(c_sal, c_ing, 9); FgItems.SetData(n_fil, n_columna, c_newhor); } else { FgItems.SetData(n_fil, n_columna, dtSalidas.Rows[n_reg][c_nomcol].ToString()); // AQUI IMPRIME LAS HORAS REALMENTE TRABAJADAS } n_columna = n_columna + 1; } n_fil = n_fil + 1; } }
void VerRegistro(int n_IdRegistro) { int n_row = 0; string c_dato = ""; DataTable dtDet = new DataTable(); objRegistros.mysConec = mysConec; objRegistros.TraerRegistro(n_IdRegistro, n_TipoRegistro); e_Per = objRegistros.e_Percepcion; dtDet = objRegistros.dtDetalle; booAgregando = true; LblIdPro.Text = e_Per.n_idcli.ToString(); TxtNumRuc.Text = funDatos.DataTableBuscar(dtPro, "n_id", "c_numdoc", LblIdPro.Text, "N").ToString(); TxtPro.Text = funDatos.DataTableBuscar(dtPro, "n_id", "c_nombre", LblIdPro.Text, "N").ToString(); TxtTc.Text = e_Per.n_tc.ToString("0.000"); TxtFchEmi.Text = e_Per.d_fchemi.ToString(); TxtNumSer.Text = e_Per.c_numser; TxtNumDoc.Text = e_Per.c_numdoc; TxtTc.Text = e_Per.n_tc.ToString("0.000"); CboMon.SelectedValue = e_Per.n_idmon; CboTipRet.SelectedValue = e_Per.n_idper; TxtTasRet.Text = e_Per.n_tas.ToString("0.00"); TxtGlo.Text = e_Per.c_glo; LblNumAsi.Text = e_Per.c_numreg; FgItems.Rows.Count = 2; for (n_row = 0; n_row <= dtDet.Rows.Count - 1; n_row++) { FgItems.Rows.Count = FgItems.Rows.Count + 1; c_dato = dtDet.Rows[n_row]["c_numdoc"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 1, c_dato); c_dato = dtDet.Rows[n_row]["c_desmon"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 2, c_dato); c_dato = dtDet.Rows[n_row]["c_docdes"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 3, c_dato); c_dato = Convert.ToDateTime(dtDet.Rows[n_row]["d_fchdoc"]).ToString("dd/MM/yyyy"); FgItems.SetData(FgItems.Rows.Count - 1, 4, c_dato); if (e_Per.n_idmon == 151) { c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impdoc"]).ToString("0.00");; FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); c_dato = (Convert.ToDouble(dtDet.Rows[n_row]["n_impdoc"]) * e_Per.n_tc).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 6, c_dato); } else { c_dato = "0.00"; FgItems.SetData(FgItems.Rows.Count - 1, 5, c_dato); c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impdoc"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 6, c_dato); } //c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impcob"]).ToString("0.00"); //FgItems.SetData(FgItems.Rows.Count - 1, 7, c_dato); c_dato = TxtTasRet.Text; FgItems.SetData(FgItems.Rows.Count - 1, 8, c_dato); c_dato = Convert.ToDouble(dtDet.Rows[n_row]["n_impper"]).ToString("0.00"); FgItems.SetData(FgItems.Rows.Count - 1, 9, c_dato); c_dato = dtDet.Rows[n_row]["n_iddoc"].ToString(); FgItems.SetData(FgItems.Rows.Count - 1, 10, c_dato); } booAgregando = false; SumarColumnas(); }
private void FgItems_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { DataTable dtResul; string c_despro; int n_idpro; if (n_QueHace == 3) { FgItems.AllowEditing = false; return; } if (booAgregando == true) { return; } if (FgItems.Col == 1) { FgItems.Select(FgItems.Row - 1, 2); return; } if (FgItems.Col == 2) { booAgregando = true; // OBTENEMOS EL ID DEL TIPO DE PRODUCTO c_despro = funFunciones.NulosC(FgItems.GetData(FgItems.Row, 2)); dtResul = funDatos.DataTableFiltrar(dtItems, "c_despro = '" + c_despro + "'"); if (dtResul.Rows.Count != 0) { n_idpro = Convert.ToInt32(dtResul.Rows[0]["n_id"].ToString()); // FILTRAMOS LAS PRESENTACIONES DEL ITEM SELECCIONADO dtResul = funDatos.DataTableFiltrar(dtPresentaItem, "n_idite = " + n_idpro + " AND n_default = 1"); funFlex.FlexColumnaCombo(FgItems, dtResul, "c_abrpre", 3); // ITEMS if (dtResul.Rows.Count == 1) { FgItems.SetData(FgItems.Row, 3, dtResul.Rows[0]["c_abrpre"].ToString()); } else { FgItems.SetData(FgItems.Row, 3, ""); } } FgItems.SetData(FgItems.Row, 7, DateTime.Now.ToString("HH:mm")); FgItems.Select(FgItems.Row - 1, 3); booAgregando = false; return; } if (FgItems.Col == 3) { FgItems.Select(FgItems.Row - 1, 4); return; } if (FgItems.Col == 4) { FgItems.Select(FgItems.Row - 1, 5); return; } if (FgItems.Col == 5) { FgItems.Select(FgItems.Row - 1, 6); return; } if (FgItems.Col == 6) { double n_saldo = Convert.ToDouble(funFunciones.NulosN(FgItems.GetData(FgItems.Row, 5))); double n_cansol = Convert.ToDouble(funFunciones.NulosN(FgItems.GetData(FgItems.Row, 6))); string c_numlote = funFunciones.NulosC(FgItems.GetData(FgItems.Row, 4)); //if (c_numlote != "") //{ // if (n_cansol > n_saldo) // { // //FgItems.SetData(FgItems.Row, 6, ""); // MessageBox.Show("La cantidad solicitada excede la capacidad del lote, ingrese una cantidad menor o igual al lote", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); // } // else // { // FgItems.SetData(FgItems.Row, 6, n_cansol.ToString("0.000000")); // } //} //else //{ // FgItems.SetData(FgItems.Row, 6, n_cansol.ToString("0.000000")); //} return; } if (FgItems.Col == 7) { FgItems.Select(FgItems.Row, 1); return; } }
void MostrarDatosItems() { int n_row = 0; int n_numanos = 0; double n_valor; DataTable dtResult = new DataTable(); CN_ges_planventas o_plan = new CN_ges_planventas(); dtResult = funDatos.DataTableFiltrar(dtItems, "n_id = " + n_IdItem + ""); if (dtResult.Rows.Count != 0) { TxtCodPro.Text = dtResult.Rows[0]["c_codpro"].ToString(); TxtDes.Text = dtResult.Rows[0]["c_despro"].ToString(); TxtUniMed.Text = dtResult.Rows[0]["c_abrpre"].ToString(); } o_plan.mysConec = mysConec; o_plan.VentasItemxPorAnos(STU_SISTEMA.EMPRESAID, n_IdItem); dtResult = o_plan.dtLista; FgItems.Rows.Count = 2; if (dtResult != null) { if (dtResult.Rows.Count != 0) { funFlex.FlexMostrarDatos(FgItems, arrCabeceraFlex1, dtResult, 2, true); FgItems.SelectionMode = C1.Win.C1FlexGrid.SelectionModeEnum.Row; n_numanos = dtResult.Rows.Count; // CALCULAMOS EL TOTAL double n_totalmes = 0; FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(FgItems.Rows.Count - 1, 1, "TOTAL ==>"); n_totalmes = funFlex.FlexSumarCol(FgItems, 2, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 2, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 3, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 3, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 4, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 4, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 5, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 5, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 6, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 6, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 7, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 7, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 8, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 8, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 9, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 9, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 10, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 10, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 11, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 11, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 12, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 12, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 13, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 13, n_totalmes.ToString("0.00")); n_totalmes = funFlex.FlexSumarCol(FgItems, 14, 2, FgItems.Rows.Count - 1); FgItems.SetData(FgItems.Rows.Count - 1, 14, n_totalmes.ToString("0.00")); //CALCULAMOS EL PROMEDIO FgItems.Rows.Count = FgItems.Rows.Count + 1; FgItems.SetData(FgItems.Rows.Count - 1, 1, "PROMEDIO ==>"); double n_total = 0; Double n_promedio = 0; n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 2)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 2, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 3)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 3, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 4)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 4, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 5)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 5, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 6)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 6, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 7)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 7, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 8)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 8, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 9)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 9, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 10)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 10, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 11)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 11, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 12)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 12, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 13)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 13, n_promedio.ToString("0.00")); n_total = Convert.ToDouble(FgItems.GetData(FgItems.Rows.Count - 2, 14)); n_promedio = (n_total / n_numanos); FgItems.SetData(FgItems.Rows.Count - 1, 14, n_promedio.ToString("0.00")); } } string[] c_datos = new string[12]; int n_fil = 0; int n_ele = 0; string c_dato = ""; n_row = 0; for (n_row = 2; n_row <= FgItems.Rows.Count - 3; n_row++) { n_ele = 0; for (n_fil = 2; n_fil <= FgItems.Cols.Count - 4; n_fil++) { c_datos[n_ele] = Convert.ToDouble(funFunciones.NulosN(FgItems.GetData(n_row, n_fil))).ToString("0.00"); n_ele = n_ele + 1; } c_dato = HallarPromedio(c_datos).ToString("0.00"); FgItems.SetData(n_row, FgItems.Cols.Count - 1, c_dato); } funFlex.Flex_PintarCeldas(FgItems, FgItems.Rows.Count - 2, 1, FgItems.Rows.Count - 1, 14, Color.Black, Color.Coral); funFlex.Flex_PintarCeldas(FgItems, 2, FgItems.Cols.Count - 2, FgItems.Rows.Count - 1, FgItems.Cols.Count - 1, Color.Black, Color.LightCoral); MostrarPlanVenta(); }
void VerRegistro(int n_IdRegistro) { booAgregando = true; int n_fila = 0; string c_dato = ""; objRegistros.mysConec = mysConec; objRegistros.TraerRegistro(n_IdRegistro); FgItems.Rows.Count = 2; FgItems.Rows.Count = 14; if (objRegistros.booOcurrioError == false) { BE_Registro = objRegistros.entEstacion; CboMP.SelectedValue = BE_Registro.n_idite; FgItems.SetData(2, 1, "ENERO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_ene.ToString(), "N").ToString(); FgItems.SetData(2, 2, c_dato); FgItems.SetData(3, 1, "FEBRERO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_feb.ToString(), "N").ToString(); FgItems.SetData(3, 2, c_dato); FgItems.SetData(4, 1, "MARZO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_mar.ToString(), "N").ToString(); FgItems.SetData(4, 2, c_dato); FgItems.SetData(5, 1, "ABRIL"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_abr.ToString(), "N").ToString(); FgItems.SetData(5, 2, c_dato); FgItems.SetData(6, 1, "MAYO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_may.ToString(), "N").ToString(); FgItems.SetData(6, 2, c_dato); FgItems.SetData(7, 1, "JUNIO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_jun.ToString(), "N").ToString(); FgItems.SetData(7, 2, c_dato); FgItems.SetData(8, 1, "JULIO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_jul.ToString(), "N").ToString(); FgItems.SetData(8, 2, c_dato); FgItems.SetData(9, 1, "AGOSTO"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_ago.ToString(), "N").ToString(); FgItems.SetData(9, 2, c_dato); FgItems.SetData(10, 1, "SETIEMBRE"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_set.ToString(), "N").ToString(); FgItems.SetData(10, 2, c_dato); FgItems.SetData(11, 1, "OCTUBRE"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_oct.ToString(), "N").ToString(); FgItems.SetData(11, 2, c_dato); FgItems.SetData(12, 1, "NOVIEMBRE"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_nov.ToString(), "N").ToString(); FgItems.SetData(12, 2, c_dato); FgItems.SetData(13, 1, "DICIEMBRE"); c_dato = funDatos.DataTableBuscar(dtestado, "n_id", "c_des", BE_Registro.n_dic.ToString(), "N").ToString(); FgItems.SetData(13, 2, c_dato); n_fila = n_fila + 1; } booAgregando = false; }