public bool InsertarCargo(BE_COO_CARGOSCAB entCargos, List <BE_COO_CARGOSDET> lstDetalle)
{
bool booOk = false;
int n_row = 0;
DatosMySql xMiFuncion = new DatosMySql();
if (xMiFuncion.StoreEjecutar("coo_cargoscab_insertar", entCargos, mysConec, 16) == true)
{
for (n_row = 0; n_row <= lstDetalle.Count - 1; n_row++)
{
BE_COO_CARGOSDET entCargosDet = new BE_COO_CARGOSDET();
entCargosDet = lstDetalle[n_row];
//entCargosDet.n_idcar = entCargos.n_id;
entCargosDet.n_idcor = Convert.ToInt32(xMiFuncion.intIdGenerado);
if (xMiFuncion.StoreEjecutar("coo_cargosdet_insertar", entCargosDet, mysConec, null) == false)
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
return(booOk);
}
}
booOk = true;
}
else
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
}
return(booOk);
}
public bool InsertarCargo(BE_COO_CARGOSCAB entCargos, List <BE_COO_CARGOSDET> lstDetalle)
{
bool b_result = false;
CD_coo_cargoscab miFun = new CD_coo_cargoscab();
miFun.mysConec = mysConec;
b_result = miFun.InsertarCargo(entCargos, lstDetalle);
if (b_result == false)
{
booOcurrioError = miFun.booOcurrioError;
StrErrorMensaje = miFun.StrErrorMensaje;
IntErrorNumber = miFun.IntErrorNumber;
}
return(b_result);
}
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);
}
}
}
}
public bool Actualizar(BE_COO_CARGOS entCargos, List <BE_COO_CARGOSCAB> LstCargosCab, List <BE_COO_CARGOSDET> LstCargosDet)
{
bool booOk = false;
int n_row = 0;
DatosMySql xMiFuncion = new DatosMySql();
string[,] arrParametros = new string[1, 3] {
{ "n_idcar", "System.INT16", entCargos.n_id.ToString() }
};
booOk = xMiFuncion.StoreEjecutar("coo_cargosdet_delete", arrParametros, mysConec);
if (booOk == true)
{
booOk = xMiFuncion.StoreEjecutar("coo_cargoscab_delete", arrParametros, mysConec);
if (booOk == false)
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
}
}
else
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
}
if (xMiFuncion.StoreEjecutar("coo_cargos_actualizar", entCargos, mysConec, null) == true)
{
for (n_row = 0; n_row <= LstCargosCab.Count; n_row++)
{
BE_COO_CARGOSCAB entCargosCab = new BE_COO_CARGOSCAB();
entCargosCab = LstCargosCab[n_row];
if (xMiFuncion.StoreEjecutar("coo_cargoscab_insertar", entCargosCab, mysConec, 1) == false)
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
return(booOk);
}
}
for (n_row = 0; n_row <= LstCargosDet.Count; n_row++)
{
BE_COO_CARGOSDET entCargosDet = new BE_COO_CARGOSDET();
entCargosDet = LstCargosDet[n_row];
if (xMiFuncion.StoreEjecutar("coo_cargosdet_insertar", entCargosDet, mysConec, 1) == false)
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
return(booOk);
}
}
booOk = true;
}
else
{
booOcurrioError = xMiFuncion.booOcurrioError;
StrErrorMensaje = xMiFuncion.StrErrorMensaje;
IntErrorNumber = xMiFuncion.IntErrorNumber;
}
return(booOk);
}
public void TraerRegistro(int n_IdRegistro)
{
int n_row = 0;
CD_coo_cargos miFun = new CD_coo_cargos();
DataTable dtCargos = new DataTable();
DataTable dtCargosCab = new DataTable();
DataTable dtCargosDet = new DataTable();
miFun.mysConec = mysConec;
miFun.TraerRegistro(n_IdRegistro);
dtCargos = miFun.dtCargos;
dtCargosCab = miFun.dtCargosCab;
dtCargosDet = miFun.dtCargosDet;
if (dtCargos.Rows.Count != 0)
{
entCargos.n_idemp = Convert.ToInt32(dtCargos.Rows[0]["n_idemp"].ToString());
entCargos.n_id = Convert.ToInt32(dtCargos.Rows[0]["n_id"].ToString());
entCargos.n_anotra = Convert.ToInt32(dtCargos.Rows[0]["n_anotra"].ToString());
entCargos.n_mestra = Convert.ToInt32(dtCargos.Rows[0]["n_mestra"].ToString());
entCargos.d_fchemi = Convert.ToDateTime(dtCargos.Rows[0]["d_fchemi"]);
entCargos.d_fchini = Convert.ToDateTime(dtCargos.Rows[0]["d_fchini"]);
entCargos.d_fchfin = Convert.ToDateTime(dtCargos.Rows[0]["d_fchfin"]);
entCargos.n_numsoc = Convert.ToInt32(dtCargos.Rows[0]["n_numsoc"].ToString());
entCargos.n_impbru = Convert.ToDouble(dtCargos.Rows[0]["n_impbru"].ToString());
entCargos.n_impigv = Convert.ToDouble(dtCargos.Rows[0]["n_impigv"].ToString());
entCargos.n_imptot = Convert.ToDouble(dtCargos.Rows[0]["n_imptot"].ToString());
entCargos.n_idtipdoc = Convert.ToInt32(dtCargos.Rows[0]["n_idtipdoc"].ToString());
}
if (dtCargosCab.Rows.Count != 0)
{
for (n_row = 0; n_row <= dtCargosCab.Rows.Count - 1; n_row++)
{
BE_COO_CARGOSCAB entCargosCab = new BE_COO_CARGOSCAB();
entCargosCab.n_idemp = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_idemp"].ToString());
entCargosCab.n_idcar = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_idcar"].ToString());
entCargosCab.n_idsoc = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_idsoc"].ToString());
entCargosCab.n_idsocpue = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_idsocpue"].ToString());
entCargosCab.n_idtipdoc = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_idtipdoc"].ToString());
entCargosCab.c_numser = dtCargosCab.Rows[n_row]["c_numser"].ToString();
entCargosCab.c_numdoc = dtCargosCab.Rows[n_row]["c_numdoc"].ToString();
entCargosCab.d_fchemi = Convert.ToDateTime(dtCargosCab.Rows[n_row]["d_fchemi"].ToString());
entCargosCab.d_fchven = Convert.ToDateTime(dtCargosCab.Rows[n_row]["d_fchven"].ToString());
entCargosCab.n_impbru = Convert.ToDouble(dtCargosCab.Rows[n_row]["n_impbru"].ToString());
entCargosCab.n_impigv = Convert.ToDouble(dtCargosCab.Rows[n_row]["n_impigv"].ToString());
entCargosCab.n_imptot = Convert.ToDouble(dtCargosCab.Rows[n_row]["n_imptot"].ToString());
entCargosCab.c_glosa = dtCargosCab.Rows[n_row]["c_glosa"].ToString();
entCargosCab.n_impsal = Convert.ToDouble(dtCargosCab.Rows[n_row]["n_impsal"].ToString());
entCargosCab.n_anotra = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_anotra"].ToString());
entCargosCab.n_mestra = Convert.ToInt32(dtCargosCab.Rows[n_row]["n_mestra"].ToString());
lstCargosCab.Add(entCargosCab);
}
}
if (dtCargosDet.Rows.Count != 0)
{
for (n_row = 0; n_row <= dtCargosDet.Rows.Count - 1; n_row++)
{
BE_COO_CARGOSDET entCargosDet = new BE_COO_CARGOSDET();
entCargosDet.n_idemp = Convert.ToInt32(dtCargosDet.Rows[n_row]["n_idemp"].ToString());
entCargosDet.n_idcar = Convert.ToInt32(dtCargosDet.Rows[n_row]["n_idcar"].ToString());
entCargosDet.n_idsoc = Convert.ToInt32(dtCargosDet.Rows[n_row]["n_idsoc"].ToString());
entCargosDet.n_idcon = Convert.ToInt32(dtCargosDet.Rows[n_row]["n_idcon"].ToString());
entCargosDet.n_can = Convert.ToDouble(dtCargosDet.Rows[n_row]["n_can"].ToString());
entCargosDet.n_impbru = Convert.ToDouble(dtCargosDet.Rows[n_row]["n_impbru"].ToString());
entCargosDet.n_impnet = Convert.ToDouble(dtCargosDet.Rows[n_row]["n_impnet"].ToString());
entCargosDet.n_imptotbru = Convert.ToDouble(dtCargosDet.Rows[n_row]["n_imptotbru"].ToString());
entCargosDet.n_imptotnet = Convert.ToDouble(dtCargosDet.Rows[n_row]["n_imptotnet"].ToString());
entCargosDet.n_idpue = Convert.ToInt32(dtCargosDet.Rows[n_row]["n_idpue"].ToString());
lstCargosDet.Add(entCargosDet);
}
}
return;
}
private void CmdAce_Click(object sender, EventArgs e)
{
if (ValidarDatos() == false)
{
return;
}
BE_COO_CARGOSCAB entCab = new BE_COO_CARGOSCAB();
List <BE_COO_CARGOSDET> lstDet = new List <BE_COO_CARGOSDET>();
int n_row = 0;
double n_impbru = 0;
double n_igv = 0;
double n_impnet = 0;
string c_numdoc = "";
int n_idtipdoc = 0;
DataTable dtResul = new DataTable();
n_idtipdoc = 82;
CN_sun_tipdoccom objTipDoc = new CN_sun_tipdoccom();
objTipDoc.mysConec = mysConec;
c_numdoc = objTipDoc.UltimoNumero(STU_SISTEMA.EMPRESAID, n_idtipdoc, "0001");
entCab.n_idemp = STU_SISTEMA.EMPRESAID;
if (N_TIPOOPERACION == 1)
{
if (N_SOCIOTIPO == 1)
{
entCab.n_idcar = 44; // ASIGNAMOS EL CARGO DE RECIBOS
}
else
{
entCab.n_idcar = 43; // ASIGNAMOS EL CARGO DE BOLETAS DE VENTA
}
}
else
{
CN_coo_cargos xfunCar = new CN_coo_cargos();
xfunCar.mysConec = mysConec;
xfunCar.STU_SISTEMA = STU_SISTEMA;
if (N_SOCIOTIPO == 1)
{
xfunCar.ObtenerMesValido(STU_SISTEMA.EMPRESAID, STU_SISTEMA.ANOTRABAJO, 81);
}
else
{
xfunCar.ObtenerMesValido(STU_SISTEMA.EMPRESAID, STU_SISTEMA.ANOTRABAJO, 4);
}
dtResul = xfunCar.dtLista;
entCab.n_idcar = Convert.ToInt32(dtResul.Rows[0]["n_id"]);
}
entCab.n_idsoc = N_SOCIOID;
entCab.n_idsocpue = Convert.ToInt32(CboPue.SelectedValue);
entCab.n_id = 0;
entCab.n_idtipdoc = n_idtipdoc;
entCab.c_numser = "0001";
entCab.c_numdoc = c_numdoc;
entCab.d_fchemi = DateTime.Now;
entCab.d_fchven = DateTime.Now;
entCab.c_glosa = "";
entCab.n_anotra = STU_SISTEMA.ANOTRABAJO;
entCab.n_mestra = Convert.ToInt32(CboMesTra.SelectedValue);
entCab.n_iddocpag = 0;
int n_afecto = 0;
double n_valor = 0;
double n_TasaIGV = 18;
for (n_row = 2; n_row <= FgLista.Rows.Count - 1; n_row++)
{
Helper.Comunes.Funciones fun = new Helper.Comunes.Funciones();
if (fun.NulosC(FgLista.GetData(n_row, 1)) != "")
{
BE_COO_CARGOSDET entDet = new BE_COO_CARGOSDET();
entDet.n_idemp = STU_SISTEMA.EMPRESAID;
entDet.n_idcar = entCab.n_idcar;
entDet.n_idsoc = N_SOCIOID;
entDet.n_idpue = Convert.ToInt32(CboPue.SelectedValue);
entDet.n_idcon = Convert.ToInt32(FgLista.GetData(n_row, 3).ToString());
entDet.n_can = 1;
n_valor = Convert.ToDouble(FgLista.GetData(n_row, 2).ToString());
n_afecto = Convert.ToInt32(funDatos.DataTableBuscar(dtConcepto, "n_id", "n_afeigv", entDet.n_idcon.ToString(), "N").ToString());
entDet.n_impbru = n_valor;
entDet.n_imptotbru = (n_valor * 1);
if (n_afecto == 2) // INDICA QUE EL CONCEPTO ES INAFECTO AL IGV
{
entDet.n_impnet = n_valor;
entDet.n_imptotnet = (n_valor * 1);
}
else
{
entDet.n_impnet = n_valor * ((n_TasaIGV / 100) + 1);
entDet.n_imptotnet = (n_valor * ((n_TasaIGV / 100) + 1) * 1);
}
//entDet.n_imptotbru = Convert.ToDouble(FgLista.GetData(n_row,2).ToString());;
//entDet.n_imptotnet = Convert.ToDouble(FgLista.GetData(n_row,2).ToString());;
entDet.n_idcor = 0;
entDet.n_pagado = 0;
entDet.n_iddocpag = 0;
n_impbru = n_impbru + entDet.n_imptotbru;
n_impnet = n_impnet + entDet.n_imptotnet;
n_igv = n_igv + (entDet.n_imptotnet - entDet.n_imptotbru);
lstDet.Add(entDet);
}
}
entCab.n_impbru = n_impbru;
entCab.n_impigv = n_igv;
entCab.n_imptot = n_impnet;
entCab.n_impsal = n_impnet;
CN_coo_cargoscab funCar = new CN_coo_cargoscab();
funCar.mysConec = mysConec;
if (funCar.InsertarCargo(entCab, lstDet) == true)
{
MessageBox.Show("¡ El cargo se genero con exito !", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
this.Close();
}
else
{
MessageBox.Show("¡ No se pudo generar el cargo por el siguiente motivo: " + funCar.StrErrorMensaje + " !", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
