public static bool SetOpVerData(Sys_Customer customerSrNo, string partNo, string cusVer, ComboBoxEx OpVerCombobox)
{
try
{
//IList<Com_PEMain> comPEMain = session.QueryOver<Com_PEMain>()
// .Where(x => x.sysCustomer == customerSrNo)
// .Where(x => x.partName == partNo)
// .Where(x => x.customerVer == cusVer)
// .List<Com_PEMain>();
IList <Com_PEMain> comPEMain1 = new List <Com_PEMain>();
CaxSQL.GetListCom_PEMain(customerSrNo, partNo, cusVer, out comPEMain1);
//CusVerCombobox.DisplayMember = "customerVer";
//CusVerCombobox.ValueMember = "peSrNo";
foreach (Com_PEMain i in comPEMain1)
{
if (OpVerCombobox.Items.Contains(i.opVer))
{
continue;
}
OpVerCombobox.Items.Add(i.opVer);
}
//CusVerCombobox.Items.Add(comPEMain);
}
catch (System.Exception ex)
{
return(false);
}
return(true);
}
public static bool SetPartNoData(Sys_Customer customerSrNo, ComboBoxEx PartNoCombobox)
{
try
{
//MessageBox.Show(customerSrNo.customerSrNo.ToString());
//IList<Com_PEMain> comPEMain = session.QueryOver<Com_PEMain>()
// .Where(x => x.sysCustomer == customerSrNo)
// .List<Com_PEMain>();
IList <Com_PEMain> comPEMain1 = new List <Com_PEMain>();
CaxSQL.GetListCom_PEMain(customerSrNo, out comPEMain1);
foreach (Com_PEMain i in comPEMain1)
{
if (PartNoCombobox.Items.Contains(i.partName))
{
continue;
}
PartNoCombobox.Items.Add(i.partName);
}
}
catch (System.Exception ex)
{
return(false);
}
return(true);
}