public bool Insertar(BE_TES_CONCILIACION e_Conciliacion, List <BE_TES_CONCILIACIONDET> l_ConciliacionDetalle)
{
CD_tes_conciliacion miFun = new CD_tes_conciliacion();
bool booOk = false;
miFun.mysConec = mysConec;
booOk = miFun.Insertar(e_Conciliacion, l_ConciliacionDetalle);
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
return(booOk);
}
public bool Eliminar(int n_IdRegistro)
{
bool booResult = false;
CD_tes_conciliacion miFun = new CD_tes_conciliacion();
miFun.mysConec = mysConec;
booResult = miFun.Eliminar(n_IdRegistro);
if (booResult == false)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return(booResult);
}
public void TraerParaConciliacion(int n_IdEmpresa, int n_MesTrabajo, int n_IdBanco, int n_AnoTrabajo)
{
CD_tes_conciliacion miFun = new CD_tes_conciliacion();
miFun.mysConec = mysConec;
miFun.TraerParaConciliacion(n_IdEmpresa, n_MesTrabajo, n_IdBanco, n_AnoTrabajo);
dtLista = miFun.dtLista;
if (miFun.b_OcurrioError == true)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return;
}
public void TraerRegistro(int n_IdRegistro)
{
DataTable dtResult = new DataTable();
bool booResult;
CD_tes_conciliacion miFun = new CD_tes_conciliacion();
miFun.mysConec = mysConec;
booResult = miFun.TraerRegistro(n_IdRegistro);
dtResult = miFun.dtLista;
dtListaDet = miFun.dtListaDet;
if (miFun.b_OcurrioError == false)
{
if (dtResult.Rows.Count != 0)
{
e_Conci.n_idemp = Convert.ToInt32(dtResult.Rows[0]["n_idemp"]);
e_Conci.n_id = Convert.ToInt32(dtResult.Rows[0]["n_id"]);
e_Conci.n_idmes = Convert.ToInt32(dtResult.Rows[0]["n_idmes"]);
e_Conci.n_idcue = Convert.ToInt32(dtResult.Rows[0]["n_idcue"]);
e_Conci.n_saliniban = Convert.ToDouble(dtResult.Rows[0]["n_saliniban"]);
e_Conci.n_salfinban = Convert.ToDouble(funFun.NulosN(dtResult.Rows[0]["n_salfinban"]));
e_Conci.d_fchcon = Convert.ToDateTime(dtResult.Rows[0]["d_fchcon"]);
e_Conci.c_glo = dtResult.Rows[0]["c_glo"].ToString();
e_Conci.n_idper = Convert.ToInt32(dtResult.Rows[0]["n_idper"]);
e_Conci.n_salfin = Convert.ToDouble(funFun.NulosN(dtResult.Rows[0]["n_salfin"]));
e_Conci.n_toting = Convert.ToDouble(funFun.NulosN(dtResult.Rows[0]["n_toting"]));
e_Conci.n_totegr = Convert.ToDouble(funFun.NulosN(dtResult.Rows[0]["n_totegr"]));
}
}
else
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return;
}
public DataTable PendientesOtrosMeses(int n_IdEmpresa, int n_IdCuentaBanco, int n_IdPeriodo)
{
DataTable dtResult = new DataTable();
CD_tes_conciliacion o_Conci = new CD_tes_conciliacion();
string[,] arrCabeceraFlex1 = new string[12, 5];
string c_Fecha = "01/" + n_IdPeriodo.ToString("00") + "/" + STU_SISTEMA.ANOTRABAJO;
o_Conci.mysConec = mysConec;
o_Conci.TraerPenidentesOtroMes(n_IdEmpresa, n_IdCuentaBanco, c_Fecha);
dtResult = o_Conci.dtLista;
// FLEX GRID DE LOS TAREAS
arrCabeceraFlex1[0, 0] = "Nº Registro";
arrCabeceraFlex1[0, 1] = "60";
arrCabeceraFlex1[0, 2] = "C";
arrCabeceraFlex1[0, 3] = "";
arrCabeceraFlex1[0, 4] = "c_numreg";
arrCabeceraFlex1[1, 0] = "T.D.";
arrCabeceraFlex1[1, 1] = "40";
arrCabeceraFlex1[1, 2] = "C";
arrCabeceraFlex1[1, 3] = "";
arrCabeceraFlex1[1, 4] = "c_abr";
arrCabeceraFlex1[2, 0] = "Nº Documento";
arrCabeceraFlex1[2, 1] = "110";
arrCabeceraFlex1[2, 2] = "C";
arrCabeceraFlex1[2, 3] = "";
arrCabeceraFlex1[2, 4] = "c_openumdoc";
arrCabeceraFlex1[3, 0] = "Fch. Operacion";
arrCabeceraFlex1[3, 1] = "70";
arrCabeceraFlex1[3, 2] = "F";
arrCabeceraFlex1[3, 3] = "dd/MM/yyyy";
arrCabeceraFlex1[3, 4] = "d_fchope";
arrCabeceraFlex1[4, 0] = "Medio Pago";
arrCabeceraFlex1[4, 1] = "150";
arrCabeceraFlex1[4, 2] = "C";
arrCabeceraFlex1[4, 3] = "";
arrCabeceraFlex1[4, 4] = "c_des3";
arrCabeceraFlex1[5, 0] = "Glosa";
arrCabeceraFlex1[5, 1] = "150";
arrCabeceraFlex1[5, 2] = "C";
arrCabeceraFlex1[5, 3] = "";
arrCabeceraFlex1[5, 4] = "c_glo";
arrCabeceraFlex1[6, 0] = "Debe";
arrCabeceraFlex1[6, 1] = "70";
arrCabeceraFlex1[6, 2] = "D";
arrCabeceraFlex1[6, 3] = "0.00";
arrCabeceraFlex1[6, 4] = "n_debe";
arrCabeceraFlex1[7, 0] = "Haber";
arrCabeceraFlex1[7, 1] = "70";
arrCabeceraFlex1[7, 2] = "D";
arrCabeceraFlex1[7, 3] = "0.00";
arrCabeceraFlex1[7, 4] = "n_haber";
arrCabeceraFlex1[8, 0] = "Check";
arrCabeceraFlex1[8, 1] = "40";
arrCabeceraFlex1[8, 2] = "B";
arrCabeceraFlex1[8, 3] = "";
arrCabeceraFlex1[8, 4] = "b_check";
arrCabeceraFlex1[9, 0] = "n_idtes";
arrCabeceraFlex1[9, 1] = "0";
arrCabeceraFlex1[9, 2] = "N";
arrCabeceraFlex1[9, 3] = "";
arrCabeceraFlex1[9, 4] = "n_idtes";
arrCabeceraFlex1[10, 0] = "n_idori";
arrCabeceraFlex1[10, 1] = "0";
arrCabeceraFlex1[10, 2] = "N";
arrCabeceraFlex1[10, 3] = "";
arrCabeceraFlex1[10, 4] = "n_idori";
arrCabeceraFlex1[11, 0] = "Indice";
arrCabeceraFlex1[11, 1] = "0";
arrCabeceraFlex1[11, 2] = "C";
arrCabeceraFlex1[11, 3] = "";
arrCabeceraFlex1[11, 4] = "c_indice";
funDatos.Filtrar_CampoOrden = "d_fchope";
funDatos.Filtrar_Titulo = "Operaciones Pendientes de Conciliacion";
funDatos.Filtrar_ColumnaCheck = 9;
funDatos.Filtrar_ColumnaBusqueda = 12;
funDatos.Filtrar_CampoBusqueda = "c_indice";
funDatos.Filtrar_AplicarFiltro = true;
dtResult = funDatos.Filtrar(arrCabeceraFlex1, dtResult);
return(dtResult);
}
