public bool ELiminar(int n_Idregistro)
{
bool b_result = false;
CD_pla_destajouni miFun = new CD_pla_destajouni();
miFun.mysConec = mysConec;
b_result = miFun.Eliminar(n_Idregistro);
if (b_result == false)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return(b_result);
}
public bool Actualizar(BE_PLA_DESTAJOUNI e_Cargos, string c_ListaPlanilas, List <BE_PLA_DESTAJOUNIPLA> l_CargosPlanillas)
{
CD_pla_destajouni miFun = new CD_pla_destajouni();
bool booOk = false;
miFun.mysConec = mysConec;
booOk = miFun.Actualizar(e_Cargos, c_ListaPlanilas, l_CargosPlanillas);
if (booOk == false)
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return(booOk);
}
public bool TraerRegistro(int n_Idregistro)
{
bool b_result = false;
DataTable dtResult = new DataTable();
DataTable dtLista = new DataTable();
DataTable dtResultLis = new DataTable();
CD_pla_destajouni miFun = new CD_pla_destajouni();
int n_row = 0;
miFun.mysConec = mysConec;
b_result = miFun.TraerRegistro(n_Idregistro);
if (b_result == true)
{
dtResult = miFun.dtRegistro;
dtLista = miFun.dtLista;
dtPago = miFun.dtPago;
dtHora = miFun.dtHora;
dtPlanillas = miFun.dtPlanillas;
e_Cargos.n_idemp = Convert.ToInt32(dtResult.Rows[0]["n_idemp"]);
e_Cargos.n_id = Convert.ToInt32(dtResult.Rows[0]["n_id"]);
e_Cargos.n_idtipdoc = Convert.ToInt32(dtResult.Rows[0]["n_idtipdoc"]);
e_Cargos.c_numser = dtResult.Rows[0]["c_numser"].ToString();
e_Cargos.c_numdoc = dtResult.Rows[0]["c_numdoc"].ToString();
e_Cargos.d_fchreg = Convert.ToDateTime(dtResult.Rows[0]["d_fchreg"]);
e_Cargos.n_idres = Convert.ToInt32(dtResult.Rows[0]["n_idres"]);
e_Cargos.d_fchini = Convert.ToDateTime(dtResult.Rows[0]["d_fchini"]);
e_Cargos.d_fchfin = Convert.ToDateTime(dtResult.Rows[0]["d_fchfin"]);
//e_Cargos.n_numper = Convert.ToInt32(dtResult.Rows[0]["n_numper"]);
//e_Cargos.n_imptot = Convert.ToInt32(dtResult.Rows[0]["n_imptot"]);
e_Cargos.n_mestra = Convert.ToInt32(dtResult.Rows[0]["n_mestra"]);
e_Cargos.n_anotra = Convert.ToInt32(dtResult.Rows[0]["n_anotra"]);
e_Cargos.c_glo = dtResult.Rows[0]["c_glo"].ToString();
e_Cargos.n_idlocal = Convert.ToInt32(dtResult.Rows[0]["n_idlocal"]);
}
else
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return(b_result);
}
public bool Listar(int n_IdEmpresa, int n_AnoTrabajo, int n_MesTrabajo)
{
bool b_result = false;
CD_pla_destajouni miFun = new CD_pla_destajouni();
miFun.mysConec = mysConec;
if (miFun.Listar(n_IdEmpresa, n_AnoTrabajo, n_MesTrabajo) == true)
{
b_result = true;
dtLista = miFun.dtLista;
}
else
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
}
return(b_result);
}
public void VerTareasDia(int n_idPlanilla, int n_IdEmpleado, string c_FechaConsulta)
{
DataTable dtResult = new DataTable();
CD_pla_destajouni miFun = new CD_pla_destajouni();
string[,] arrCabeceraFlexFil = new string[11, 5];
miFun.mysConec = mysConec;
if (miFun.VerTareasDia(n_idPlanilla, n_IdEmpleado, c_FechaConsulta) == true)
{
dtResult = miFun.dtLista;
}
else
{
b_OcurrioError = miFun.b_OcurrioError;
c_ErrorMensaje = miFun.c_ErrorMensaje;
n_ErrorNumber = miFun.n_ErrorNumber;
return;
}
// FLEX GRID DE LOS TAREAS
arrCabeceraFlexFil[0, 0] = "Apellidos y Nombres";
arrCabeceraFlexFil[0, 1] = "300";
arrCabeceraFlexFil[0, 2] = "C";
arrCabeceraFlexFil[0, 3] = "";
arrCabeceraFlexFil[0, 4] = "c_apenom";
arrCabeceraFlexFil[1, 0] = "Tarea";
arrCabeceraFlexFil[1, 1] = "300";
arrCabeceraFlexFil[1, 2] = "C";
arrCabeceraFlexFil[1, 3] = "";
arrCabeceraFlexFil[1, 4] = "c_des";
arrCabeceraFlexFil[2, 0] = "Fecha Trabajo";
arrCabeceraFlexFil[2, 1] = "70";
arrCabeceraFlexFil[2, 2] = "F";
arrCabeceraFlexFil[2, 3] = "";
arrCabeceraFlexFil[2, 4] = "d_fchtar";
arrCabeceraFlexFil[3, 0] = "Nº Sol. Tarea";
arrCabeceraFlexFil[3, 1] = "100";
arrCabeceraFlexFil[3, 2] = "C";
arrCabeceraFlexFil[3, 3] = "";
arrCabeceraFlexFil[3, 4] = "c_soltarnumdoc";
arrCabeceraFlexFil[4, 0] = "Tipo";
arrCabeceraFlexFil[4, 1] = "80";
arrCabeceraFlexFil[4, 2] = "C";
arrCabeceraFlexFil[4, 3] = "";
arrCabeceraFlexFil[4, 4] = "c_tiptar";
arrCabeceraFlexFil[5, 0] = "Hor. Ini.";
arrCabeceraFlexFil[5, 1] = "40";
arrCabeceraFlexFil[5, 2] = "C";
arrCabeceraFlexFil[5, 3] = "";
arrCabeceraFlexFil[5, 4] = "c_horini";
arrCabeceraFlexFil[6, 0] = "Hor. Ter.";
arrCabeceraFlexFil[6, 1] = "40";
arrCabeceraFlexFil[6, 2] = "C";
arrCabeceraFlexFil[6, 3] = "";
arrCabeceraFlexFil[6, 4] = "c_horter";
arrCabeceraFlexFil[7, 0] = "Can. Prod.";
arrCabeceraFlexFil[7, 1] = "70";
arrCabeceraFlexFil[7, 2] = "D";
arrCabeceraFlexFil[7, 3] = "0.00";
arrCabeceraFlexFil[7, 4] = "n_can";
arrCabeceraFlexFil[8, 0] = "Tiempo";
arrCabeceraFlexFil[8, 1] = "60";
arrCabeceraFlexFil[8, 2] = "C";
arrCabeceraFlexFil[8, 3] = "";
arrCabeceraFlexFil[8, 4] = "c_numhortra";
arrCabeceraFlexFil[9, 0] = "Nº Horas";
arrCabeceraFlexFil[9, 1] = "60";
arrCabeceraFlexFil[9, 2] = "D";
arrCabeceraFlexFil[9, 3] = "0.00";
arrCabeceraFlexFil[9, 4] = "n_numhortra";
arrCabeceraFlexFil[10, 0] = "Importe";
arrCabeceraFlexFil[10, 1] = "80";
arrCabeceraFlexFil[10, 2] = "D";
arrCabeceraFlexFil[10, 3] = "0.00";
arrCabeceraFlexFil[10, 4] = "n_imppaghrstra";
xFunGen.Filtrar_Titulo = "TAREAS REALIZADAS X DIA";
dtResult = xFunGen.MostrarDatos(arrCabeceraFlexFil, dtResult);
}
