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));
}
protected override void Recuperar_Registro()
{
CType_sampleFactory faType_sample = new CType_sampleFactory();
CType_sample oType_sample = faType_sample.GetByPrimaryKey(new CType_sampleKeys(Cod_Type_Sample));
if (oType_sample != null)
{
tbCode.Text = oType_sample.Cod_type_sample;
tbName.Text = oType_sample.Name_type_sample;
tbDescription.Text = oType_sample.Description;
tbPrefix.Text = oType_sample.Prefix;
}
}
protected override void Recuperar_Registro()
{
CType_sampleFactory faType_sample = new CType_sampleFactory();
CType_sample oType_sample = faType_sample.GetByPrimaryKey(new CType_sampleKeys(Cod_Type_Sample));
if (oType_sample != null)
{
tbCode.Text = oType_sample.Cod_type_sample;
tbName.Text = oType_sample.Name_type_sample;
tbDescription.Text = oType_sample.Description;
tbPrefix.Text = oType_sample.Prefix;
}
}
protected override bool Grabar_Registro()
{
CType_sampleFactory faType_sample = new CType_sampleFactory();
CType_sample oType_sample = new CType_sample();
oType_sample.Cod_type_sample = tbCode.Text;
oType_sample.Name_type_sample = tbName.Text;
oType_sample.Description = tbDescription.Text;
oType_sample.Prefix = tbPrefix.Text;
bool result = false;
if (!(result = faType_sample.Update(oType_sample)))
{
result = faType_sample.Insert(oType_sample);
}
return result;
}
protected override bool Grabar_Registro()
{
CType_sampleFactory faType_sample = new CType_sampleFactory();
CType_sample oType_sample = new CType_sample();
oType_sample.Cod_type_sample = tbCode.Text;
oType_sample.Name_type_sample = tbName.Text;
oType_sample.Description = tbDescription.Text;
oType_sample.Prefix = tbPrefix.Text;
bool result = false;
if (!(result = faType_sample.Update(oType_sample)))
{
result = faType_sample.Insert(oType_sample);
}
return(result);
}
void InitDataControls()
{
deDateCreation.DateTime = Comun.GetDate();
tbNumDaysValid.Value = new CSettings().GetNumDaysPriceDefault();
// --- init company
cbCompany.Properties.DataSource = new CCompanyFactory().GetAll();
cbCompany.Properties.DisplayMember = "Business_name";
cbCompany.Properties.ValueMember = "Idcompany";
// --- 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";
Reception oReception = new Reception();
// --- init type person
repPerson_type.DataSource = oReception.GetLstPersonType();
repPerson_type.DisplayMember = "Name";
repPerson_type.ValueMember = "Id";
// --- init methods
gcPrice.DataSource = new BindingList <PriceMethod>(new ModPrice().GetPriceMethod(null));
// --- init plantillas
CMemo_templateFactory faMemo_template = new CMemo_templateFactory();
gcParagraphHistoryIni.DataSource = faMemo_template.GetAll().Where(c => c.Memo_type == 1).ToList();
gcParagraphHistoryEnd.DataSource = faMemo_template.GetAll().Where(c => c.Memo_type == 2).ToList();
// --- init adjuntos
List <Anexos> list = new ModPrice().GetLstAnexos(null);
gcAnexos.DataSource = new BindingList <Anexos>(list);
}
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 InitData()
{
#region init combos
try
{
// --- init: type of sample
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";
repTypeSample.DataSource = faType_Sample.GetAll();
repTypeSample.ValueMember = "Cod_type_sample";
repTypeSample.DisplayMember = "Name_type_sample";
// --- init: type of analysis
cbTypeAnalysis.Properties.DataSource = Comun.ListTypeAnalysis;
cbTypeAnalysis.Properties.ValueMember = "Type_analisys";
cbTypeAnalysis.Properties.DisplayMember = "Den_Type_Analysis";
repTypeAnalysis.DataSource = Comun.ListTypeAnalysis;
repTypeAnalysis.ValueMember = "Type_analisys";
repTypeAnalysis.DisplayMember = "Den_Type_Analysis";
// --- init: digestation
CDigestion_methodFactory faDigestation_Method = new CDigestion_methodFactory();
cbDigestion.Properties.DataSource = faDigestation_Method.GetAll();
cbDigestion.Properties.ValueMember = "Cod_digestion_method";
cbDigestion.Properties.DisplayMember = "Name_digestion_method";
// --- init: element
CElementFactory faElement = new CElementFactory();
cbElement.Properties.DataSource = faElement.GetAll();
cbElement.Properties.ValueMember = "Idelement";
cbElement.Properties.DisplayMember = "Cod_element";
repElement.DataSource = faElement.GetAll();
repElement.ValueMember = "Idelement";
repElement.DisplayMember = "Cod_element";
// --- init: measurement unit number 1
cbRepetition.Properties.DataSource = Comun.ListTypeRepetition;
cbRepetition.Properties.DisplayMember = "Name_repetition";
cbRepetition.Properties.ValueMember = "Cod_repetition";
Methods oMethods = new Methods();
gluCod_method.Properties.DataSource = oMethods.GetAllLastVersionMethods();
gluCod_method.Properties.DisplayMember = "Cod_template_method";
gluCod_method.Properties.ValueMember = "Cod_template_method";
CReactiveFactory faReactive = new CReactiveFactory();
List <CReactive> lstReactive = faReactive.GetAll();
lstReactive.Add(new CReactive()
{
Idreactive = 0, Reactive_name = "---", Chemical_formula = "---"
});
gluCod_method.Properties.View.BestFitColumns();
}
catch (Exception ex)
{
ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message);
}
#endregion
}
