public IQueryable <BD02ViewModel_SM01DDL> Get()
{
List <BD02ViewModel_SM01DDL> model = new List <BD02ViewModel_SM01DDL>();
var dbresult = db.Get().AsQueryable();
//TotalRow = db.Get().ToList().Count;
//var dbresult = db.Get().ToList().Skip((CurrPage - 1) * PageSize).Take(PageSize).ToList();
foreach (var items in dbresult)
{
BD02ViewModel_SM01DDL _model = new BD02ViewModel_SM01DDL();
_model.dept_id = items.dept_id.Trim();
_model.dept_name = items.dept_name.Trim();
_model.dept_org = items.dept_org.Trim();
_model.dept_year = items.dept_year.Trim();
model.Add(_model);
}
return(model.AsQueryable());
}
public IQueryable <BD02ViewModel_SM01DDL> Get_Dept()//RabyHungAdd_2016-10-05
{
List <BD02ViewModel_SM01DDL> model = new List <BD02ViewModel_SM01DDL>();
var dbresult = db.Get().AsQueryable();
//TotalRow = db.Get().ToList().Count;
//var dbresult = db.Get().ToList().Skip((CurrPage - 1) * PageSize).Take(PageSize).ToList();
foreach (var items in dbresult)
{
BD02ViewModel_SM01DDL _model = new BD02ViewModel_SM01DDL();
_model.dept_year = items.dept_year.Trim();
_model.dept_org = items.dept_org.Trim();
_model.org_name = db_BD01.Get().Where(x => x.org_id == _model.dept_org).ToList()[0].org_name.Trim(); //取得bd01_org資料表機關名稱，條件為：該表org_id等於model_view表的dept_org id
_model.dept_id = items.dept_id.Trim();
_model.dept_name = items.dept_name.Trim();
_model.dept_memo = items.dept_memo.Trim();
model.Add(_model);
}
return(model.AsQueryable());
}