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"; }
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); }