protected override bool LoadRecordCore()
{
//vazebni tabulka
tAttSL = Data.TAttachmentSL.LoadBy("SampleList =@param0", (int)this.PrimaryKey);
//vlastni data -> nacti vsechny radky
tAttachment = new SmartISLib.ORM.DbTable<Data.TAttachments>();
foreach (Data.TAttachmentSL t in tAttSL)
{
tAttachment.Add(Data.TAttachments.Load(t.Attachment));
}
velikostKrabicComboData = Data.TSampleListCis.LoadBy("SCategory =@param0", "VelikostKrabice");
velikostKrabicComboData.Sort("Name");
zpracovalWIComboData = Data.TPersonResponsiblePhoto.LoadBy("ResponsiblePhotoCode !=@param0", "null");
zpracovalWIComboData.Sort("ResponsiblePhotoCode");
kdoSchvalilWIComboData = Data.TPersonResponsiblePhoto.LoadBy("ResponsiblePhotoCode !=@param0", "null");
zpracovalWIComboData.Sort("ResponsiblePhotoCode");
druhBaleniComboData = Data.TSampleListCis.LoadBy("SCategory =@param0 and Name !=@param1", "DruhBaleni", "null");
druhBaleniComboData.Sort("Name");
zemeComboData = Data.TZeme.LoadAll();
zemeComboData.Sort("Zeme");
statusSetuComboData = Data.TSampleListCis.LoadBy("SCategory =@param0 and Name !=@param1", "status", "null");
statusSetuComboData.Sort("Name");
breatherBagComboData = Data.TSampleListCis.LoadBy("SCategory =@param0 and name !=@param1", "BreatherBag", "null");
breatherBagComboData.Sort("Name");
parentDTAB = SmartISLib.Data.GetDataTable("SELECT * FROM QFSampleListsTest WHERE IDSampleList = " + (int)this.PrimaryKey);
prikazyKVyskladneniDTAB = SmartISLib.Data.GetDataTable("select * from QFPrikazVyskladneniSeznam where CisloSetu = '" + Convert.ToString(parentDTAB.Rows[0]["CisloSetu"]) + "'");
historieZmenDTAB = SmartISLib.Data.GetDataTable("SELECT * FROM THistoryUpdates WHERE TableID = " + (int)this.PrimaryKey);
metodaBalenHlavniiDTAB = SmartISLib.Data.GetDataTable("select * from QSLMetodaBaleniHlavni");
metodaBaleniVedlejsiDTAB = SmartISLib.Data.GetDataTable("select * from QSLMetodaBaleniVedlejsi");
return true;
}
