protected override void Recuperar_Registro()
{
try
{
// --- recuperate head
if (IDTemplate_Method > 0)
{
// --- recuperate head
CTemplate_methodFactory faTemplate_Method = new CTemplate_methodFactory();
CTemplate_method oTemplate_Method = faTemplate_Method.GetByPrimaryKey(new CTemplate_methodKeys(IDTemplate_Method));
gluCod_method.EditValue = oTemplate_Method.Cod_template_method;
Num_version = Convert.ToInt16(oTemplate_Method.Num_version);
tbTitle.Text = oTemplate_Method.Title;
laTitulo.Text = string.Format("Metodo ({0}-{1})", oTemplate_Method.Num_version, oTemplate_Method.Useredit);
cbDigestion.EditValue = oTemplate_Method.Cod_digestion_method;
tbCost_Method.Value = Convert.ToDecimal(oTemplate_Method.Cost_method);
tbAbreviation.Text = oTemplate_Method.Abbreviation;
ckRecognized.Checked = Convert.ToBoolean(oTemplate_Method.Recognized);
cbTypeSample.EditValue = oTemplate_Method.Cod_type_sample;
cbElement.EditValue = Convert.ToInt16(oTemplate_Method.Idelement);
cbTypeAnalysis.EditValue = null;
cbTypeAnalysis.EditValue = oTemplate_Method.Type_analisys; //recupera el tipo de analisis
cbRepetition.EditValue = oTemplate_Method.Cod_repetition;
}
}
catch (Exception ex)
{
ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message);
}
}
Comun.MethodSaveProperty GetResultTestHeader()
{
// --- registro anterior
if (IDTemplate_Method <= 0)
{
return(Comun.MethodSaveProperty.NewMethod);
}
else
{
CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory();
CTemplate_method oTemplate_method = new CTemplate_method();
oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(IDTemplate_Method));
CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa();
CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory();
oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(IDTemplate_Method));
// --- change inside head, require new method
if (oTemplate_method.Idelement != Convert.ToInt16(cbElement.EditValue))
{
return(Comun.MethodSaveProperty.InspectionNewMethod);
}
if (oTemplate_method.Cod_type_sample != cbTypeSample.EditValue.ToString())
{
return(Comun.MethodSaveProperty.InspectionNewMethod);
}
if (oTemplate_method.Type_analisys != Convert.ToChar(cbTypeAnalysis.EditValue))
{
return(Comun.MethodSaveProperty.InspectionNewMethod);
}
if (oTemplate_method.Cod_template_method != gluCod_method.Text)
{
return(Comun.MethodSaveProperty.InspectionNewMethod);
}
//if (oTemplate_method.Abbreviation != tbAbreviation.Text)
// return Comun.MethodSaveProperty.InspectionNewMethod;
//if (oTemplate_method.Title != tbTitle.Text)
// return Comun.MethodSaveProperty.InspectionNewMethod;
//if (oTemplate_method.Recognized != ckRecognized.Checked)
// return Comun.MethodSaveProperty.InspectionNewMethod;
if (oTemplate_method.Cod_digestion_method != cbDigestion.EditValue.ToString())
{
return(Comun.MethodSaveProperty.InspectionNewMethod);
}
//if (Convert.ToDecimal(oTemplate_method.Cost_method) != tbCost_Method.Value)
// return Comun.MethodSaveProperty.InspectionNewMethod;
if (Convert.ToInt16(oTemplate_method.Cod_repetition) != Convert.ToInt16(cbRepetition.EditValue))
{
return(Comun.MethodSaveProperty.InspectionNewMethod);
}
return(Comun.MethodSaveProperty.Nothing);
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CTemplate_method</returns>
internal List <CTemplate_method> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CTemplate_method> list = new List <CTemplate_method>();
while (dataReader.Read())
{
CTemplate_method businessObject = new CTemplate_method();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
void FilterByCodMethod()
{
CTemplate_methodFactory faTemplate_Method = new CTemplate_methodFactory();
IDTemplate_Method = Convert.ToInt32(gluCod_method.EditValue);
CTemplate_method oTemplate_Method = faTemplate_Method.GetByPrimaryKey(new CTemplate_methodKeys(IDTemplate_Method));
if (oTemplate_Method != null)
{
cbElement.EditValue = Convert.ToInt16(oTemplate_Method.Idelement);
cbTypeSample.EditValue = oTemplate_Method.Cod_type_sample;
cbTypeAnalysis.EditValue = oTemplate_Method.Type_analisys;
}
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CTemplate_method business object</returns>
public CTemplate_method SelectByPrimaryKey(CTemplate_methodKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_template_method_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_idtemplate_method", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idtemplate_method));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CTemplate_method businessObject = new CTemplate_method();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CTemplate_method::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
Comun.MethodSaveProperty GetResultTestHeader()
{
// --- registro anterior
if (IDTemplate_Method <= 0)
{
return Comun.MethodSaveProperty.NewMethod;
}
else
{
CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory();
CTemplate_method oTemplate_method = new CTemplate_method();
oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(IDTemplate_Method));
CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aa();
CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory();
oTemplate_method_aa = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(IDTemplate_Method));
// --- change inside head, require new method
if (oTemplate_method.Idelement != Convert.ToInt16(cbElement.EditValue))
return Comun.MethodSaveProperty.InspectionNewMethod;
if (oTemplate_method.Cod_type_sample != cbTypeSample.EditValue.ToString())
return Comun.MethodSaveProperty.InspectionNewMethod;
if (oTemplate_method.Type_analisys != Convert.ToChar(cbTypeAnalysis.EditValue))
return Comun.MethodSaveProperty.InspectionNewMethod;
if (oTemplate_method.Cod_template_method != gluCod_method.Text)
return Comun.MethodSaveProperty.InspectionNewMethod;
//if (oTemplate_method.Abbreviation != tbAbreviation.Text)
// return Comun.MethodSaveProperty.InspectionNewMethod;
//if (oTemplate_method.Title != tbTitle.Text)
// return Comun.MethodSaveProperty.InspectionNewMethod;
//if (oTemplate_method.Recognized != ckRecognized.Checked)
// return Comun.MethodSaveProperty.InspectionNewMethod;
if (oTemplate_method.Cod_digestion_method != cbDigestion.EditValue.ToString())
return Comun.MethodSaveProperty.InspectionNewMethod;
//if (Convert.ToDecimal(oTemplate_method.Cost_method) != tbCost_Method.Value)
// return Comun.MethodSaveProperty.InspectionNewMethod;
if (Convert.ToInt16(oTemplate_method.Cod_repetition) != Convert.ToInt16(cbRepetition.EditValue))
return Comun.MethodSaveProperty.InspectionNewMethod;
return Comun.MethodSaveProperty.Nothing;
}
}
private void gluCod_method_ProcessNewValue(object sender, DevExpress.XtraEditors.Controls.ProcessNewValueEventArgs e)
{
try
{
DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit Edit;
Edit = ((DevExpress.XtraEditors.GridLookUpEdit)sender).Properties;
if (e.DisplayValue == null || Edit.NullText.Equals(e.DisplayValue) || string.Empty.Equals(e.DisplayValue))
{
return;
}
List <CTemplate_method> lstCtm = (List <CTemplate_method>)gluCod_method.Properties.DataSource;
// --- allways keeping one record how new value
if (lstCtm.Exists(c => c.Idtemplate_method == 0))
{
CTemplate_method oTemplate_method = lstCtm.Single(c => c.Idtemplate_method == 0);
oTemplate_method.Cod_template_method = e.DisplayValue.ToString();
gluCod_method.Properties.DataSource = lstCtm;
}
else
{
List <CTemplate_method> lstTemplateMethod = new Methods().GetAllLastVersionMethods();
if (!lstTemplateMethod.Exists(c => c.Cod_template_method == gluCod_method.Text.Trim()))
{
lstCtm.Add(new CTemplate_method()
{
Cod_template_method = e.DisplayValue.ToString(),
Idtemplate_method = 0
});
gluCod_method.Properties.DataSource = lstCtm;
}
}
e.Handled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void tbCod_method_InvalidValue(object sender, DevExpress.XtraEditors.Controls.InvalidValueExceptionEventArgs e)
{
try
{
List <CTemplate_method> lstTemplateMethod = new Methods().GetAllLastVersionMethods();
CTemplate_method oTemplate_method = lstTemplateMethod.Single(c => c.Cod_template_method == tbCod_method.Text);
if (oTemplate_method == null)
{
e.ErrorText = "el código de método ya se encuentra asignado";
}
else
{
e.ErrorText = "el código de método ya se encuentra asignado al método " + oTemplate_method.Abbreviation;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void Show_batch()
{
// --- show trace groups
gbApprove.Visible = false;
gbReview.Visible = false;
gv2col_Qaqc_approve.ImageIndex = 0;
gv2col_Qaqc_review.ImageIndex = 0;
// --- show template method
ShowDilution();
// --- show description method
CBatchFactory faBatch = new CBatchFactory();
CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch));
laTitleModule.Text = String.Format("Bandeja {0} en Espera", Comun.FormatCorrelativeCode("B-", Convert.ToInt64(oBatch.Num_tray), 5));
if (oBatch.Status_process == 'W')
{
ucSignCloseTray.Title = "Cerrar bandeja";
ucSignCloseTray.Enabled = true;
bgvBatchCalc2.OptionsBehavior.Editable = false;
}
if (oBatch.Status_process == 'P')
{
ucSignCloseTray.Title = "Cerrado("+oBatch.User_close_tray+")";
ucSignCloseTray.Enabled = false;
bgvBatchCalc2.OptionsBehavior.Editable = true;
}
CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory();
oTemplate_method_current = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method));
tbCodMethod.Text = oTemplate_method_current.Cod_template_method;
tbTitle.Text = oTemplate_method_current.Title;
tbAbbreviation.Text = oTemplate_method_current.Abbreviation;
#region <optimizar>
CTemplate_method_aaFactory faTemplate_method_aa = new CTemplate_method_aaFactory();
oTemplate_method_aa_current = faTemplate_method_aa.GetByPrimaryKey(new CTemplate_method_aaKeys(Idtemplate_method));
deDate_allowed_error.DateTime = Convert.ToDateTime(oTemplate_method_aa_current.Date_allowed_error);
CMr_detailFactory faMr_detail = new CMr_detailFactory();
CMr_detail oMr_detail = faMr_detail.GetByPrimaryKey(new CMr_detailKeys(Convert.ToInt16(oTemplate_method_aa_current.Idmr_detail)));
tbLawMri.Text = oMr_detail.Nominal_value.ToString();
CMrFactory faMr = new CMrFactory();
CMr oMr = faMr.GetByPrimaryKey(new CMrKeys(
Convert.ToInt16(oMr_detail.Idmr)
));
tbMri.Text = oMr.Cod_mr;
CMeasurement_unitFactory faMeasure = new CMeasurement_unitFactory();
CMeasurement_unit oMeasurement_unit = faMeasure.GetByPrimaryKey(new CMeasurement_unitKeys(Convert.ToInt16(oMr_detail.Idunit1)));
tbUnitMeasure.Text = oMeasurement_unit.Name_unit;
#endregion
// --- clear columns
gcBachCalc.DataSource = null;
// --- format the datatable with the number of repetitions
oDataBatch = new CDataBatch(Idbatch, Idtemplate_method, Comun.StatusWork.Waiting, Comun.CriteriaSort.BySample);
gcBachCalc.DataSource = oDataBatch.ListSamples;
// --- show sd
tbAbs.Value = oDataBatch.Absorbance;
tbStd.Value = oDataBatch.StdVerification;
tbAbs.BackColor = oDataBatch.ColorAbsorbance;
tbStd.BackColor = oDataBatch.ColorStd;
tbSdBlk.Text = oDataBatch.LrbMeasured.ToString();
tbSdBlk.BackColor = oDataBatch.ColorLrbMeasured;
tbSdMr.Text = oDataBatch.MriMeasured.ToString();
tbSdMr.BackColor = oDataBatch.ColorMriMeasured;
// --- show empty sample
ShowParityEmptySample(false);
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CTemplate_method businessObject, IDataReader dataReader)
{
businessObject.Idtemplate_method = dataReader.GetInt32(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Idtemplate_method.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Num_version.ToString())))
{
businessObject.Num_version = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Num_version.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_template_method.ToString())))
{
businessObject.Cod_template_method = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_template_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_repetition.ToString())))
{
businessObject.Cod_repetition = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_repetition.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Title.ToString())))
{
businessObject.Title = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Title.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Abbreviation.ToString())))
{
businessObject.Abbreviation = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Abbreviation.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Name_method.ToString())))
{
businessObject.Name_method = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Name_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Type_analisys.ToString())))
{
businessObject.Type_analisys = dataReader.GetChar(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Type_analisys.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Recognized.ToString())))
{
businessObject.Recognized = dataReader.GetBoolean(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Recognized.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Idelement.ToString())))
{
businessObject.Idelement = dataReader.GetInt32(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Idelement.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_type_sample.ToString())))
{
businessObject.Cod_type_sample = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_type_sample.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_digestion_method.ToString())))
{
businessObject.Cod_digestion_method = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cod_digestion_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cost_method.ToString())))
{
businessObject.Cost_method = dataReader.GetDecimal(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Cost_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Usernew.ToString())))
{
businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Usernew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Datenew.ToString())))
{
businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Datenew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Useredit.ToString())))
{
businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Useredit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Dateedit.ToString())))
{
businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Dateedit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Status.ToString())))
{
businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CTemplate_method.CTemplate_methodFields.Status.ToString()));
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CTemplate_method businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_template_method_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_idtemplate_method", businessObject.Idtemplate_method);
sqlCommand.Parameters["p_idtemplate_method"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters["p_idtemplate_method"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_num_version", businessObject.Num_version);
sqlCommand.Parameters["p_num_version"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_cod_template_method", businessObject.Cod_template_method);
sqlCommand.Parameters["p_cod_template_method"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_cod_repetition", businessObject.Cod_repetition);
sqlCommand.Parameters["p_cod_repetition"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_title", businessObject.Title);
sqlCommand.Parameters["p_title"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_abbreviation", businessObject.Abbreviation);
sqlCommand.Parameters["p_abbreviation"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_name_method", businessObject.Name_method);
sqlCommand.Parameters["p_name_method"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_type_analisys", businessObject.Type_analisys);
sqlCommand.Parameters["p_type_analisys"].NpgsqlDbType = NpgsqlDbType.Char;
sqlCommand.Parameters.AddWithValue("p_recognized", businessObject.Recognized);
sqlCommand.Parameters["p_recognized"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_idelement", businessObject.Idelement);
sqlCommand.Parameters["p_idelement"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_cod_type_sample", businessObject.Cod_type_sample);
sqlCommand.Parameters["p_cod_type_sample"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_cod_digestion_method", businessObject.Cod_digestion_method);
sqlCommand.Parameters["p_cod_digestion_method"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_cost_method", businessObject.Cost_method);
sqlCommand.Parameters["p_cost_method"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_usernew", businessObject.Usernew);
sqlCommand.Parameters["p_usernew"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_datenew", businessObject.Datenew);
sqlCommand.Parameters["p_datenew"].NpgsqlDbType = NpgsqlDbType.Date;
sqlCommand.Parameters.AddWithValue("p_useredit", businessObject.Useredit);
sqlCommand.Parameters["p_useredit"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_dateedit", businessObject.Dateedit);
sqlCommand.Parameters["p_dateedit"].NpgsqlDbType = NpgsqlDbType.Date;
sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status);
sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.Idtemplate_method = Convert.ToInt32(sqlCommand.Parameters["p_idtemplate_method"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CTemplate_method::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
void LoadQaqcStatus()
{
if (TypeSample == Comun.TypeSample.Sample)
{
// --- get repetitions
repRepetition.DataSource = Comun.ListTypeRepetition;
repRepetition.DisplayMember = "Name_repetition";
repRepetition.ValueMember = "Cod_repetition";
// --- get methods
CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory();
CTemplate_method oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method));
Methods oMethods = new Methods();
gcMethods.DataSource = oMethods.GetAllLastVersionMethods(Convert.ToInt32(oTemplate_method.Idelement), oTemplate_method.Cod_type_sample);
// --- assign to popup controls
// observation
Idtemplate_method = Convert.ToInt32(gvMethods.GetFocusedRowCellValue(gcMet_Idtemplate_method));
tbObservation.Text = Text_obs;
// method
if (Idretest > 0)
{
faTemplate_method = new CTemplate_methodFactory();
oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idretest));
tbCod_method.Text = oTemplate_method.Cod_template_method;
tbAbbrevMethod.Text = oTemplate_method.Abbreviation;
ckEnableRetest.Checked = true;
}
else
{
faTemplate_method = new CTemplate_methodFactory();
oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method));
tbCod_method.Text = oTemplate_method.Cod_template_method;
tbAbbrevMethod.Text = oTemplate_method.Abbreviation;
ckEnableRetest.Checked = false;
ckChangeMethod.Checked = false;
}
// --- get retest
#region codigo anterior
/*
CREATE OR REPLACE FUNCTION public.sp_retest_getBySample(p_idrecep_sample_detail_elem bigint, p_idbatch bigint)
returns TABLE ("Idbatch" BIGINT, "Num_tray" VARCHAR, "Idrecep_sample_detail_elem" BIGINT, "Idrecep_sample_detail" BIGINT
,"Cod_module" VARCHAR, "Cod_process" VARCHAR, "Status_process" CHAR, "Result_analysis" DECIMAL
, "Str_result_analysis" VARCHAR, "Status_result" int, "Cod_sample" VARCHAR
, "Flag_current_batch" boolean
)AS $$
BEGIN
--
CREATE TEMP TABLE tmp_batch ON COMMIT DROP AS
SELECT origin_batch as idbatch, idrecep_sample_detail_elem, idrecep_sample_detail
FROM retest
WHERE (origin_batch = p_idbatch OR destiny_batch = p_idbatch)
UNION ALL
SELECT destiny_batch as idbatch, idrecep_sample_detail_elem, idrecep_sample_detail
FROM retest
WHERE (destiny_batch = p_idbatch OR origin_batch = p_idbatch);
RETURN QUERY
SELECT DISTINCT t1.idbatch, CAST(LPAD(CAST(t2.num_tray AS VARCHAR), 5, '0') AS VARCHAR), t1.idrecep_sample_detail_elem, t4.idrecep_sample_detail
, t2.cod_module, t2.cod_process, t2.status_process, t3.result_analysis
, t3.str_result_analysis, COALESCE(CAST(t3.Qaqc_status_result AS INT), 0) as ER, t3.cod_sample
, CAST(CASE
WHEN t1.idbatch = p_idbatch THEN 1
ELSE 0
END AS BOOLEAN) AS flag_current_batch
FROM tmp_batch t1
INNER JOIN batch t2
ON t1.idbatch = t2.idbatch
LEFT OUTER JOIN batch_detail_aa_twofold t3
ON t2.idbatch = t3.idbatch
AND t1.idrecep_sample_detail_elem = t3.idrecep_sample_detail_elem
LEFT OUTER JOIN recep_sample_detail t4
ON t1.idrecep_sample_detail = t4.idrecep_sample_detail
WHERE t1.idrecep_sample_detail_elem = p_idrecep_sample_detail_elem;
END;
$$ LANGUAGE plpgsql;
*/
#endregion
var tmp_batch =
(from m in new CRetestFactory().GetAll().Where(x => x.Origin_batch == Idbatch || x.Destiny_batch == Idbatch)
select new { idbatch = m.Origin_batch, m.Idrecep_sample_detail_elem, m.Idrecep_sample_detail })
.Union(from m in new CRetestFactory().GetAll().Where(x => x.Destiny_batch == Idbatch || x.Origin_batch == Idbatch)
select new { idbatch = m.Destiny_batch, m.Idrecep_sample_detail_elem, m.Idrecep_sample_detail });
var query2 =
(from m in tmp_batch.Where(x => x.Idrecep_sample_detail_elem == Idrecep_sample_detail_elem)
from n in new CBatchFactory().GetAll().Where(x => x.Idbatch == m.idbatch)
join p in new CBatch_detail_aa_twofoldFactory().GetAll()
on new { field1 = m.idbatch, field2 = m.Idrecep_sample_detail_elem }
equals new { field1 = p.Idbatch, field2 = p.Idrecep_sample_detail_elem } into np
from q in np.DefaultIfEmpty()
join r in new CRecep_sample_detailFactory().GetAll()
on q.Idrecep_sample_detail equals r.Idrecep_sample_detail into qr
from s in qr
select new
{
m.idbatch,
Num_tray = n.Num_tray.ToString().PadLeft(5, '0'),
m.Idrecep_sample_detail_elem,
m.Idrecep_sample_detail,
n.Cod_module,
n.Cod_process,
n.Status_process,
q.Result_analysis,
q.Str_result_analysis,
Status_result = q == null ? 0 : q.Qaqc_status_result,
q.Cod_sample,
Flag_current_batch = m.idbatch == Idbatch ? true : false
}).Distinct();
gcListRetest.DataSource = query2;
Show_controls(Windows_current);
}
else
{
// --- reensayo de muestras de control de encontrar algún error
gcObservation.Visible = false;
ckEnableRetest.Visible = false;
xtraTabControl1.TabPages[0].Text = "Reensayo de Bandeja";
xtraTabControl1.TabPages[1].PageVisible = false;
// --- get repetitions
repRepetition.DataSource = Comun.ListTypeRepetition;
repRepetition.DisplayMember = "Name_repetition";
repRepetition.ValueMember = "Cod_repetition";
// --- get methods
CTemplate_methodFactory faTemplate_method = new CTemplate_methodFactory();
CTemplate_method oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method));
Methods oMethods = new Methods();
gcMethods.DataSource = oMethods.GetAllLastVersionMethods(Convert.ToInt32(oTemplate_method.Idelement), oTemplate_method.Cod_type_sample);
// --- assign to popup controls
// observation
Idtemplate_method = Convert.ToInt32(gvMethods.GetFocusedRowCellValue(gcMet_Idtemplate_method));
tbObservation.Text = Text_obs;
// method
faTemplate_method = new CTemplate_methodFactory();
oTemplate_method = faTemplate_method.GetByPrimaryKey(new CTemplate_methodKeys(Idtemplate_method));
tbCod_method.Text = oTemplate_method.Cod_template_method;
tbAbbrevMethod.Text = oTemplate_method.Abbreviation;
ckEnableRetest.Checked = true;
ckChangeMethod.Checked = false;
ckEnableRetest.Visible = false;
}
}
bool SaveAA()
{
try
{
string Cod_method = gluCod_method.Text;
string Title = tbTitle.Text;
string messageOk = "";
Methods oMethods = new Methods();
Comun.MethodSaveProperty InspectionChanges = RequireNewVersionOrMethod(Comun.GetTypeAnalysis(Convert.ToChar(cbTypeAnalysis.EditValue)));
if (InspectionChanges == Comun.MethodSaveProperty.NewMethod)
{
Num_version = 1;
messageOk = "Se guardó un nuevo método con código " + Cod_method +
"\ncon título " + Title;
}
if (InspectionChanges == Comun.MethodSaveProperty.InspectionNewVersion)
{
// --- save as new version or overwrite
FormConfirmSaveMethod fmConfirmSaveMethod = new FormConfirmSaveMethod(true);
if (fmConfirmSaveMethod.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (fmConfirmSaveMethod.SaveType == Comun.Save_type.SaveAs)
{
FormMethodSaveAs fmMethodSaveAs = new FormMethodSaveAs();
fmMethodSaveAs.ListTemplate =
oMethods.GetAllLastVersionMethods(
Convert.ToInt32(cbElement.EditValue),
cbTypeSample.EditValue.ToString(),
Convert.ToChar(cbTypeAnalysis.EditValue));
if (fmMethodSaveAs.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Num_version = 1;
IDTemplate_Method = 0;
Cod_method = fmMethodSaveAs.Cod_method;
Title = fmMethodSaveAs.Title;
messageOk = "Se guardó un nuevo método con código " + fmMethodSaveAs.Cod_method +
"\n con título '" + fmMethodSaveAs.Title + "'";
}
else
{
return(false);
}
}
if (fmConfirmSaveMethod.SaveType == Comun.Save_type.Save)
{
Num_version = oMethods.GetNumNewVersion(IDTemplate_Method);
IDTemplate_Method = 0;
messageOk = "Se guardó una nueva versión [" + Num_version.ToString() + "] del método " + Cod_method;
}
}
else
{
return(false);
}
}
if (InspectionChanges == Comun.MethodSaveProperty.InspectionNewMethod)
{
FormMethodSaveAs fmMethodSaveAs = new FormMethodSaveAs();
fmMethodSaveAs.ListTemplate =
oMethods.GetAllLastVersionMethods(
Convert.ToInt32(cbElement.EditValue),
cbTypeSample.EditValue.ToString(),
Convert.ToChar(cbTypeAnalysis.EditValue));
if (fmMethodSaveAs.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Num_version = 1;
IDTemplate_Method = 0;
Cod_method = fmMethodSaveAs.Cod_method;
Title = fmMethodSaveAs.Title;
messageOk = "Se guardó un nuevo método con código " + fmMethodSaveAs.Cod_method +
"\n con título " + fmMethodSaveAs.Title;
}
else
{
return(false);
}
}
if (InspectionChanges == Comun.MethodSaveProperty.Nothing)
{
messageOk = "Se guardó correctamente";
}
// --- save head
CTemplate_methodFactory faTemplate_Method = new CTemplate_methodFactory();
CTemplate_method oTemplate_Method = new CTemplate_method();
oTemplate_Method.Idtemplate_method = IDTemplate_Method;
oTemplate_Method.Num_version = Num_version;
oTemplate_Method.Idelement = Convert.ToInt32(cbElement.EditValue);
oTemplate_Method.Cod_template_method = Cod_method;
oTemplate_Method.Title = Title;
oTemplate_Method.Cod_digestion_method = cbDigestion.EditValue.ToString();
oTemplate_Method.Cod_repetition = Convert.ToInt16(cbRepetition.EditValue);
oTemplate_Method.Abbreviation = tbAbreviation.Text;
oTemplate_Method.Recognized = ckRecognized.Checked;
oTemplate_Method.Cod_type_sample = cbTypeSample.EditValue.ToString();
oTemplate_Method.Cost_method = tbCost_Method.Value;
oTemplate_Method.Type_analisys = Convert.ToChar(cbTypeAnalysis.EditValue);
oTemplate_Method.Status = true;
if (IDTemplate_Method == 0)
{
oTemplate_Method.Usernew = Comun.GetUser();
oTemplate_Method.Datenew = Comun.GetDate();
oTemplate_Method.Useredit = Comun.GetUser();
oTemplate_Method.Dateedit = Comun.GetDate();
}
else
{
oTemplate_Method.Useredit = Comun.GetUser();
oTemplate_Method.Dateedit = Comun.GetDate();
}
bool result_template_method = false;
if (!(result_template_method = faTemplate_Method.Update(oTemplate_Method)))
{
result_template_method = faTemplate_Method.Insert(oTemplate_Method);
}
if (result_template_method)
{
IDTemplate_Method = oTemplate_Method.Idtemplate_method;
SaveTypeAnalysis();
}
FormResult fmResult = new FormResult();
fmResult.Message = messageOk;
fmResult.ShowDialog();
gluCod_method.Text = Cod_method;
return(true);
}
catch (Exception ex)
{
ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message);
return(false);
}
}
public void CallSaveSampleBatchWithRetest(int idtemplate_method, long idrecep_sample, long idrecep_sample_detail, long idrecep_sample_detail_elem, long cod_interno, string str_cod_interno, string user, CCorrelative correlative, int Qaqc_par_prev_batch, long origin_batch)
{
Correlative = correlative;
CBatch_detail_aa_twofold oBatch_detail_aa_twofold = new CBatch_detail_aa_twofold();
oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method));
CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method));
CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detailFactory().GetByPrimaryKey(new CRecep_sample_detailKeys(idrecep_sample_detail));
CDescription_sample oDescription_sample = new CDescription_sampleFactory().GetByPrimaryKey(new CDescription_sampleKeys(oRecep_sample_detail.Cod_des_sample));
if (oTemplate_method_aa != null)
{
oBatch_detail_aa_twofold.Idtemplate_method = idtemplate_method;
oBatch_detail_aa_twofold.Idrecep_sample = idrecep_sample;
oBatch_detail_aa_twofold.Idrecep_sample_detail = idrecep_sample_detail;
oBatch_detail_aa_twofold.Idrecep_sample_detail_elem = idrecep_sample_detail_elem;
oBatch_detail_aa_twofold.Idunit_result = oTemplate_method_aa.Idunit_result;
oBatch_detail_aa_twofold.Weight1 = oTemplate_method_aa.Weight;
oBatch_detail_aa_twofold.Weight2 = oTemplate_method_aa.Weight;
oBatch_detail_aa_twofold.Volumen1 = oTemplate_method_aa.Volumen;
oBatch_detail_aa_twofold.Volumen2 = oTemplate_method_aa.Volumen;
oBatch_detail_aa_twofold.Dilu2 = oTemplate_method_aa.Dilution2;
oBatch_detail_aa_twofold.Dilu3 = oTemplate_method_aa.Dilution3;
oBatch_detail_aa_twofold.Flag_dilu2 = false;
oBatch_detail_aa_twofold.Flag_dilu3 = false;
oBatch_detail_aa_twofold.Cod_des_sample = oRecep_sample_detail.Cod_des_sample;
oBatch_detail_aa_twofold.Order_des_sample = oDescription_sample.Priority_order;
oBatch_detail_aa_twofold.Flag_mri = 0;
oBatch_detail_aa_twofold.Fum = methods.GetFactorConvertionUM(idtemplate_method);
oBatch_detail_aa_twofold.Qaqc_blk = 3;
oBatch_detail_aa_twofold.Qaqc_par = 3;
oBatch_detail_aa_twofold.Qaqc_mr = 3;
oBatch_detail_aa_twofold.Qaqc_error = 0;
oBatch_detail_aa_twofold.Qaqc_approve = false;
oBatch_detail_aa_twofold.Qaqc_review = false;
oBatch_detail_aa_twofold.Qaqc_has_retest = 0;
oBatch_detail_aa_twofold.Qaqc_tmp_retest = 0;
oBatch_detail_aa_twofold.Qaqc_tmp_retest_idmethod = 0;
oBatch_detail_aa_twofold.Qaqc_approve_text = "";
oBatch_detail_aa_twofold.Qaqc_review_text = "";
oBatch_detail_aa_twofold.Qaqc_par_prev_batch = Qaqc_par_prev_batch;
oBatch_detail_aa_twofold.Cod_interno = cod_interno;
oBatch_detail_aa_twofold.Cod_sample = str_cod_interno;
control_sample.Idtemplate_method = idtemplate_method;
//control_sample.Idrecep_sample = idrecep_sample;
//control_sample.Idrecep_sample_detail = idrecep_sample_detail;
//control_sample.Idrecep_sample_detail_elem = idrecep_sample_detail_elem;
control_sample.Weight1 = oTemplate_method_aa.Weight;
control_sample.Weight2 = oTemplate_method_aa.Weight;
control_sample.Volumen1 = oTemplate_method_aa.Volumen;
control_sample.Volumen2 = oTemplate_method_aa.Volumen;
control_sample.Dilu2 = oTemplate_method_aa.Dilution2;
control_sample.Dilu3 = oTemplate_method_aa.Dilution3;
control_sample.Flag_dilu2 = false;
control_sample.Flag_dilu3 = false;
control_sample.Flag_mri = 1;
control_sample.Fum = methods.GetFactorConvertionUM(idtemplate_method);
control_sample.Qaqc_blk = 3;
control_sample.Qaqc_par = 3;
control_sample.Qaqc_mr = 3;
control_sample.Qaqc_error = 0;
control_sample.Qaqc_approve = false;
control_sample.Qaqc_review = false;
control_sample.Qaqc_tmp_retest_idmethod = 0;
control_sample.Qaqc_approve_text = "";
control_sample.Qaqc_review_text = "";
Enabled_retest = true;
oRetest.Idrecep_sample_detail = idrecep_sample_detail;
oRetest.Idrecep_sample_detail_elem = idrecep_sample_detail_elem;
oRetest.Origin_batch = origin_batch;
oRetest.Useredit1 = user;
oRetest.Usernew = user;
oRetest.Type_retest = 'R';
oRetest.Status = true;
// --- save in batch
SaveInBatch(oBatch_detail_aa_twofold, user);
}
}
