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;
}
