void AsignarEntidad() { int n_row = 0; int n_rowdet = 0; string c_key = ""; double n_valor = 0; lstCargCab.Clear(); lstCargDet.Clear(); BE_Registro.n_idemp = STU_SISTEMA.EMPRESAID; if (n_QueHace == 1) { BE_Registro.n_id = 0; } else { BE_Registro.n_id = BE_Registro.n_id; } BE_Registro.n_idemp = STU_SISTEMA.EMPRESAID; //BE_Registro.n_id BE_Registro.n_anotra = Convert.ToInt32(TxtAnoTra.Text); BE_Registro.n_mestra = Convert.ToInt32(CboMesTra.SelectedValue); BE_Registro.d_fchemi = Convert.ToDateTime(TxtFchEmi.Text); BE_Registro.d_fchini = Convert.ToDateTime("01/08/2017"); BE_Registro.d_fchfin = Convert.ToDateTime("31/08/2017"); BE_Registro.n_numsoc = Convert.ToInt32(TxtNumSoc.Text); BE_Registro.n_impbru = Convert.ToDouble(TxtImpBru.Text); BE_Registro.n_impigv = Convert.ToDouble(TxtImpIgv.Text); BE_Registro.n_imptot = Convert.ToDouble(TxtImpTot.Text); BE_Registro.n_idtipdoc = Convert.ToInt32(CboTipDoc.SelectedValue); for (n_row = 2; n_row <= FgLisCar.Rows.Count - 1; n_row++) { // AGREGAMOS LA CABECERA BE_COO_CARGOSCAB entCargosCab = new BE_COO_CARGOSCAB(); entCargosCab.n_idemp = STU_SISTEMA.EMPRESAID; entCargosCab.n_idcar = BE_Registro.n_id; entCargosCab.n_idsoc = Convert.ToInt32(FgLisCar.GetData(n_row, 8)); //if (entCargosCab.n_idsoc == 11711) //{ // MessageBox.Show("¡ ¨Ha ocurrido un un problema, no se pudo guardar el registro ! Error Nº : " + objRegistros.IntErrorNumber.ToString() + " = " + objRegistros.StrErrorMensaje, "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); //} entCargosCab.n_idsocpue = Convert.ToInt32(FgLisCar.GetData(n_row, 7)); entCargosCab.n_idtipdoc = Convert.ToInt32(CboTipDoc.SelectedValue); entCargosCab.c_numser = FgLisCar.GetData(n_row, 3).ToString().Substring(0, 4); entCargosCab.c_numdoc = FgLisCar.GetData(n_row, 3).ToString().Substring(5, 10); entCargosCab.d_fchemi = Convert.ToDateTime(TxtFchEmi.Text); entCargosCab.d_fchven = Convert.ToDateTime(TxtFchEmi.Text); entCargosCab.n_impbru = Convert.ToDouble(FgLisCar.GetData(n_row, 4)); entCargosCab.n_impigv = Convert.ToDouble(FgLisCar.GetData(n_row, 5)); entCargosCab.n_imptot = Convert.ToDouble(FgLisCar.GetData(n_row, 6)); entCargosCab.c_glosa = TxtGlosa.Text; entCargosCab.n_impsal = Convert.ToDouble(FgLisCar.GetData(n_row, 6)); entCargosCab.n_anotra = Convert.ToInt32(TxtAnoTra.Text); entCargosCab.n_mestra = Convert.ToInt32(CboMesTra.SelectedValue); lstCargCab.Add(entCargosCab); // AGREGAMOS EL DETALLE DE LA CABECERA n_rowdet = 0; DataTable dtResult = new DataTable(); c_key = entCargosCab.n_idsoc.ToString() + "-" + entCargosCab.n_idsocpue.ToString(); //if (c_key == "13-447") //{ // MessageBox.Show("¡ ¨Ha ocurrido un un problema, no se pudo guardar el registro ! Error Nº : " + objRegistros.IntErrorNumber.ToString() + " = " + objRegistros.StrErrorMensaje, "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); //} dtResult = funDatos.DataTableFiltrar(dtCarDet, "c_llave = '" + c_key + "'"); if (dtResult.Rows.Count != 0) { for (n_rowdet = 0; n_rowdet <= dtResult.Rows.Count - 1; n_rowdet++) { BE_COO_CARGOSDET entCargosdet = new BE_COO_CARGOSDET(); entCargosdet.n_idemp = STU_SISTEMA.EMPRESAID; entCargosdet.n_idcar = entCargosCab.n_idcar; entCargosdet.n_idsoc = entCargosCab.n_idsoc; entCargosdet.n_idcon = Convert.ToInt32(dtResult.Rows[n_rowdet]["n_idcom"]); entCargosdet.n_can = 1; n_valor = Convert.ToDouble(funFunciones.NulosN(dtResult.Rows[n_rowdet]["n_imp"])); //if (n_valor == 3) //{ // MessageBox.Show("¡ ¨Ha ocurrido un un problema, no se pudo guardar el registro ! Error Nº : " + objRegistros.IntErrorNumber.ToString() + " = " + objRegistros.StrErrorMensaje, "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); //} entCargosdet.n_impbru = n_valor; entCargosdet.n_imptotbru = n_valor * 1; n_valor = n_valor * ((n_TASAIMP / 100) + 1); entCargosdet.n_impnet = n_valor; entCargosdet.n_imptotnet = n_valor * 1; entCargosdet.n_idpue = entCargosCab.n_idsocpue; lstCargDet.Add(entCargosdet); } } } }
private void CmdGenerar_Click(object sender, EventArgs e) { if (Convert.ToInt32(CboTipDoc.SelectedValue) == 0) { MessageBox.Show("No ha indicado el tipo de documento ", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); CboTipDoc.Focus(); return; } if (TxtNumSer.Text == "") { MessageBox.Show("No ha indicado el numero de serie del documento ", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); TxtNumSer.Focus(); return; } if (TxtNumDoc.Text == "") { MessageBox.Show("No ha indicado el numero del documento ", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); TxtNumDoc.Focus(); return; } string c_fchini = ""; string c_fchfin = ""; DataTable dtResult = new DataTable(); int n_row = 0; int n_idemp = STU_SISTEMA.EMPRESAID; int n_anotra = Convert.ToInt32(TxtAnoTra.Text); int n_mestra = Convert.ToInt32(CboMesTra.SelectedValue); int n_idtipdoc = Convert.ToInt32(CboTipDoc.SelectedValue); string c_glo = TxtGlosa.Text; if (n_mestra == 0) { c_fchini = "01/01/2017"; c_fchfin = "01/01/2017"; } else { c_fchini = "01/" + n_mestra.ToString() + "/" + n_anotra.ToString(); c_fchfin = "30/" + n_mestra.ToString() + "/" + n_anotra.ToString();; } int n_numdoc = Convert.ToInt32(TxtNumDoc.Text); double n_totbru = 0; double n_totigv = 0; double n_tottot = 0; int n_totsoc = 0; double n_valor = 0; FgLisCar.Rows.Count = 2; n_TASAIMP = 0; dtResult = funDatos.DataTableFiltrar(dtDocComImp, "n_idtipdoc = " + CboTipDoc.SelectedValue.ToString() + ""); if (dtResult.Rows.Count != 0) { n_TASAIMP = Convert.ToDouble(dtResult.Rows[0]["n_portas"]); } objRegistros.booOcurrioError = false; objRegistros.GenerarCargos(n_idemp, n_anotra, n_mestra, c_glo, c_fchini, c_fchfin, n_idtipdoc); if (objRegistros.booOcurrioError == true) { // EMITIR MENSAHE DE ERROR return; } dtResult = objRegistros.dtCargosCab; dtCarDet = objRegistros.dtCargosDet; //dtResult = objRegistros.d if (dtResult.Rows.Count != 0) { for (n_row = 0; n_row <= dtResult.Rows.Count - 1; n_row++) { FgLisCar.Rows.Count = FgLisCar.Rows.Count + 1; FgLisCar.SetData(FgLisCar.Rows.Count - 1, 1, dtResult.Rows[n_row]["c_puesto"].ToString()); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 2, dtResult.Rows[n_row]["c_apenom"].ToString()); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 3, TxtNumSer.Text + "-" + n_numdoc.ToString("0000000000")); if ((Convert.ToInt32(CboTipDoc.SelectedValue) == 4) || (Convert.ToInt32(CboTipDoc.SelectedValue) == 2)) { FgLisCar.SetData(FgLisCar.Rows.Count - 1, 4, dtResult.Rows[n_row]["n_impbru"].ToString()); n_valor = Convert.ToDouble(funFunciones.NulosN(dtResult.Rows[n_row]["n_impbru"])); n_valor = (n_valor * ((n_TASAIMP / 100) + 1) - n_valor); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 5, n_valor.ToString("0.00")); n_valor = Convert.ToDouble(funFunciones.NulosN(dtResult.Rows[n_row]["n_impbru"])); n_valor = (n_valor * ((n_TASAIMP / 100) + 1)); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 6, n_valor); } else { FgLisCar.SetData(FgLisCar.Rows.Count - 1, 4, dtResult.Rows[n_row]["n_impbru"].ToString()); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 5, 0); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 6, dtResult.Rows[n_row]["n_impbru"].ToString()); } FgLisCar.SetData(FgLisCar.Rows.Count - 1, 7, dtResult.Rows[n_row]["n_id"].ToString()); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 8, dtResult.Rows[n_row]["n_idsoc"].ToString()); n_totbru = n_totbru + Convert.ToDouble(FgLisCar.GetData(FgLisCar.Rows.Count - 1, 4)); n_totigv = n_totigv + Convert.ToDouble(FgLisCar.GetData(FgLisCar.Rows.Count - 1, 5)); n_tottot = n_tottot + Convert.ToDouble(FgLisCar.GetData(FgLisCar.Rows.Count - 1, 6)); n_totsoc = n_totsoc + 1; n_numdoc = n_numdoc + 1; } TxtNumSoc.Text = n_totsoc.ToString(); TxtImpBru.Text = n_totbru.ToString("0.00"); TxtImpIgv.Text = n_totigv.ToString("0.00"); TxtImpTot.Text = n_tottot.ToString("0.00"); } }
void MostrarDatos() { DataTable dtResult = new DataTable(); int n_row = 0; string c_dato = ""; FgLisCar.Rows.Count = 2; if (lstCargCab.Count == 0) { MessageBox.Show("¡ No hay cargosa para mostrar !", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); return; } TxtNumSer.Text = lstCargCab[0].c_numser.ToString(); TxtNumDoc.Text = lstCargCab[0].c_numdoc.ToString(); for (n_row = 0; n_row <= lstCargCab.Count - 1; n_row++) { FgLisCar.Rows.Count = FgLisCar.Rows.Count + 1; // MOSTRAMOS EL NUMERO DE PUESTO c_dato = lstCargCab[n_row].n_idsocpue.ToString(); dtResult = funDatos.DataTableFiltrar(dtSociosPuestos, "n_id = " + c_dato + ""); if (dtResult.Rows.Count != 0) { c_dato = dtResult.Rows[0]["n_idpue"].ToString(); dtResult = funDatos.DataTableFiltrar(dtPuestos, "n_id = " + c_dato + ""); c_dato = dtResult.Rows[0]["c_puesto"].ToString(); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 1, c_dato); } // MOSTRAMOS EL NOMBRE DEL SOCIO c_dato = lstCargCab[n_row].n_idsoc.ToString(); dtResult = funDatos.DataTableFiltrar(dtSocios, "n_id = " + c_dato + ""); c_dato = dtResult.Rows[0]["c_apenom"].ToString(); if (dtResult.Rows.Count != 0) { FgLisCar.SetData(FgLisCar.Rows.Count - 1, 2, c_dato); } // NUMERO DE DOCUMENTO c_dato = lstCargCab[n_row].c_numser.ToString() + "-" + lstCargCab[n_row].c_numdoc.ToString(); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 3, c_dato); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 4, lstCargCab[n_row].n_impbru.ToString("0.00")); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 5, lstCargCab[n_row].n_impigv.ToString("0.00")); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 6, lstCargCab[n_row].n_imptot.ToString("0.00")); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 7, lstCargCab[n_row].n_idsocpue.ToString()); FgLisCar.SetData(FgLisCar.Rows.Count - 1, 8, lstCargCab[n_row].n_idsoc.ToString()); } //FgLisCar.SetData(FgLisCar.Rows.Count - 1, 1, dtResult.Rows[n_row]["c_puesto"].ToString()); //FgLisCar.SetData(FgLisCar.Rows.Count - 1, 2, dtResult.Rows[n_row]["c_apenom"].ToString()); //FgLisCar.SetData(FgLisCar.Rows.Count - 1, 3, TxtNumSer.Text + "-" + n_numdoc.ToString("0000000000")); //if (Convert.ToInt32(CboTipDoc.SelectedValue) == 4) //{ // FgLisCar.SetData(FgLisCar.Rows.Count - 1, 4, dtResult.Rows[n_row]["n_impbru"].ToString()); // FgLisCar.SetData(FgLisCar.Rows.Count - 1, 5, dtResult.Rows[n_row]["n_impbru"].ToString()); // FgLisCar.SetData(FgLisCar.Rows.Count - 1, 6, dtResult.Rows[n_row]["n_impbru"].ToString()); //} //else //{ // FgLisCar.SetData(FgLisCar.Rows.Count - 1, 4, dtResult.Rows[n_row]["n_impbru"].ToString()); // FgLisCar.SetData(FgLisCar.Rows.Count - 1, 5, 0); // FgLisCar.SetData(FgLisCar.Rows.Count - 1, 6, dtResult.Rows[n_row]["n_impbru"].ToString()); //} //FgLisCar.SetData(FgLisCar.Rows.Count - 1, 7, dtResult.Rows[n_row]["n_idpue"].ToString()); //FgLisCar.SetData(FgLisCar.Rows.Count - 1, 8, dtResult.Rows[n_row]["n_idsoc"].ToString()); //n_totbru = n_totbru + Convert.ToDouble(FgLisCar.GetData(FgLisCar.Rows.Count - 1, 4)); //n_totigv = n_totigv + Convert.ToDouble(FgLisCar.GetData(FgLisCar.Rows.Count - 1, 5)); //n_tottot = n_tottot + Convert.ToDouble(FgLisCar.GetData(FgLisCar.Rows.Count - 1, 6)); }