public bool EliminarConcepto(int n_IdCargo, int n_IdCarDet) { bool b_result = false; CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; b_result = miFun.EliminarConcepto(n_IdCargo, n_IdCarDet); if (b_result == false) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } return(b_result); }
public bool Actualizar(BE_COO_CARGOS entCargos, List <BE_COO_CARGOSCAB> LstCargosCab, List <BE_COO_CARGOSDET> LstCargosDet) { bool b_result = false; CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; b_result = miFun.Actualizar(entCargos, LstCargosCab, LstCargosDet); if (b_result == false) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } return(b_result); }
public DataTable Listar(int n_IdEmpresa, int n_AnoTrabajo, int n_MesTrabajo) { DataTable dtResul = new DataTable(); CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; dtResul = miFun.Listar(n_IdEmpresa, n_AnoTrabajo, n_MesTrabajo); if (dtResul == null) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } return(dtResul); }
public void ObtenerMesValido(int n_IdEmpresa, int n_AnoTrabajo, int n_IdTipoDocumento) { CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; miFun.ObtenerMesValido(n_IdEmpresa, n_AnoTrabajo, n_IdTipoDocumento); if (miFun.booOcurrioError == true) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } else { dtLista = miFun.dtLista; } return; }
public void Consulta2(string c_CadenaIn) { CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; miFun.Consulta2(c_CadenaIn); if (miFun.booOcurrioError == true) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } else { dtLista = miFun.dtLista; } return; }
public void Consulta3(int n_IdSocio) { CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; miFun.Consulta3(n_IdSocio); if (miFun.booOcurrioError == true) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } else { dtLista = miFun.dtLista; } return; }
public void GenerarCargos(int n_IdEmpresa, int n_anotra, int n_mestra, string c_glosa, string c_fchini, string c_fchfin, int n_idtipdoc) { DataTable dtResul = new DataTable(); CD_coo_cargos miFun = new CD_coo_cargos(); miFun.mysConec = mysConec; miFun.GenerarCargos(n_IdEmpresa, n_anotra, n_mestra, c_glosa, c_fchini, c_fchfin, n_idtipdoc); if (miFun.booOcurrioError == true) { booOcurrioError = miFun.booOcurrioError; StrErrorMensaje = miFun.StrErrorMensaje; IntErrorNumber = miFun.IntErrorNumber; } else { dtCargosCab = miFun.dtCargosCab; dtCargosDet = miFun.dtCargosDet; } return; }
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; }