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