protected override void Recuperar_Registro()
{
if (cbElement.EditValue != null && cbMethod.EditValue != null)
{
tabMain.Visible = true;
int typeSol = Convert.ToInt32(treeSolution.FocusedNode.Tag);
if (template_method_aa == null)
template_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(cbMethod.EditValue)));
// --- recuperar group_solution
ModSolution modSolution = new ModSolution();
//group_solution = modSolution.GetGroupSolution(Convert.ToInt32(cbElement.EditValue), template_method_aa.Medium, template_method_aa.Modif, template_method_aa.Idtemplate_method, typeSol);
if (group_solution == null)
{
group_solution = modSolution.GetGroupSolution(template_method_aa.Idtemplate_method, typeSol);
if (group_solution == null)
{
PreparedNewGroup();
}
else
{
GetDetailGroup(group_solution);
}
}
else
GetDetailGroup(group_solution);
}
}
void ShowStatusControls(CGroup_solution oGroup_solution)
{
if (oGroup_solution.Type_solution == 1) // Estandar de calibracion
{
// --- show panels
tabSupCalib.PageVisible = true;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = false;
// --- status control
ucCalibStd1.ApplyStatus();
}
else if (oGroup_solution.Type_solution == 2 ||
oGroup_solution.Type_solution == 3 ||
oGroup_solution.Type_solution == 4) // Soluciones intermedias y estandares de verificación
{
// --- show panels
tabSupCalib.PageVisible = false;
tabSupSolInterm.PageVisible = true;
tabSupTitration.PageVisible = false;
}
else if (oGroup_solution.Type_solution == 5) // soluciones titulantes
{
// --- show panels
tabSupCalib.PageVisible = false;
tabSupSolInterm.PageVisible = false;
tabSupTitration.PageVisible = true;
}
}
private void ucSolInterm1_onSignSolInterm(CGroup_solution e)
{
// inicializar el arbol
InitTree();
// seleccionar el nuevo nodo agregado
FindAndFocusNode(e);
}
void Recuperate_calib(CGroup_solution group_solution)
{
// --- recuperar metodos
ucMethodCalib.Init(group_solution);
// --- recuperar absorbancias de cada calibración.
ucCalibStd1.Enabled = true;
ucCalibStd1.Init(group_solution, ucMethodCalib.LstTemplate_method);
}
public List <CSolution> GetLstSolution(CGroup_solution p_group_solution)
{
List <CSolution> lst =
(from m in new CSolutionFactory().GetAll()
where m.Idgroup_solution == p_group_solution.Idgroup_solution
select m).ToList();
return(lst);
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CGroup_solution</returns>
internal List <CGroup_solution> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CGroup_solution> list = new List <CGroup_solution>();
while (dataReader.Read())
{
CGroup_solution businessObject = new CGroup_solution();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
private void ucCalibStd1_onNewCalib(CGroup_solution e)
{
// --- mensaje que se agregó una nueva calibración
FormMessage fmMessage = new FormMessage();
fmMessage.Message = "Se agregó la calibración " + e.Cod_solution;
if (fmMessage.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
// --- inicializar el arbol
InitTree();
// --- seleccionar el nuevo nodo agregado
FindAndFocusNode(e);
}
}
void PreparedNewGroup()
{
// --- no existe una coincidencia para el pivot seleccionado.
group_solution = new CGroup_solution();
group_solution.Idelement = Convert.ToInt32(cbElement.EditValue);
group_solution.Idtemplate_method = template_method_aa.Idtemplate_method;
// listar los tabuladores
if (TypeSolution == 1) // calibraciones
{
tabSupCalib.PageVisible = true;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = false;
group_solution.Type_solution = Convert.ToInt32(TypeSolution);
group_solution.Idmr_detail = template_method_aa.Mrorpattern;
group_solution.Idreactive_medium = template_method_aa.Medium;
group_solution.Idreactive_modif = template_method_aa.Modif;
group_solution.Type_pattern = template_method_aa.Type_pattern;
// --- inicializar método
ucMethodCalib.Init(group_solution, template_method_aa);
}
else if (TypeSolution == 2 || TypeSolution == 3 || TypeSolution == 4) // solución intermedia y estandar de verificación
{
tabSupCalib.PageVisible = false;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = true;
group_solution.Type_solution = Convert.ToInt32(TypeSolution);
group_solution.Idreactive_medium = template_method_aa.Medium;
group_solution.Idreactive_modif = template_method_aa.Modif;
group_solution.Idmr_detail = Convert.ToInt16(template_method_aa.Std_mrorpattern);
group_solution.Type_pattern = template_method_aa.Std_type_pattern;
group_solution.Flag_sol_intermedia1 = template_method_aa.Std_flag_sol_intermedia1;
group_solution.Flag_sol_intermedia2 = template_method_aa.Std_flag_sol_intermedia2;
// --- inicializar método
ucSolInterm1.Init(group_solution);
}
else if (TypeSolution == 5) // solución titulante
{
tabSupCalib.PageVisible = false;
tabSupTitration.PageVisible = true;
tabSupSolInterm.PageVisible = false;
group_solution.Type_solution = Convert.ToInt32(TypeSolution);
//<PENDIENTE>
//ucMethodTitration.Init(group_solution, template_method_aa);
}
}
private void treeSolution_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
Clear_detail();
// --- recuperar data sólo si se seleccionó una solución existente
if (e.Node == treeStdCalib || e.Node == treeSolInterm1 || e.Node == treeSolInterm2 ||
e.Node == treeSolTitration || e.Node == treeStdVerif) // estos nodos son sólo nombres
{
gpTitle.Text = "";
gpTitle.Enabled = true;
group_solution = null;
TypeSolution = Convert.ToInt32(e.Node.Tag);
tabMain.Visible = false;
}
else // este nodo es un grupo existente
{
// --- recuperar filtros bloqueados
gpTitle.Enabled = false;
gpTitle.Text = "";
TypeSolution = Convert.ToInt32(e.Node.Tag);
tabMain.Visible = true;
cbElement.EditValue = null;
cbMethod.EditValue = null;
// --- recuperar datos
// calibraciones: recuperar datos de calibraciones
// soluciones intermedias: recuperar el grupo o raiz de soluciones
// estandar de verificacion: recuperar el grupo o raiz de soluciones
int?idgroup_solution = null;
if (treeSolution.FocusedNode["Idgroup_solution"] != null)
{
idgroup_solution = Convert.ToInt32(treeSolution.FocusedNode["Idgroup_solution"]);
}
if (idgroup_solution != null)
{
group_solution = new CGroup_solutionFactory().GetByPrimaryKey(new CGroup_solutionKeys(Convert.ToInt32(idgroup_solution)));
// --- recuperar titulo
if (group_solution != null)
{
cbElement.EditValue = Convert.ToInt16(group_solution.Idelement);
cbMethod.EditValue = group_solution.Idtemplate_method;
}
}
}
}
public void Init(CGroup_solution p_group_solution)
{
group_solution = p_group_solution;
if (p_group_solution.Idtemplate_method != null)
{
template_method_aa =
new CTemplate_method_aaFactory()
.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(p_group_solution.Idtemplate_method)));
}
InitCombos();
InitHeader();
InitTreeSolution();
ShowStatusButtons();
}
public void Init(CGroup_solution p_group_solution, BindingList <CCustom_method_solution> lstTemplate_method)
{
group_solution = p_group_solution;
LstTemplate_method = lstTemplate_method;
if (p_group_solution.Idtemplate_method != null)
{
template_method_aa =
new CTemplate_method_aaFactory()
.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(p_group_solution.Idtemplate_method)));
}
InitCombos();
InitHeader();
InitTreeSolution();
}
void GetDetailGroup(CGroup_solution group_solution)
{
// --- recuperar datos
// calibraciones: recuperar datos de calibraciones
// soluciones intermedias: recuperar el grupo o raiz de soluciones
// estandar de verificacion: recuperar el grupo o raiz de soluciones
// --- recuperar titulo
if (group_solution != null)
{
group_solution.Idtemplate_method = template_method_aa.Idtemplate_method;
// --- recuperar filtros bloqueados
gpTitle.Enabled = false;
gpTitle.Text = "";
TypeSolution = Convert.ToInt32(group_solution.Type_solution);
tabMain.Visible = true;
if (group_solution.Cod_solution == null)
{
gpTitle.Text = "";
}
else
{
gpTitle.Text = group_solution.Cod_solution;
}
gpTitle.Enabled = false;
cbElement.EditValue = Convert.ToInt16(group_solution.Idelement);
// --- mostrar tabuladores principales
ShowStatusControls(group_solution);
// --- recuperar calibraciones
if (group_solution.Type_solution == 1)
{
Recuperate_calib(group_solution);
}
// --- recuperar soluciones intermedias
else if (group_solution.Type_solution == 2 || group_solution.Type_solution == 3 || group_solution.Type_solution == 4)
{
Recuperate_SolInterm(group_solution);
}
}
}
void Recuperate_SolInterm(CGroup_solution group_solution)
{
// --- inicilizar método
template_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(group_solution.Idtemplate_method)));
// --- inicilizar grupo de solución
tabSupCalib.PageVisible = false;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = true;
///Determinar el límite a crear soluciones según el método seleccionado y
///los métodos ya presentes
///
List <CSolution> query = new CSolutionFactory().GetAll().Where(c => c.Idgroup_solution == group_solution.Idgroup_solution).ToList();
var query2 =
(from m in query
join n in new CSolution_methodsFactory().GetAll() on m.Idsolution equals n.Idsolution
join p in new CTemplate_method_aaFactory().GetAll() on n.Idtemplate_method equals p.Idtemplate_method
select new
{
flag1 = p.Std_flag_sol_intermedia1 == null ? false : p.Std_flag_sol_intermedia1,
flag2 = p.Std_flag_sol_intermedia2 == null ? false : p.Std_flag_sol_intermedia2
}).ToList();
foreach (var item in query2)
{
if (Convert.ToBoolean(item.flag1) == true)
{
group_solution.Flag_sol_intermedia1 = true;
}
if (Convert.ToBoolean(item.flag2) == true)
{
group_solution.Flag_sol_intermedia2 = true;
}
}
group_solution.Idreactive_medium = template_method_aa.Medium;
group_solution.Idreactive_modif = template_method_aa.Modif;
group_solution.Idmr_detail = Convert.ToInt16(template_method_aa.Std_mrorpattern);
group_solution.Type_pattern = template_method_aa.Std_type_pattern;
//group_solution.Flag_sol_intermedia1 = template_method_aa.Std_flag_sol_intermedia1;
//group_solution.Flag_sol_intermedia2 = template_method_aa.Std_flag_sol_intermedia2;
group_solution.Idtemplate_method = template_method_aa.Idtemplate_method;
// --- inicializar soluciones
ucSolInterm1.Init(group_solution);
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CGroup_solution business object</returns>
public CGroup_solution SelectByPrimaryKey(CGroup_solutionKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_group_solution_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_idgroup_solution", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idgroup_solution));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CGroup_solution businessObject = new CGroup_solution();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CGroup_solution::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
void FindAndFocusNode(CGroup_solution nodo)
{
if (nodo.Type_solution == 1)
{
FocusNode(treeStdCalib, nodo.Idgroup_solution);
}
if (nodo.Type_solution == 2)
{
FocusNode(treeSolInterm1, nodo.Idgroup_solution);
}
if (nodo.Type_solution == 3)
{
FocusNode(treeSolInterm2, nodo.Idgroup_solution);
}
if (nodo.Type_solution == 4)
{
FocusNode(treeStdVerif, nodo.Idgroup_solution);
}
if (nodo.Type_solution == 5)
{
FocusNode(treeSolTitration, nodo.Idgroup_solution);
}
}
protected override void Recuperar_Registro()
{
if (cbElement.EditValue != null && cbMethod.EditValue != null)
{
tabMain.Visible = true;
int typeSol = Convert.ToInt32(treeSolution.FocusedNode.Tag);
if (template_method_aa == null)
{
template_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(cbMethod.EditValue)));
}
// --- recuperar group_solution
ModSolution modSolution = new ModSolution();
//group_solution = modSolution.GetGroupSolution(Convert.ToInt32(cbElement.EditValue), template_method_aa.Medium, template_method_aa.Modif, template_method_aa.Idtemplate_method, typeSol);
if (group_solution == null)
{
group_solution = modSolution.GetGroupSolution(template_method_aa.Idtemplate_method, typeSol);
if (group_solution == null)
{
PreparedNewGroup();
}
else
{
GetDetailGroup(group_solution);
}
}
else
{
GetDetailGroup(group_solution);
}
}
}
private void treeSolution_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
Clear_detail();
// --- recuperar data sólo si se seleccionó una solución existente
if (e.Node == treeStdCalib || e.Node == treeSolInterm1 || e.Node == treeSolInterm2
|| e.Node == treeSolTitration || e.Node == treeStdVerif) // estos nodos son sólo nombres
{
gpTitle.Text = "";
gpTitle.Enabled = true;
group_solution = null;
TypeSolution = Convert.ToInt32(e.Node.Tag);
tabMain.Visible = false;
}
else // este nodo es un grupo existente
{
// --- recuperar filtros bloqueados
gpTitle.Enabled = false;
gpTitle.Text = "";
TypeSolution = Convert.ToInt32(e.Node.Tag);
tabMain.Visible = true;
cbElement.EditValue = null;
cbMethod.EditValue = null;
// --- recuperar datos
// calibraciones: recuperar datos de calibraciones
// soluciones intermedias: recuperar el grupo o raiz de soluciones
// estandar de verificacion: recuperar el grupo o raiz de soluciones
int? idgroup_solution = null;
if (treeSolution.FocusedNode["Idgroup_solution"] != null)
idgroup_solution = Convert.ToInt32(treeSolution.FocusedNode["Idgroup_solution"]);
if (idgroup_solution != null)
{
group_solution = new CGroup_solutionFactory().GetByPrimaryKey(new CGroup_solutionKeys(Convert.ToInt32(idgroup_solution)));
// --- recuperar titulo
if (group_solution != null)
{
cbElement.EditValue = Convert.ToInt16(group_solution.Idelement);
cbMethod.EditValue = group_solution.Idtemplate_method;
}
}
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CGroup_solution businessObject, IDataReader dataReader)
{
businessObject.Idgroup_solution = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idgroup_solution.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idelement.ToString())))
{
businessObject.Idelement = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idelement.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idtemplate_method.ToString())))
{
businessObject.Idtemplate_method = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idtemplate_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Flag_selected_methods.ToString())))
{
businessObject.Flag_selected_methods = dataReader.GetBoolean(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Flag_selected_methods.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Flag_close_calib.ToString())))
{
businessObject.Flag_close_calib = dataReader.GetBoolean(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Flag_close_calib.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Flag_sign_calib.ToString())))
{
businessObject.Flag_sign_calib = dataReader.GetBoolean(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Flag_sign_calib.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.User_sign_calib.ToString())))
{
businessObject.User_sign_calib = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.User_sign_calib.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Date_sign_calib.ToString())))
{
businessObject.Date_sign_calib = dataReader.GetDateTime(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Date_sign_calib.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Type_solution.ToString())))
{
businessObject.Type_solution = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Type_solution.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idreactive_medium.ToString())))
{
businessObject.Idreactive_medium = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idreactive_medium.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idreactive_modif.ToString())))
{
businessObject.Idreactive_modif = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idreactive_modif.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Type_pattern.ToString())))
{
businessObject.Type_pattern = dataReader.GetInt32(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Type_pattern.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idmr_detail.ToString())))
{
businessObject.Idmr_detail = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Idmr_detail.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Cod_solution.ToString())))
{
businessObject.Cod_solution = dataReader.GetString(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Cod_solution.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Date_ini.ToString())))
{
businessObject.Date_ini = dataReader.GetDateTime(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Date_ini.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Date_end.ToString())))
{
businessObject.Date_end = dataReader.GetDateTime(dataReader.GetOrdinal(CGroup_solution.CGroup_solutionFields.Date_end.ToString()));
}
}
void ShowStatusControls(CGroup_solution oGroup_solution)
{
if (oGroup_solution.Type_solution == 1) // Estandar de calibracion
{
// --- show panels
tabSupCalib.PageVisible = true;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = false;
// --- status control
ucCalibStd1.ApplyStatus();
}
else if (oGroup_solution.Type_solution == 2
|| oGroup_solution.Type_solution == 3
|| oGroup_solution.Type_solution == 4) // Soluciones intermedias y estandares de verificación
{
// --- show panels
tabSupCalib.PageVisible = false;
tabSupSolInterm.PageVisible = true;
tabSupTitration.PageVisible = false;
}
else if (oGroup_solution.Type_solution == 5) // soluciones titulantes
{
// --- show panels
tabSupCalib.PageVisible = false;
tabSupSolInterm.PageVisible = false;
tabSupTitration.PageVisible = true;
}
}
void Recuperate_SolInterm(CGroup_solution group_solution)
{
// --- inicilizar método
template_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(group_solution.Idtemplate_method)));
// --- inicilizar grupo de solución
tabSupCalib.PageVisible = false;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = true;
///Determinar el límite a crear soluciones según el método seleccionado y
///los métodos ya presentes
///
List<CSolution> query = new CSolutionFactory().GetAll().Where(c=> c.Idgroup_solution == group_solution.Idgroup_solution).ToList();
var query2 =
(from m in query
join n in new CSolution_methodsFactory().GetAll() on m.Idsolution equals n.Idsolution
join p in new CTemplate_method_aaFactory().GetAll() on n.Idtemplate_method equals p.Idtemplate_method
select new
{
flag1 = p.Std_flag_sol_intermedia1 == null ? false : p.Std_flag_sol_intermedia1,
flag2 = p.Std_flag_sol_intermedia2 == null ? false : p.Std_flag_sol_intermedia2
}).ToList();
foreach (var item in query2)
{
if (Convert.ToBoolean(item.flag1) == true)
group_solution.Flag_sol_intermedia1 = true;
if (Convert.ToBoolean(item.flag2) == true)
group_solution.Flag_sol_intermedia2 = true;
}
group_solution.Idreactive_medium = template_method_aa.Medium;
group_solution.Idreactive_modif = template_method_aa.Modif;
group_solution.Idmr_detail = Convert.ToInt16(template_method_aa.Std_mrorpattern);
group_solution.Type_pattern = template_method_aa.Std_type_pattern;
//group_solution.Flag_sol_intermedia1 = template_method_aa.Std_flag_sol_intermedia1;
//group_solution.Flag_sol_intermedia2 = template_method_aa.Std_flag_sol_intermedia2;
group_solution.Idtemplate_method = template_method_aa.Idtemplate_method;
// --- inicializar soluciones
ucSolInterm1.Init(group_solution);
}
void Recuperate_calib(CGroup_solution group_solution)
{
// --- recuperar metodos
ucMethodCalib.Init(group_solution);
// --- recuperar absorbancias de cada calibración.
ucCalibStd1.Enabled = true;
ucCalibStd1.Init(group_solution, ucMethodCalib.LstTemplate_method);
}
void PreparedNewGroup()
{
// --- no existe una coincidencia para el pivot seleccionado.
group_solution = new CGroup_solution();
group_solution.Idelement = Convert.ToInt32(cbElement.EditValue);
group_solution.Idtemplate_method = template_method_aa.Idtemplate_method;
// listar los tabuladores
if (TypeSolution == 1) // calibraciones
{
tabSupCalib.PageVisible = true;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = false;
group_solution.Type_solution = Convert.ToInt32(TypeSolution);
group_solution.Idmr_detail = template_method_aa.Mrorpattern;
group_solution.Idreactive_medium = template_method_aa.Medium;
group_solution.Idreactive_modif = template_method_aa.Modif;
group_solution.Type_pattern = template_method_aa.Type_pattern;
// --- inicializar método
ucMethodCalib.Init(group_solution, template_method_aa);
}
else if (TypeSolution == 2 || TypeSolution == 3 || TypeSolution == 4) // solución intermedia y estandar de verificación
{
tabSupCalib.PageVisible = false;
tabSupTitration.PageVisible = false;
tabSupSolInterm.PageVisible = true;
group_solution.Type_solution = Convert.ToInt32(TypeSolution);
group_solution.Idreactive_medium = template_method_aa.Medium;
group_solution.Idreactive_modif = template_method_aa.Modif;
group_solution.Idmr_detail = Convert.ToInt16(template_method_aa.Std_mrorpattern);
group_solution.Type_pattern = template_method_aa.Std_type_pattern;
group_solution.Flag_sol_intermedia1 = template_method_aa.Std_flag_sol_intermedia1;
group_solution.Flag_sol_intermedia2 = template_method_aa.Std_flag_sol_intermedia2;
// --- inicializar método
ucSolInterm1.Init(group_solution);
}
else if (TypeSolution == 5) // solución titulante
{
tabSupCalib.PageVisible = false;
tabSupTitration.PageVisible = true;
tabSupSolInterm.PageVisible = false;
group_solution.Type_solution = Convert.ToInt32(TypeSolution);
//<PENDIENTE>
//ucMethodTitration.Init(group_solution, template_method_aa);
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CGroup_solution businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_group_solution_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_idgroup_solution", businessObject.Idgroup_solution);
sqlCommand.Parameters["p_idgroup_solution"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters["p_idgroup_solution"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_idelement", businessObject.Idelement);
sqlCommand.Parameters["p_idelement"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_idtemplate_method", businessObject.Idtemplate_method);
sqlCommand.Parameters["p_idtemplate_method"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_flag_selected_methods", businessObject.Flag_selected_methods);
sqlCommand.Parameters["p_flag_selected_methods"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_flag_close_calib", businessObject.Flag_close_calib);
sqlCommand.Parameters["p_flag_close_calib"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_flag_sign_calib", businessObject.Flag_sign_calib);
sqlCommand.Parameters["p_flag_sign_calib"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_user_sign_calib", businessObject.User_sign_calib);
sqlCommand.Parameters["p_user_sign_calib"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_date_sign_calib", businessObject.Date_sign_calib);
sqlCommand.Parameters["p_date_sign_calib"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_type_solution", businessObject.Type_solution);
sqlCommand.Parameters["p_type_solution"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_idreactive_medium", businessObject.Idreactive_medium);
sqlCommand.Parameters["p_idreactive_medium"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_idreactive_modif", businessObject.Idreactive_modif);
sqlCommand.Parameters["p_idreactive_modif"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_type_pattern", businessObject.Type_pattern);
sqlCommand.Parameters["p_type_pattern"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_idmr_detail", businessObject.Idmr_detail);
sqlCommand.Parameters["p_idmr_detail"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_cod_solution", businessObject.Cod_solution);
sqlCommand.Parameters["p_cod_solution"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_date_ini", businessObject.Date_ini);
sqlCommand.Parameters["p_date_ini"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_date_end", businessObject.Date_end);
sqlCommand.Parameters["p_date_end"].NpgsqlDbType = NpgsqlDbType.Timestamp;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.Idgroup_solution = Convert.ToInt32(sqlCommand.Parameters["p_idgroup_solution"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CGroup_solution::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
void FindAndFocusNode(CGroup_solution nodo)
{
if (nodo.Type_solution == 1)
FocusNode(treeStdCalib, nodo.Idgroup_solution);
if (nodo.Type_solution == 2)
FocusNode(treeSolInterm1, nodo.Idgroup_solution);
if (nodo.Type_solution == 3)
FocusNode(treeSolInterm2, nodo.Idgroup_solution);
if (nodo.Type_solution == 4)
FocusNode(treeStdVerif, nodo.Idgroup_solution);
if (nodo.Type_solution == 5)
FocusNode(treeSolTitration, nodo.Idgroup_solution);
}
public void Init(CGroup_solution p_group_solution)
{
#region inicializar metodos
group_solution = p_group_solution;
// --- si existe el agrupador, hacer no editable la selección de métodos
if (group_solution.Idgroup_solution == 0)
{
// --- no existe agrupador
group_solution.Flag_selected_methods = false;
gvMethods.OptionsBehavior.Editable = true;
btConfirmSelMethods.Enabled = true;
}
else
{
// --- existe agrupador
group_solution.Flag_selected_methods = true;
gvMethods.OptionsBehavior.Editable = false;
btConfirmSelMethods.Enabled = false;
}
// --- show grids
ShowGrids();
#endregion
#region inicializar combos
// --- Inititalize list statusMr
CReactiveFactory faReactive = new CReactiveFactory();
List<CReactive> lstReactive = faReactive.GetAll();
lstReactive.Add(new CReactive() { Idreactive = 0, Reactive_name = "---", Chemical_formula = "---" });
cbMediumHead.Properties.DataSource = lstReactive;
cbMediumHead.Properties.ValueMember = "Idreactive";
cbMediumHead.Properties.DisplayMember = "Reactive_name";
cbModifHead.Properties.DataSource = lstReactive;
cbModifHead.Properties.ValueMember = "Idreactive";
cbModifHead.Properties.DisplayMember = "Reactive_name";
#endregion
#region inicializar datos según el filtro seleccionado
// Estandares de calibración.
if (group_solution.Type_solution == 1)
{
// --- recuperar cajas de textos no editables
cbTypePattern.EditValue = group_solution.Type_pattern;
cbMrcOrPatternHeader.EditValue = group_solution.Idmr_detail;
cbMediumHead.EditValue = group_solution.Idreactive_medium;
cbModifHead.EditValue = group_solution.Idreactive_modif;
// --- elemento, mr pattern, medio y modif
//TODO
//lstTemplate = modSolution.GetMethodsByMrcPattern(group_solution);
gcMethods.DataSource = lstTemplate;
}
// Soluciones intermedias 1 y 2 y estandares de verificación.
//else if (group_solution.Type_solution == 2
// || group_solution.Type_solution == 3)
//{
// // recuperar cajas de textos no editables
// cbTypePattern.EditValue = group_solution.Type_pattern;
// cbMrcOrPatternHeader.EditValue = group_solution.Idmr_detail;
// // elemento, mr pattern, sol intermedia (1 ó 2 implicito)
// // getLstMethods(group_solution, type_solution_intermedia)
// lstTemplate = modSolution.GetMethodsBySolInterm(group_solution, );
// gcMethods.DataSource = lstTemplate;
//}
#endregion
}
/*
1:Standar de Calibracion, 2:Solución Intermedia, 3:Estandar de Verificacion, 4:Soluciones titulantes
*/
public void Init(CGroup_solution p_group_solution, CTemplate_method_aa p_template_method_aa)
{
template_method_aa = p_template_method_aa;
Init(p_group_solution);
}
public void Init(CGroup_solution p_group_solution, BindingList<CCustom_method_solution> lstTemplate_method)
{
group_solution = p_group_solution;
LstTemplate_method = lstTemplate_method;
if (p_group_solution.Idtemplate_method != null)
template_method_aa =
new CTemplate_method_aaFactory()
.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(p_group_solution.Idtemplate_method)));
InitCombos();
InitHeader();
InitTreeSolution();
}
public void Init(CGroup_solution p_group_solution)
{
group_solution = p_group_solution;
if (p_group_solution.Idtemplate_method != null)
template_method_aa =
new CTemplate_method_aaFactory()
.GetByPrimaryKey(new CTemplate_method_aaKeys(Convert.ToInt32(p_group_solution.Idtemplate_method)));
InitCombos();
InitHeader();
InitTreeSolution();
ShowStatusButtons();
}
/*
* 1:Standar de Calibracion, 2:Solución Intermedia, 3:Estandar de Verificacion, 4:Soluciones titulantes
*/
public void Init(CGroup_solution p_group_solution, CTemplate_method_aa p_template_method_aa)
{
template_method_aa = p_template_method_aa;
Init(p_group_solution);
}
public void Init(CGroup_solution p_group_solution)
{
#region inicializar metodos
group_solution = p_group_solution;
// --- si existe el agrupador, hacer no editable la selección de métodos
if (group_solution.Idgroup_solution == 0)
{
// --- no existe agrupador
group_solution.Flag_selected_methods = false;
gvMethods.OptionsBehavior.Editable = true;
btConfirmSelMethods.Enabled = true;
}
else
{
// --- existe agrupador
group_solution.Flag_selected_methods = true;
gvMethods.OptionsBehavior.Editable = false;
btConfirmSelMethods.Enabled = false;
}
// --- show grids
ShowGrids();
#endregion
#region inicializar combos
// --- Inititalize list statusMr
CReactiveFactory faReactive = new CReactiveFactory();
List <CReactive> lstReactive = faReactive.GetAll();
lstReactive.Add(new CReactive()
{
Idreactive = 0, Reactive_name = "---", Chemical_formula = "---"
});
cbMediumHead.Properties.DataSource = lstReactive;
cbMediumHead.Properties.ValueMember = "Idreactive";
cbMediumHead.Properties.DisplayMember = "Reactive_name";
cbModifHead.Properties.DataSource = lstReactive;
cbModifHead.Properties.ValueMember = "Idreactive";
cbModifHead.Properties.DisplayMember = "Reactive_name";
#endregion
#region inicializar datos según el filtro seleccionado
// Estandares de calibración.
if (group_solution.Type_solution == 1)
{
// --- recuperar cajas de textos no editables
cbTypePattern.EditValue = group_solution.Type_pattern;
cbMrcOrPatternHeader.EditValue = group_solution.Idmr_detail;
cbMediumHead.EditValue = group_solution.Idreactive_medium;
cbModifHead.EditValue = group_solution.Idreactive_modif;
// --- elemento, mr pattern, medio y modif
//TODO
//lstTemplate = modSolution.GetMethodsByMrcPattern(group_solution);
gcMethods.DataSource = lstTemplate;
}
// Soluciones intermedias 1 y 2 y estandares de verificación.
//else if (group_solution.Type_solution == 2
// || group_solution.Type_solution == 3)
//{
// // recuperar cajas de textos no editables
// cbTypePattern.EditValue = group_solution.Type_pattern;
// cbMrcOrPatternHeader.EditValue = group_solution.Idmr_detail;
// // elemento, mr pattern, sol intermedia (1 ó 2 implicito)
// // getLstMethods(group_solution, type_solution_intermedia)
// lstTemplate = modSolution.GetMethodsBySolInterm(group_solution, );
// gcMethods.DataSource = lstTemplate;
//}
#endregion
}
private void ucCalibStd1_onNewCalib(CGroup_solution e)
{
// --- mensaje que se agregó una nueva calibración
FormMessage fmMessage = new FormMessage();
fmMessage.Message = "Se agregó la calibración " + e.Cod_solution;
if (fmMessage.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
// --- inicializar el arbol
InitTree();
// --- seleccionar el nuevo nodo agregado
FindAndFocusNode(e);
}
}
private void ucSolInterm1_onSignSolInterm(CGroup_solution e)
{
// inicializar el arbol
InitTree();
// seleccionar el nuevo nodo agregado
FindAndFocusNode(e);
}
void GetDetailGroup(CGroup_solution group_solution)
{
// --- recuperar datos
// calibraciones: recuperar datos de calibraciones
// soluciones intermedias: recuperar el grupo o raiz de soluciones
// estandar de verificacion: recuperar el grupo o raiz de soluciones
// --- recuperar titulo
if (group_solution != null)
{
group_solution.Idtemplate_method = template_method_aa.Idtemplate_method;
// --- recuperar filtros bloqueados
gpTitle.Enabled = false;
gpTitle.Text = "";
TypeSolution = Convert.ToInt32(group_solution.Type_solution);
tabMain.Visible = true;
if (group_solution.Cod_solution == null)
gpTitle.Text = "";
else
gpTitle.Text = group_solution.Cod_solution;
gpTitle.Enabled = false;
cbElement.EditValue = Convert.ToInt16(group_solution.Idelement);
// --- mostrar tabuladores principales
ShowStatusControls(group_solution);
// --- recuperar calibraciones
if (group_solution.Type_solution == 1)
Recuperate_calib(group_solution);
// --- recuperar soluciones intermedias
else if (group_solution.Type_solution == 2 || group_solution.Type_solution == 3 || group_solution.Type_solution == 4)
Recuperate_SolInterm(group_solution);
}
}
