protected void grdPlanesActivos_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
if (LosPlanesActivos[e.NewSelectedIndex].FechaFin == null)
{
ElPlanAModificar = LosPlanesActivos[e.NewSelectedIndex];
pnlModificarPlan.Visible = true;
List <string> lstTipo = new List <string>()
{
ElPlanAModificar.Tipo
};
ddlTipoPlanModificar.DataSource = lstTipo;
ddlTipoPlanModificar.DataBind();
ddlTipoPlanModificar.Enabled = false;
cboEvaluacionModificar.Checked = ElPlanAModificar.Evaluacion;
cboEvaluacionModificar.Enabled = false;
cboTratamientoModificar.Checked = ElPlanAModificar.Tratamiento;
cboTratamientoModificar.Enabled = false;
DateTime dFN = DateTime.Parse(ElPlanAModificar.FechaInicio);
txtFechaInicioModificar.Text = dFN.ToString("yyyy-MM-dd");
txtFechaInicioModificar.Enabled = false;
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: El Plan al que solicitar ingresar la fecha de vencimiento ya tiene una.')", true);
}
}
private void InitcboPlan()
{
cPlan oPlan = new cPlan();
string strMessage = string.Empty,
strCriteria = string.Empty,
strplan_code = string.Empty;
string strYear = cboYear.SelectedValue;
strplan_code = cboPlan_code.SelectedValue;
int i;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
strCriteria = " and plan_year = '" + strYear + "' and c_active='Y' ";
strCriteria = strCriteria + " And budget_type ='" + this.BudgetType + "' ";
if (oPlan.SP_SEL_PLAN(strCriteria, ref ds, ref strMessage))
{
dt = ds.Tables[0];
cboPlan_code.Items.Clear();
cboPlan_code.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", ""));
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
cboPlan_code.Items.Add(new ListItem(dt.Rows[i]["plan_name"].ToString(), dt.Rows[i]["plan_code"].ToString()));
}
if (cboPlan_code.Items.FindByValue(strplan_code) != null)
{
cboPlan_code.SelectedIndex = -1;
cboPlan_code.Items.FindByValue(strplan_code).Selected = true;
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
Label lblplan_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblplan_code");
cPlan oPlan = new cPlan();
try
{
if (!oPlan.SP_DEL_PLAN(lblplan_code.Text, "N", strUpdatedBy, ref strMessage))
{
lblError.Text = strMessage;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oPlan.Dispose();
}
BindGridView(0);
}
public static bool Eliminar(cPlan parPlan)
{
bool bRetorno = true;
try
{
var vConn = new SqlConnection(CadenaDeConexion);
vConn.Open();
SqlCommand cmd = new SqlCommand("Planes_Eliminar", vConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PlanId", parPlan.Codigo));
int iRtn = cmd.ExecuteNonQuery();
if (iRtn <= 0)
{
bRetorno = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(bRetorno);
}
public static bool ModificarFechaVencimiento(cPlan parPlan)
{
bool bRetorno = true;
try
{
var vConn = new SqlConnection(CadenaDeConexion);
vConn.Open();
SqlCommand cmd = new SqlCommand("Planes_ModificarFechaVencimiento", vConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PlanId", parPlan.Codigo));
cmd.Parameters.Add(new SqlParameter("@PlanFechaFin", parPlan.FechaFin));
int iRtn = cmd.ExecuteNonQuery();
if (iRtn <= 0)
{
bRetorno = false;
}
if (vConn.State == ConnectionState.Open)
{
vConn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(bRetorno);
}
protected void btnAgregarPlan_Click(object sender, EventArgs e)
{
if (!FaltanDatosPlan())
{
if (LosPlanes == null)
{
LosPlanes = new List <cPlan>();
}
cPlan unPlan = new cPlan();
unPlan.Activo = true;
unPlan.Evaluacion = cbEvaluacion.Checked;
unPlan.Tratamiento = cbTratamiento.Checked;
unPlan.Tipo = ddlTipoPlanes.SelectedItem.Text;
if (txtHasta.Text != string.Empty)
{
unPlan.FechaFin = txtHasta.Text;
}
if (txtDesde.Text != string.Empty)
{
unPlan.FechaInicio = txtDesde.Text;
}
LosPlanes.Add(unPlan);
lblMensajePlan.Text = "Plan agregado correctamente al beneficiario";
ActualizarGrdPlanes();
LimpiarCamposPlan();
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Faltan registrar datos para agregar el plan.')", true);
}
}
private void setData()
{
cPlan oPlan = new cPlan();
DataSet ds = new DataSet();
string strMessage = string.Empty, strCriteria = string.Empty;
string strplan_code = string.Empty,
strplan_name = string.Empty,
strYear = string.Empty,
strC_active = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty,
strCreatedDate = string.Empty,
strUpdatedDate = string.Empty;
try
{
strCriteria = " and plan_code = '" + ViewState["plan_code"].ToString() + "' ";
if (!oPlan.SP_SEL_PLAN(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
#region get Data
strplan_code = ds.Tables[0].Rows[0]["plan_code"].ToString();
strplan_name = ds.Tables[0].Rows[0]["plan_name"].ToString();
strYear = ds.Tables[0].Rows[0]["plan_year"].ToString();
strC_active = ds.Tables[0].Rows[0]["c_active"].ToString();
strCreatedBy = ds.Tables[0].Rows[0]["c_created_by"].ToString();
strUpdatedBy = ds.Tables[0].Rows[0]["c_updated_by"].ToString();
strCreatedDate = ds.Tables[0].Rows[0]["d_created_date"].ToString();
strUpdatedDate = ds.Tables[0].Rows[0]["d_updated_date"].ToString();
#endregion
#region set Control
txtplan_code.Text = strplan_code;
txtplan_name.Text = strplan_name;
txtyear.Text = strYear;
if (strC_active.Equals("Y"))
{
chkStatus.Checked = true;
}
else
{
chkStatus.Checked = false;
}
txtUpdatedBy.Text = strUpdatedBy;
txtUpdatedDate.Text = strUpdatedDate;
#endregion
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
public static List <cPlan> TraerActivosPorBeneficiario(cBeneficiario parBeneficiario)
{
List <cPlan> lstRetorno = new List <cPlan>();
cPlan unPlan;
try
{
var vConn = new SqlConnection(CadenaDeConexion);
vConn.Open();
SqlCommand cmd = new SqlCommand("Planes_TraerActivosPorBeneficiario", vConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@BeneficiarioId", parBeneficiario.Codigo));
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
unPlan = new cPlan();
unPlan.Codigo = int.Parse(oReader["PlanId"].ToString());
unPlan.Tipo = oReader["PlanTipo"].ToString();
unPlan.Tratamiento = bool.Parse(oReader["PlanTratamiento"].ToString());
unPlan.Evaluacion = bool.Parse(oReader["PlanEvaluacion"].ToString());
unPlan.FechaInicio = oReader["PlanFechaInicio"].ToString();
string[] aSs = unPlan.FechaInicio.Split(' ');
unPlan.FechaInicio = aSs[0];
if (oReader["PlanFechaFin"] != DBNull.Value)
{
unPlan.FechaFin = oReader["PlanFechaFin"].ToString();
string[] aSa = unPlan.FechaFin.Split(' ');
unPlan.FechaFin = aSa[0];
}
unPlan.Activo = bool.Parse(oReader["PlanActivo"].ToString());
unPlan.Activo = bool.Parse(oReader["PlanActivo"].ToString());
lstRetorno.Add(unPlan);
}
}
vConn.Close();
}
catch (Exception ex)
{
throw ex;
}
return(lstRetorno);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
Label lblplan_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblplan_code");
cPlan oPlan = new cPlan();
try
{
if (!oPlan.SP_DEL_PLAN(lblplan_code.Text, "N", strUpdatedBy, ref strMessage))
{
if (strMessage.Contains("REFERENCE constraint"))
{
MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว");
}
else
{
lblError.Text = strMessage;
}
}
}
catch (Exception ex)
{
if (ex.Message.Contains("REFERENCE constraint"))
{
MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว");
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
oPlan.Dispose();
}
BindGridView(0);
}
protected void btnAgregarPlan_Click(object sender, EventArgs e)
{
if (!FaltanDatosPlan())
{
if ((txtHasta.Text != string.Empty && (DateTime.Parse(txtDesde.Text) <= DateTime.Parse(txtHasta.Text))) || txtHasta.Text == string.Empty)
{
cPlan unPlan = new cPlan();
unPlan.Activo = true;
unPlan.Evaluacion = cbEvaluacion.Checked;
unPlan.Tratamiento = cbTratamiento.Checked;
unPlan.Tipo = ddlTipos.SelectedItem.Text;
unPlan.FechaInicio = txtDesde.Text;
if (txtHasta.Text != string.Empty)
{
unPlan.FechaFin = txtHasta.Text;
}
ElBeneficiario.lstPlanes = new List <cPlan>();
ElBeneficiario.lstPlanes.Add(unPlan);
if (dFachada.PlanAgregar(ElBeneficiario))
{
lblMensajeAgregarPlan.Text = "Plan agregado correctamente al beneficiario";
LimpiarCamposPlan();
ActualizarTodo();
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: No se puedo agregar el plan.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: La fecha de fin del plan debe ser mayor a la de inicio.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Faltan ingresar datos para registrar el plan.')", true);
}
}
public void LoadPlan(Int64 PlanID)
{
cPlans ps = new cPlans();
cPlan p = ps.GetSinglePlan(PlanID);
this.txtPlanName.Text = p.PlanName;
this.txtPlanID.Text = p.PlanID.ToString();
this.txtPlanDemo.Text = p.PlanRemark;
this.txtPlanState.Text = cGlobalParas.ConvertName(p.PlanState);
if (p.IsOverRun == true)
{
this.cboxIsRun.Checked = true;
}
else
{
this.cboxIsRun.Checked = false;
}
if (p.IsDisabled == true)
{
this.cboxIsDisabled.Checked = true;
}
else
{
this.cboxIsDisabled.Checked = false;
}
if (p.DisabledType == (int)cGlobalParas.PlanDisabledType.RunTime)
{
this.raNumber.Checked = true;
}
else if (p.DisabledType == (int)cGlobalParas.PlanDisabledType.RunDateTime)
{
this.raDateTime.Checked = true;
}
this.DisabledRunNum.Value = p.DisabledTime;
this.DisabledDateTime.Value = p.DisabledDateTime;
ListViewItem litem;
for (int i = 0; i < p.RunTasks.Count; i++)
{
litem = new ListViewItem();
litem.Text = cGlobalParas.ConvertName(p.RunTasks[i].RunTaskType);
if (p.RunTasks[i].RunTaskType == (int)cGlobalParas.RunTaskType.DataTask)
{
litem.SubItems.Add(cGlobalParas.ConvertName(int.Parse(p.RunTasks[i].RunTaskName)));
}
else
{
litem.SubItems.Add(p.RunTasks[i].RunTaskName);
}
litem.SubItems.Add(p.RunTasks[i].RunTaskPara);
this.listTask.Items.Add(litem);
}
this.EnabledDate.Value = DateTime.Parse(p.EnabledDateTime);
switch (p.RunTaskPlanType)
{
case (int)cGlobalParas.RunTaskPlanType.Ones:
this.raOneTime.Checked = true;
this.RunOnceTime.Value = DateTime.Parse(p.RunOnesTime);
break;
case (int)cGlobalParas.RunTaskPlanType.DayOnes:
this.raDay.Checked = true;
this.raRunones.Checked = true;
this.RunDayOnesTime.Value = DateTime.Parse(p.RunDayTime);
break;
case (int)cGlobalParas.RunTaskPlanType.DayTwice:
this.raDay.Checked = true;
this.raRuntwice.Checked = true;
this.RunDayTwice1Time.Value = DateTime.Parse(p.RunAMTime);
this.RunDayTwice2Time.Value = DateTime.Parse(p.RunPMTime);
break;
case (int)cGlobalParas.RunTaskPlanType.Weekly:
this.raWeekly.Checked = true;
this.RunWeeklyTime.Value = DateTime.Parse(p.RunWeeklyTime);
string rWeekly = p.RunWeekly;
foreach (string sc in rWeekly.Split(','))
{
string ss = sc.Trim();
switch (ss)
{
case "0":
this.cboxSunday.Checked = true;
break;
case "1":
this.cboxMonday.Checked = true;
break;
case "2":
this.cboxTuesday.Checked = true;
break;
case "3":
this.cboxWednesday.Checked = true;
break;
case "4":
this.cboxThursday.Checked = true;
break;
case "5":
this.cboxFriday.Checked = true;
break;
case "6":
this.cboxSunday.Checked = true;
break;
default:
break;
}
}
break;
case (int)cGlobalParas.RunTaskPlanType.Custom:
this.raCustom.Checked = true;
this.FirstRunTime.Value = DateTime.Parse(p.FirstRunTime);
this.udRunInterval.Value = decimal.Parse(p.RunInterval);
break;
}
p = null;
ps = null;
}
protected void btnAgregarBeneficiario_Click(object sender, EventArgs e)
{
if (!FaltanDatosBeneficiario())
{
#region cargar beneficiario
cBeneficiario unBeneficiario = new cBeneficiario();
unBeneficiario.Nombres = txtNombres.Text;
unBeneficiario.Apellidos = txtApellidos.Text;
unBeneficiario.CI = int.Parse(txtCi.Text);
unBeneficiario.FechaNacimiento = txtFechaNac.Text;
unBeneficiario.Domicilio = txtDomicilio.Text;
unBeneficiario.Telefono1 = txtTel1.Text;
unBeneficiario.Telefono2 = txtTel2.Text;
if (rblSexo.SelectedItem.Text == "Masculino")
{
unBeneficiario.Sexo = "M";
}
else
{
unBeneficiario.Sexo = "F";
}
if (cbPensionista.Checked)
{
unBeneficiario.Atributario = "Pensionista";
}
else
{
unBeneficiario.Atributario = txtAtributario.Text;
}
unBeneficiario.MotivoConsulta = txtMotivoConsulta.Text;
unBeneficiario.Escolaridad = txtEscolaridad.Text;
unBeneficiario.Derivador = txtDerivador.Text;
unBeneficiario.Email = txtEmail.Text;
unBeneficiario.Estado = false;
#endregion
if (dFachada.BeneficiarioTraerEspecificoCI(unBeneficiario) == null)
{
#region cargar plan
cPlan unPlan = new cPlan();
unPlan.Activo = false;
unPlan.Evaluacion = cbEvaluacion.Checked;
unPlan.Tratamiento = cbTratamiento.Checked;
unPlan.Tipo = ddlTipoPlanes.SelectedItem.Text;
unPlan.FechaInicio = txtDesde.Text;
unPlan.FechaFin = txtHasta.Text;
unBeneficiario.lstPlanes = new List <cPlan>();
unBeneficiario.lstPlanes.Add(unPlan);
#endregion
bool b = dFachada.BeneficiarioAgregar(unBeneficiario);
if (b)
{
unBeneficiario.lstPlanes = dFachada.PlanTraerTodosPorBeneficiario(unBeneficiario);
}
if (txtDesde.Text != string.Empty || txtHasta.Text != string.Empty)
{
if (DateTime.Parse(txtDesde.Text) < DateTime.Parse(txtHasta.Text))
{
if (cbTratamiento.Checked == true || cbEvaluacion.Checked == true)
{
bool bSeleccionada = false;
for (int i = 0; i < cblEspecialidades.Items.Count; i++)
{
if (cblEspecialidades.Items[i].Selected)
{
bSeleccionada = true;
}
}
if (bSeleccionada)
{
#region cargar lista de usuarios para las sesiones
// AGREGAR ESPECIALISTAS DE LAS ESPECIALIDADES SELECCIONADAS
List <cUsuario> lstUsuariosSesiones = new List <cUsuario>();
cEspecialidad unaEspecialidad;
for (int i = 0; i < cblEspecialidades.Items.Count; i++)
{
if (cblEspecialidades.Items[i].Selected)
{
bSeleccionada = true;
unaEspecialidad = new cEspecialidad();
unaEspecialidad.Nombre = cblEspecialidades.Items[i].Value;
lstUsuariosSesiones.Add(dFachada.UsuarioTraerPrimeroPorEspecialidad(unaEspecialidad));
}
}
#endregion
#region cargar primera sesion
cSesion unaPrimeraSesion = new cSesion();
unaPrimeraSesion.TipoSesion = cUtilidades.TipoSesion.Individual;
unaPrimeraSesion.Fecha = txtHasta.Text;
if (rblLocalidad.SelectedIndex == 0)
{
unaPrimeraSesion.Centro = cUtilidades.Centro.JuanLacaze;
}
else
{
unaPrimeraSesion.Centro = cUtilidades.Centro.NuevaHelvecia;
}
unaPrimeraSesion.HoraInicio = "08:00";
unaPrimeraSesion.HoraFin = "08:45";
cBeneficiarioSesion unBS = new cBeneficiarioSesion();
unBS.Beneficiario = unBeneficiario;
unBS.Plan = unBeneficiario.lstPlanes[0];
unBS.Estado = cUtilidades.EstadoSesion.Asistio;
unaPrimeraSesion.lstBeneficiarios = new List <cBeneficiarioSesion>();
unaPrimeraSesion.lstBeneficiarios.Add(unBS);
unaPrimeraSesion.Comentario = string.Empty;
unaPrimeraSesion.lstUsuarios = new List <cUsuario>();
unaPrimeraSesion.lstUsuarios = lstUsuariosSesiones;
#endregion
#region cargar ultima sesion
cSesion unaUltimaSesion = new cSesion();
unaUltimaSesion.TipoSesion = cUtilidades.TipoSesion.Individual;
unaUltimaSesion.Fecha = txtHasta.Text;
if (rblLocalidad.SelectedIndex == 0)
{
unaUltimaSesion.Centro = cUtilidades.Centro.JuanLacaze;
}
else
{
unaUltimaSesion.Centro = cUtilidades.Centro.NuevaHelvecia;
}
unaUltimaSesion.HoraInicio = "08:00";
unaUltimaSesion.HoraFin = "08:45";
cBeneficiarioSesion unBS1 = new cBeneficiarioSesion();
unBS1.Beneficiario = unBeneficiario;
unBS1.Plan = unBeneficiario.lstPlanes[0];
unBS1.Estado = cUtilidades.EstadoSesion.Asistio;
unaUltimaSesion.lstBeneficiarios = new List <cBeneficiarioSesion>();
unaUltimaSesion.lstBeneficiarios.Add(unBS1);
unaUltimaSesion.Comentario = string.Empty;
unaUltimaSesion.lstUsuarios = new List <cUsuario>();
unaUltimaSesion.lstUsuarios = lstUsuariosSesiones;
#endregion
#region cargar diagnostico
unBeneficiario.lstDiagnosticos = new List <cDiagnosticoBeneficiario>();
cDiagnosticoBeneficiario db;
for (int i = 0; i < LosDiagnosticosAgregados.Count; i++)
{
db = new cDiagnosticoBeneficiario();
db.Diagnostico = LosDiagnosticosAgregados[i];
db.Fecha = unaUltimaSesion.Fecha;
unBeneficiario.lstDiagnosticos.Add(db);
}
#endregion
if (b && dFachada.SesionAgregar(unaPrimeraSesion) &&
dFachada.SesionAgregar(unaUltimaSesion) &&
dFachada.DiagnosticoAgregarDiagnosticoBeneficiario(unBeneficiario))
{
lblMensajeBeneficiario.Text = "Beneficiario pasivo agregado correctamente.";
LimpiarCampos();
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: No se pudo concretar el registro del beneficiario.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Debe seleccionar las si el beneficiario asistía a tratamiento y/o evaluación.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Debe seleccionar las especialidades a las que asistía el beneficiario.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: La fecha de la primera sesión es mayor a la fecha de la última sesión .')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Debe seleccionar las fecha de la primera y última sesión del beneficiario.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Ya existe un beneficiario en el sistema con esa CI.')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('ERROR: Faltan datos del beneficiario.')", true);
}
}
public static bool PlanEliminar(cPlan parPlan)
{
return(dPlan.Eliminar(parPlan));
}
private void BindGridView(int nPageNo)
{
cPlan oPlan = new cPlan();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string strplan_code = string.Empty;
string strplan_name = string.Empty;
string strActive = string.Empty;
string strplan_year = string.Empty;
strplan_code = txtplan_code.Text.Replace("'", "''").Trim();
strplan_name = txtplan_name.Text.Replace("'", "''").Trim();
strplan_year = cboYear.SelectedValue;
if (!strplan_code.Equals("0"))
{
strCriteria = strCriteria + " And (plan_code like '%" + strplan_code + "%') ";
}
if (!strplan_name.Equals("0"))
{
strCriteria = strCriteria + " And (plan_name like '%" + strplan_name + "%')";
}
if (!strplan_year.Equals("0"))
{
strCriteria = strCriteria + " And (plan_year = '" + strplan_year + "') ";
}
if (RadioActive.Checked)
{
strCriteria = strCriteria + " And (c_active ='Y') ";
}
else if (RadioCancel.Checked)
{
strCriteria = strCriteria + " And (c_active ='N') ";
}
strCriteria = strCriteria + " And budget_type ='" + this.BudgetType + "' ";
try
{
if (!oPlan.SP_SEL_PLAN(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
try
{
GridView1.PageIndex = nPageNo;
txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString();
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString();
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
//if (this.BudgetType == "R")
//{
// foreach (Control c in Page.Controls)
// {
// base.SetLabel(c, "แผนงาน", "งานย่อย");
// }
//}
oPlan.Dispose();
ds.Dispose();
if (GridView1.Rows.Count > 0)
{
GridView1.TopPagerRow.Visible = true;
}
}
}
public static bool PlanModificarFechaVencimiento(cPlan parPlan)
{
return(dPlan.ModificarFechaVencimiento(parPlan));
}
private void BindGridView()
{
cPlan oplan = new cPlan();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string strplan_code = string.Empty;
string strplan_name = string.Empty;
string strScript = string.Empty;
string strplan_year = string.Empty;
strplan_code = txtplan_code.Text.Replace("'", "''").Trim();
strplan_name = txtplan_name.Text.Replace("'", "''").Trim();
strplan_year = txtplan_year.Text.Replace("'", "''").Trim();;
if (!strplan_code.Equals(""))
{
strCriteria = strCriteria + " And (plan_code like '%" + strplan_code + "%') ";
}
if (!strplan_name.Equals(""))
{
strCriteria = strCriteria + " And (plan_name like '%" + strplan_name + "%')";
}
if (!strplan_year.Equals(""))
{
strCriteria = strCriteria + " And (plan_year = '" + strplan_year + "') ";
}
strCriteria = strCriteria + " And (c_active ='Y') ";
try
{
if (oplan.SP_SEL_PLAN(strCriteria, ref ds, ref strMessage))
{
if (ds.Tables[0].Rows.Count == 1)
{
strplan_code = ds.Tables[0].Rows[0]["plan_code"].ToString();
strplan_name = ds.Tables[0].Rows[0]["plan_name"].ToString();
if (!ViewState["show"].ToString().Equals("1"))
{
strScript = "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl1"].ToString() + "').value='" + strplan_code + "';\n " +
"window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl2"].ToString() + "').value='" + strplan_name + "';\n" +
"ClosePopUp('" + ViewState["show"].ToString() + "');";
}
else
{
strScript = "window.parent.document.forms[0]." + ViewState["ctrl1"].ToString() + ".value='" + strplan_code + "';\n " +
"window.parent.document.forms[0]." + ViewState["ctrl2"].ToString() + ".value='" + strplan_name + "';\n" +
"ClosePopUp('" + ViewState["show"].ToString() + "');";
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "close", strScript, true);
}
else
{
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
else
{
lblError.Text = strMessage;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oplan.Dispose();
ds.Dispose();
}
}
private Int64 SaveTaskPlan()
{
cPlan NewPlan = new cPlan();
Int64 Nid = GetNewID();
if (Nid == 0)
{
throw new cSoukeyException(rm.GetString("Error21"));
}
NewPlan.PlanID = Nid;
NewPlan.PlanName = this.txtPlanName.Text;
NewPlan.PlanRemark = this.txtPlanDemo.Text;
//系统自动判断当前任务的状态
if (this.cboxIsDisabled.Checked == true)
{
if (this.raNumber.Checked == true)
{
if (this.DisabledRunNum.Value == 1 && DateTime.Compare(DateTime.Now, this.RunOnceTime.Value) > 0)
{
NewPlan.PlanState = (int)cGlobalParas.PlanState.Disabled;
}
else
{
NewPlan.PlanState = (int)cGlobalParas.PlanState.Enabled;
}
}
else if (this.raDateTime.Checked == true)
{
if (DateTime.Compare(DateTime.Now, this.DisabledDateTime.Value) < 0)
{
NewPlan.PlanState = (int)cGlobalParas.PlanState.Disabled;
}
else
{
NewPlan.PlanState = (int)cGlobalParas.PlanState.Enabled;
}
}
}
else
{
NewPlan.PlanState = (int)cGlobalParas.PlanState.Enabled;
}
if (this.cboxIsRun.Checked == true)
{
NewPlan.IsOverRun = true;
}
else
{
NewPlan.IsOverRun = false;
}
if (this.cboxIsDisabled.Checked == true)
{
NewPlan.IsDisabled = true;
}
else
{
NewPlan.IsDisabled = false;
}
if (this.raNumber.Checked == true)
{
NewPlan.DisabledType = (int)cGlobalParas.PlanDisabledType.RunTime;
}
else if (this.raDateTime.Checked == true)
{
NewPlan.DisabledType = (int)cGlobalParas.PlanDisabledType.RunDateTime;
}
NewPlan.DisabledTime = int.Parse(this.DisabledRunNum.Value.ToString());
NewPlan.DisabledDateTime = this.DisabledDateTime.Value;
cTaskPlan tp;
for (int i = 0; i < this.listTask.Items.Count; i++)
{
tp = new cTaskPlan();
tp.RunTaskType = cGlobalParas.ConvertID(this.listTask.Items[i].Text);
if (cGlobalParas.ConvertID(this.listTask.Items[i].Text) == (int)cGlobalParas.RunTaskType.DataTask)
{
tp.RunTaskName = cGlobalParas.ConvertID(this.listTask.Items[i].SubItems[1].Text.ToString()).ToString();
}
else
{
tp.RunTaskName = this.listTask.Items[i].SubItems[1].Text.ToString();
}
tp.RunTaskPara = this.listTask.Items[i].SubItems[2].Text.ToString();
NewPlan.RunTasks.Add(tp);
}
if (this.raOneTime.Checked == true)
{
NewPlan.RunTaskPlanType = (int)cGlobalParas.RunTaskPlanType.Ones;
}
else if (this.raDay.Checked == true)
{
if (this.raRunones.Checked == true)
{
NewPlan.RunTaskPlanType = (int)cGlobalParas.RunTaskPlanType.DayOnes;
}
else if (this.raRuntwice.Checked == true)
{
NewPlan.RunTaskPlanType = (int)cGlobalParas.RunTaskPlanType.DayTwice;
}
}
else if (this.raWeekly.Checked == true)
{
NewPlan.RunTaskPlanType = (int)cGlobalParas.RunTaskPlanType.Weekly;
}
else if (this.raCustom.Checked == true)
{
NewPlan.RunTaskPlanType = (int)cGlobalParas.RunTaskPlanType.Custom;
}
NewPlan.EnabledDateTime = this.EnabledDate.Value.ToLongDateString();
NewPlan.RunOnesTime = this.RunOnceTime.Value.ToString();
NewPlan.RunDayTime = this.RunDayOnesTime.Value.ToLongTimeString();
NewPlan.RunAMTime = this.RunDayTwice1Time.Value.ToLongTimeString();
NewPlan.RunPMTime = this.RunDayTwice2Time.Value.ToLongTimeString();
NewPlan.RunWeeklyTime = this.RunWeeklyTime.Value.ToLongTimeString();
NewPlan.FirstRunTime = this.FirstRunTime.Value.ToLongTimeString();
NewPlan.RunInterval = this.udRunInterval.Value.ToString();
string runWeekly = "";
if (this.cboxSunday.Checked == true)
{
runWeekly = "0";
}
if (this.cboxMonday.Checked == true)
{
runWeekly += ",1";
}
if (this.cboxTuesday.Checked == true)
{
runWeekly += ",2";
}
if (this.cboxWednesday.Checked == true)
{
runWeekly += ",3";
}
if (this.cboxThursday.Checked == true)
{
runWeekly += ",4";
}
if (this.cboxFriday.Checked == true)
{
runWeekly += ",5";
}
if (this.cboxSturday.Checked == true)
{
runWeekly += ",6";
}
NewPlan.RunWeekly = runWeekly;
cPlans p = new cPlans();
if (this.FormState == cGlobalParas.FormState.New)
{
p.InsertPlan(NewPlan);
}
else if (this.FormState == cGlobalParas.FormState.Edit)
{
p.EditPlan(NewPlan);
}
p = null;
return(Nid);
}
//加载计划,加载计划的时候需要对计划的状态进行维护
private void IniCheckPlan()
{
try
{
cXmlIO xmlConfig = new cXmlIO(Program.getPrjPath() + "tasks\\plan\\plan.xml");
DataView d = xmlConfig.GetData("descendant::Plans");
if (d == null)
{
return;
}
cPlan p;
for (int i = 0; i < d.Count; i++)
{
p = new cPlan();
if (int.Parse(d[i].Row["PlanState"].ToString()) == (int)cGlobalParas.PlanState.Enabled)
{
p.PlanID = Int64.Parse(d[i].Row["ID"].ToString());
p.PlanName = d[i].Row["PlanName"].ToString();
p.PlanState = int.Parse(d[i].Row["PlanState"].ToString());
p.IsOverRun = d[i].Row["IsOverRun"].ToString() == "True" ? true : false;
p.IsDisabled = d[i].Row["IsDisabled"].ToString() == "True" ? true : false;
p.DisabledType = int.Parse(d[i].Row["DisabledType"].ToString());
p.DisabledTime = int.Parse(d[i].Row["DisabledTime"].ToString());
p.DisabledDateTime = DateTime.Parse(d[i].Row["DisabledDateTime"].ToString());
p.RunTaskPlanType = int.Parse(d[i].Row["RunTaskPlanType"].ToString());
p.EnabledDateTime = d[i].Row["EnabledDateTime"].ToString();
p.RunOnesTime = d[i].Row["RunOnesTime"].ToString();
p.RunDayTime = d[i].Row["RunDayTime"].ToString();
p.RunAMTime = d[i].Row["RunAMTime"].ToString();
p.RunPMTime = d[i].Row["RunPMTime"].ToString();
p.RunWeeklyTime = d[i].Row["RunWeeklyTime"].ToString();
p.RunWeekly = d[i].Row["RunWeekly"].ToString();
p.RunTimeCount = d[i].Row["RunTimeCount"].ToString();
p.FirstRunTime = d[i].Row["FirstRunTime"].ToString();
p.RunInterval = d[i].Row["RunInterval"].ToString();
cTaskPlan tp;
DataView t = d[i].CreateChildView("Plan_Tasks")[0].CreateChildView("Tasks_Task");
for (int j = 0; j < t.Count; j++)
{
tp = new cTaskPlan();
tp.RunTaskType = int.Parse(t[j].Row["RunTaskType"].ToString());
tp.RunTaskName = t[j].Row["RunTaskName"].ToString();
tp.RunTaskPara = t[j].Row["RunTaskPara"].ToString();
p.RunTasks.Add(tp);
}
m_runTasks.Add(p);
}
}
p = null;
xmlConfig = null;
//自动维护计划状态
AutoState();
}
catch (System.Exception ex)
{
throw ex;
}
}
private bool saveData()
{
bool blnResult = false;
bool blnDup = false;
string strMessage = string.Empty;
string strplan_code = string.Empty,
strplan_year = string.Empty,
strplan_name = string.Empty,
strActive = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty;
string strScript = string.Empty;
cPlan oPlan = new cPlan();
DataSet ds = new DataSet();
try
{
#region set Data
strplan_code = txtplan_code.Text.Trim();
strplan_name = txtplan_name.Text;
strplan_year = cboYear.SelectedItem.Value;
if (chkStatus.Checked == true)
{
strActive = "Y";
}
else
{
strActive = "N";
}
strCreatedBy = Session["username"].ToString();
strUpdatedBy = Session["username"].ToString();
#endregion
if (ViewState["mode"].ToString().ToLower().Equals("edit"))
{
#region edit
if (!blnDup)
{
if (oPlan.SP_UPD_PLAN(strplan_code, strplan_year, strplan_name, strActive, strUpdatedBy, this.BudgetType, ref strMessage))
{
blnResult = true;
}
else
{
lblError.Text = strMessage.ToString();
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
}
#endregion
}
else
{
#region check dup
string strCheckDup = string.Empty;
strCheckDup = " and plan_name = '" + strplan_name.Trim() + "' and plan_year = '" + strplan_year + "' ";
if (!oPlan.SP_SEL_PLAN(strCheckDup, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
strScript =
"alert(\"ไม่สามารถเพิ่มข้อมูล เนื่องจากข้อมูล " + strplan_name.Trim() + " ปี " + strplan_year.Trim() + " ซ้ำ\");\n";
blnDup = true;
}
}
#endregion
#region insert
if (!blnDup)
{
if (oPlan.SP_INS_PLAN(strplan_year, strplan_name, strActive, strCreatedBy, this.BudgetType, ref strMessage))
{
string strGetcode = " and plan_name = '" + strplan_name.Trim() + "' and plan_year = '" + strplan_year + "' ";
if (!oPlan.SP_SEL_PLAN(strGetcode, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
if (ds.Tables[0].Rows.Count > 0)
{
strplan_code = ds.Tables[0].Rows[0]["plan_code"].ToString();
}
ViewState["plan_code"] = strplan_code;
blnResult = true;
}
else
{
lblError.Text = strMessage.ToString();
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
}
#endregion
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oPlan.Dispose();
}
return(blnResult);
}
private void setData()
{
cPlan oPlan = new cPlan();
DataSet ds = new DataSet();
string strMessage = string.Empty, strCriteria = string.Empty;
string strplan_code = string.Empty,
strplan_name = string.Empty,
strYear = string.Empty,
strC_active = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty,
strCreatedDate = string.Empty,
strUpdatedDate = string.Empty;
try
{
strCriteria = " and plan_code = '" + ViewState["plan_code"].ToString() + "' ";
if (!oPlan.SP_SEL_PLAN(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
#region get Data
strplan_code = ds.Tables[0].Rows[0]["plan_code"].ToString();
strplan_name = ds.Tables[0].Rows[0]["plan_name"].ToString();
strYear = ds.Tables[0].Rows[0]["plan_year"].ToString();
strC_active = ds.Tables[0].Rows[0]["c_active"].ToString();
strCreatedBy = ds.Tables[0].Rows[0]["c_created_by"].ToString();
strUpdatedBy = ds.Tables[0].Rows[0]["c_updated_by"].ToString();
strCreatedDate = ds.Tables[0].Rows[0]["d_created_date"].ToString();
strUpdatedDate = ds.Tables[0].Rows[0]["d_updated_date"].ToString();
#endregion
#region set Control
txtplan_code.Text = strplan_code;
txtplan_name.Text = strplan_name;
InitcboYear();
if (cboYear.Items.FindByValue(strYear) != null)
{
cboYear.SelectedIndex = -1;
cboYear.Items.FindByValue(strYear).Selected = true;
}
if (strC_active.Equals("Y"))
{
txtplan_name.ReadOnly = false;
txtplan_name.CssClass = "textbox";
chkStatus.Checked = true;
}
else
{
txtplan_name.ReadOnly = true;
txtplan_name.CssClass = "textboxdis";
chkStatus.Checked = false;
}
cboYear.Enabled = false;
cboYear.CssClass = "textboxdis";
txtUpdatedBy.Text = strUpdatedBy;
txtUpdatedDate.Text = strUpdatedDate;
#endregion
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
public static List <cBeneficiarioItinerario> TraerTodosPorItinerario(cItinerario parItinerario)
{
List <cBeneficiarioItinerario> lstRetorno = new List <cBeneficiarioItinerario>();
cBeneficiarioItinerario unBeneficiarioYPlan;
cBeneficiario unBeneficiario;
cPlan unPlan;
try
{
var vConn = new SqlConnection(CadenaDeConexion);
vConn.Open();
SqlCommand cmd = new SqlCommand("Beneficiarios_TraerPorItinerario", vConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ItinerarioId", parItinerario.Codigo));
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
unBeneficiarioYPlan = new cBeneficiarioItinerario();
unBeneficiario = new cBeneficiario();
unBeneficiario.Codigo = int.Parse(oReader["BeneficiarioId"].ToString());
unBeneficiario.Nombres = oReader["BeneficiarioNombres"].ToString();
unBeneficiario.Apellidos = oReader["BeneficiarioApellidos"].ToString();
unBeneficiario.CI = int.Parse(oReader["BeneficiarioCI"].ToString());
unBeneficiario.Sexo = oReader["BeneficiarioSexo"].ToString();
unBeneficiario.Telefono1 = oReader["BeneficiarioTelefono1"].ToString();
unBeneficiario.Telefono2 = oReader["BeneficiarioTelefono2"].ToString();
unBeneficiario.Domicilio = oReader["BeneficiarioDomicilio"].ToString();
unBeneficiario.Email = oReader["BeneficiarioEmail"].ToString();
unBeneficiario.FechaNacimiento = DateTime.Parse(oReader["BeneficiarioFechaNacimiento"].ToString()).ToShortDateString();
unBeneficiario.Atributario = oReader["BeneficiarioAtributario"].ToString();
unBeneficiario.MotivoConsulta = oReader["BeneficiarioMotivoConsulta"].ToString();
unBeneficiario.Escolaridad = oReader["BeneficiarioEscolaridad"].ToString();
unBeneficiario.Derivador = oReader["BeneficiarioDerivador"].ToString();
unBeneficiario.Estado = bool.Parse(oReader["BeneficiarioEstado"].ToString());
unPlan = new cPlan();
unPlan.Codigo = int.Parse(oReader["PlanId"].ToString());
unPlan.Tipo = oReader["PlanTipo"].ToString();
unPlan.Tratamiento = bool.Parse(oReader["PlanTratamiento"].ToString());
unPlan.Evaluacion = bool.Parse(oReader["PlanEvaluacion"].ToString());
unPlan.FechaInicio = DateTime.Parse(oReader["PlanFechaInicio"].ToString()).ToShortDateString();
if (oReader["PlanFechaFin"] != DBNull.Value)
{
unPlan.FechaFin = DateTime.Parse(oReader["PlanFechaFin"].ToString()).ToShortDateString();
}
unPlan.Activo = bool.Parse(oReader["PlanActivo"].ToString());
unBeneficiarioYPlan.Beneficiario = unBeneficiario;
unBeneficiarioYPlan.Plan = unPlan;
lstRetorno.Add(unBeneficiarioYPlan);
}
}
if (vConn.State == ConnectionState.Open)
{
vConn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(lstRetorno);
}