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