public List <WorkNameOutput> WorkNameList()
{
List <C16_WorkType> items = db.C16_WorkType.ToList();
List <WorkNameOutput> lstWorkName = new List <WorkNameOutput>();
foreach (C16_WorkType item in items)
{
WorkNameOutput wn = new WorkNameOutput();
wn.WorkID = item.WorkID;
wn.WorkName = item.WorkName;
wn.WorkGroup = item.WorkGroup;
lstWorkName.Add(wn);
}
items.Clear();
return(lstWorkName);
}
public WorkNameOutput FindWorkNameByID(int id)
{
if (id < 0)
{
return(null);
}
var item = db.C16_WorkType.FirstOrDefault(s => s.WorkID == id);
if (item == null)
{
return(null);
}
WorkNameOutput wn = new WorkNameOutput();
wn.WorkID = item.WorkID;
wn.WorkName = item.WorkName;
wn.WorkGroup = item.WorkGroup;
return(wn);
}
public List <WorkNameOutput> FindWorkInGroup(int groupID)
{
if (groupID < 0)
{
groupID = 1;
}
List <C16_WorkType> items = db.C16_WorkType.Where(s => s.WorkGroup == groupID).ToList();
List <WorkNameOutput> lstWorkName = new List <WorkNameOutput>();
foreach (C16_WorkType item in items)
{
WorkNameOutput wn = new WorkNameOutput();
wn.WorkID = item.WorkID;
wn.WorkName = item.WorkName;
wn.WorkGroup = item.WorkGroup;
lstWorkName.Add(wn);
}
items.Clear();
return(lstWorkName);
}