public CascadingDropDownNameValue[] GetProductByProject( string knownCategoryValues, string category) { StringDictionary categoryValues = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); string project = categoryValues["Project"]; List <CascadingDropDownNameValue> result = new List <CascadingDropDownNameValue>(); if (string.Equals(project, "Mach", StringComparison.OrdinalIgnoreCase)) { MachLookupDAL dal = new MachLookupDAL(); var machs = dal.GetAllMach(); foreach (var item in machs) { result.Add(new CascadingDropDownNameValue() { name = item.Name, value = item.Mach_Id.ToString() }); } } else if (string.Equals(project, "Install", StringComparison.OrdinalIgnoreCase)) { InstallLookupDAL dal = new InstallLookupDAL(); var installs = dal.GetAllLookup(); foreach (var item in installs) { result.Add(new CascadingDropDownNameValue() { name = item.Name, value = item.Install_Id.ToString() }); } } else if (string.Equals(project, "Product", StringComparison.OrdinalIgnoreCase)) { ProductDAL dal = new ProductDAL(); var products = dal.GetAllProducts(); foreach (var item in products) { result.Add(new CascadingDropDownNameValue() { name = item.Product_Name, value = item.Product_Id.ToString() }); } } else if (string.Equals(project, "EndProduct", StringComparison.OrdinalIgnoreCase)) { EndProductDAL dal = new EndProductDAL(); var endProducts = dal.GetAllEndProductList(); foreach (var item in endProducts) { result.Add(new CascadingDropDownNameValue() { name = item.Name, value = item.EP_Id.ToString() }); } } return(result.ToArray()); }
private List <NameValueItem> GetProductByProject(string project) { List <NameValueItem> result = new List <NameValueItem>(); if (string.Equals(project, "加工", StringComparison.OrdinalIgnoreCase)) { MachLookupDAL dal = new MachLookupDAL(); var machs = dal.GetAllMach(); foreach (var item in machs) { result.Add(new NameValueItem() { Name = item.Name, Value = item.Mach_Id.ToString() }); } } else if (string.Equals(project, "安装", StringComparison.OrdinalIgnoreCase)) { InstallLookupDAL dal = new InstallLookupDAL(); var installs = dal.GetAllLookup(); foreach (var item in installs) { result.Add(new NameValueItem() { Name = item.Name, Value = item.Install_Id.ToString() }); } } else if (string.Equals(project, "材料", StringComparison.OrdinalIgnoreCase)) { ProductDAL dal = new ProductDAL(); var products = dal.GetAllProducts(); foreach (var item in products) { result.Add(new NameValueItem() { Name = item.Product_Name + "/" + item.Product_Code, Value = item.Product_Id.ToString() }); } } else if (string.Equals(project, "成品", StringComparison.OrdinalIgnoreCase)) { EndProductDAL dal = new EndProductDAL(); var endProducts = dal.GetAllEndProductList(); foreach (var item in endProducts) { result.Add(new NameValueItem() { Name = item.Name + "/" + item.Code, Value = item.EP_Id.ToString() }); } } return(result); }
public static List <NameValueItem> GetMachTypeList() { MachLookupDAL dal = new MachLookupDAL(); var result = from m in dal.GetAllMach() select new NameValueItem() { Name = m.Name, Value = m.Mach_Id.ToString() }; return(result.ToList()); }
public void BindControl() { MachLookupDAL dal = new MachLookupDAL(); Utility.BindDataToRepeater(rpMachiningInstall, dal.GetAllMach()); }