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