public DataTable GetReceptionDetail(long?idrecep_sample)
{
List <CRecep_sample_detail> lstRecep_sample_detail = new CRecep_sample_detailFactory()
.GetAll()
.Where(c => c.Idrecep_sample == idrecep_sample && c.Flag_control_sample == false).ToList();
List <CType_sample> lstType_sample = new CType_sampleFactory().GetAll();
List <CDescription_sample> lstDescription_sample = new CDescription_sampleFactory().GetAll();
List <CReception_detail_description> lst =
(from t1 in lstRecep_sample_detail
join t2 in lstType_sample on t1.Cod_type_sample equals t2.Cod_type_sample
join t3 in lstDescription_sample on t1.Cod_des_sample equals t3.Cod_des_sample
select new CReception_detail_description
{
Amount_weight = Convert.ToDecimal(t1.Amount_weight),
Analisys_time = Convert.ToDecimal(t1.Analisys_time),
Cod_des_sample = t1.Cod_des_sample,
Cod_sample = t1.Cod_sample,
Cod_type_sample = t1.Cod_type_sample,
Cost_sample = Convert.ToDecimal(t1.Cost_sample),
Description = t3.Description,
Flag_envelope_sealed = Convert.ToBoolean(t1.Flag_envelope_sealed),
Flag_counter_sample = Convert.ToInt16(t1.Flag_counter_sample),
Flag_reject = Convert.ToBoolean(t1.Flag_reject),
Idrecep_sample = Convert.ToInt64(t1.Idrecep_sample),
Idrecep_sample_detail = t1.Idrecep_sample_detail,
Name_sample = t1.Name_sample,
Name_type_sample = t2.Name_type_sample,
Order_sample = Convert.ToInt16(t1.Order_sample),
Procedence = t1.Procedence,
Cod_interno = Convert.ToInt64(t1.Cod_interno)
}).OrderBy(c => c.Order_sample).ToList <CReception_detail_description>();
return(ToDataTable <CReception_detail_description>(lst));
}
public int GetNextCorrelative()
{
List<CDescription_sample> lst = new CDescription_sampleFactory().GetAll();
int max = new CDescription_sampleFactory().GetAll().Max(c => Convert.ToInt32(c.Cod_des_sample));
if (lst.Count == 0)
max = 1;
else
max++;
return max;
}
protected override void Recuperar_Registro()
{
CDescription_sampleFactory faDescrption_Sample = new CDescription_sampleFactory();
CDescription_sample oDescription_sample = faDescrption_Sample.GetByPrimaryKey(new CDescription_sampleKeys(tbCode.Text));
if (oDescription_sample != null)
{
tbCode.Text = oDescription_sample.Cod_des_sample;
tbDescription.Text = oDescription_sample.Description;
tbOrderPriority.Value = Convert.ToDecimal(oDescription_sample.Priority_order);
}
}
public int GetNextCorrelative()
{
List <CDescription_sample> lst = new CDescription_sampleFactory().GetAll();
int max = new CDescription_sampleFactory().GetAll().Max(c => Convert.ToInt32(c.Cod_des_sample));
if (lst.Count == 0)
{
max = 1;
}
else
{
max++;
}
return(max);
}
protected override bool Grabar_Registro()
{
CDescription_sampleFactory faDescrption_Sample = new CDescription_sampleFactory();
CDescription_sample oDescription_Sample = faDescrption_Sample.GetByPrimaryKey(new CDescription_sampleKeys(tbCode.Text));
if (oDescription_Sample == null)
tbCode.Text = GetNextCorrelative().ToString();
oDescription_Sample.Cod_des_sample = tbCode.Text;
oDescription_Sample.Description = tbDescription.Text;
oDescription_Sample.Priority_order = Convert.ToInt16(tbOrderPriority.Value);
bool result = false;
if (!(result = faDescrption_Sample.Update(oDescription_Sample)))
{
result = faDescrption_Sample.Insert(oDescription_Sample);
}
return result;
}
protected override bool Grabar_Registro()
{
CDescription_sampleFactory faDescrption_Sample = new CDescription_sampleFactory();
CDescription_sample oDescription_Sample = faDescrption_Sample.GetByPrimaryKey(new CDescription_sampleKeys(tbCode.Text));
if (oDescription_Sample == null)
{
tbCode.Text = GetNextCorrelative().ToString();
}
oDescription_Sample.Cod_des_sample = tbCode.Text;
oDescription_Sample.Description = tbDescription.Text;
oDescription_Sample.Priority_order = Convert.ToInt16(tbOrderPriority.Value);
bool result = false;
if (!(result = faDescrption_Sample.Update(oDescription_Sample)))
{
result = faDescrption_Sample.Insert(oDescription_Sample);
}
return(result);
}
void InitCombos()
{
repRepetition.DataSource = Comun.ListTypeRepetition;
repRepetition.ValueMember = "Cod_repetition";
repRepetition.DisplayMember = "Name_repetition";
List<CType_sample> lstType_sample = new CType_sampleFactory().GetAll();
cbTypeSample.Properties.DataSource = lstType_sample;
cbTypeSample.Properties.DisplayMember = "Cod_type_sample";
cbTypeSample.Properties.ValueMember = "Cod_type_sample";
cbTypeSample.EditValue = lstType_sample[0].Cod_type_sample;
InitComboFilterAthorization();
List<CCompany> lstCompany = new CCompanyFactory().GetAll();
cbCompany.Properties.DataSource = lstCompany;
cbCompany.Properties.DisplayMember = "Business_name";
cbCompany.Properties.ValueMember = "Idcompany";
cbCompany.EditValue = lstCompany[0].Cod_company;
List<CDescription_sample> lstDescription = new CDescription_sampleFactory().GetAll();
repDes_Sample.DataSource = lstDescription;
repDes_Sample.DisplayMember = "Description";
repDes_Sample.ValueMember = "Cod_des_sample";
}
protected override void Recuperar_Registro()
{
CDescription_sampleFactory faDescrption_Sample = new CDescription_sampleFactory();
CDescription_sample oDescription_sample = faDescrption_Sample.GetByPrimaryKey(new CDescription_sampleKeys(tbCode.Text));
if (oDescription_sample != null)
{
tbCode.Text = oDescription_sample.Cod_des_sample;
tbDescription.Text = oDescription_sample.Description;
tbOrderPriority.Value = Convert.ToDecimal(oDescription_sample.Priority_order);
}
}
void InitDataControls()
{
deReception.DateTime = DateTime.Now;
deHourReception.EditValue = DateTime.Now;
// --- init client combo
CCompanyFactory faCompany = new CCompanyFactory();
cbCompany.Properties.DataSource = faCompany.GetAll();
cbCompany.Properties.ValueMember = "Idcompany";
cbCompany.Properties.DisplayMember = "Business_name";
// --- init element combo
CElementFactory faElement = new CElementFactory();
lstElement = faElement.GetAll();
lstElement.Insert(0, new CElement { Idelement = -1, Cod_element = "Seleccionar" });
var elementQuery = from table in lstElement
select new CItemGenericCombo
{
codigo = table.Idelement.ToString(),
descripcion = table.Cod_element
};
// --- init type sample combo
CType_sampleFactory faType_Sample = new CType_sampleFactory();
cbTypeSample.Properties.DataSource = faType_Sample.GetAll();
cbTypeSample.Properties.ValueMember = "Cod_type_sample";
cbTypeSample.Properties.DisplayMember = "Name_type_sample";
// --- init description combo
CDescription_sampleFactory faDescrition_Sample = new CDescription_sampleFactory();
repDescription.DataSource = faDescrition_Sample.GetAll();
repDescription.ValueMember = "Cod_des_sample";
repDescription.DisplayMember = "Description";
// --- init anio
CSerieFactory faSerie = new CSerieFactory();
Reception oReception = new Reception();
// --- init status report
repStatusReport.DataSource = Comun.ListStatusReport;
repStatusReport.ValueMember = "IdStatus";
repStatusReport.DisplayMember = "Den_Status";
// --- init status attach
repAttach_status.DataSource = oReception.GetAttachStatus();
repAttach_status.DisplayMember = "Name_status";
repAttach_status.ValueMember = "Id";
repPerson_type.DataSource = oReception.GetLstPersonType();
repPerson_type.DisplayMember = "Name";
repPerson_type.ValueMember = "Id";
}
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);
}
}
// --- insert sample came from retest full batch
public void CallSaveFromRetestFullBatch(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?previus_parity)
{
Correlative = correlative;
CBatch_detail_aa_twofold oBatch_detail_aa_twofold = new CBatch_detail_aa_twofold();
CTemplate_method 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));
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.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 = previus_parity;
oBatch_detail_aa_twofold.Cod_interno = cod_interno;
oBatch_detail_aa_twofold.Cod_sample = str_cod_interno;
oBatch_detail_aa_twofold.Cod_des_sample = oRecep_sample_detail.Cod_des_sample;
oBatch_detail_aa_twofold.Order_des_sample = oDescription_sample.Priority_order;
// --- control sample
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 = "";
SaveInBatch(oBatch_detail_aa_twofold, user);
}
