public IQueryable <SM02ViewModel> Get(string year, string org, string dept, string soft_id, int CurrPage, int PageSize, out int TotalRow)
{
List <SM02ViewModel> model = new List <SM02ViewModel>();
//var dbresult = db.Get().AsQueryable();
//TotalRow = db.Get().ToList().Count;
var dbresult_all = db.Get().Where(r => r.org == org && r.dept == dept && r.soft_id == soft_id && r.year == year).AsQueryable();
//var dbresult = db.Get().ToList().Skip((CurrPage - 1) * PageSize).Take(PageSize).AsQueryable();
var dbresult = dbresult_all.Where(r => r.org == org && r.dept == dept && r.soft_id == soft_id && r.year == year);
TotalRow = dbresult_all.Count();
dbresult = dbresult.Skip(TotalRow - (CurrPage * PageSize)).Take(PageSize).AsQueryable();
foreach (var items in dbresult)
{
SM02ViewModel _model = new SM02ViewModel();
_model.year = items.year.Trim();
_model.org = items.org.Trim();
_model.dept = items.dept.Trim();
_model.soft_id = items.soft_id.Trim();
_model.detail_id = items.detail_id;
_model.keep_org = string.IsNullOrEmpty(items.keep_org) ? null : items.keep_org.Trim();
_model.keep_man = string.IsNullOrEmpty(items.keep_man) ? null : items.keep_man.Trim();
_model.use_org = string.IsNullOrEmpty(items.use_org) ? null : items.use_org.Trim();
_model.use_man = string.IsNullOrEmpty(items.use_man) ? null : items.use_man.Trim();
_model.soft_ver = string.IsNullOrEmpty(items.soft_ver) ? null : items.soft_ver.Trim();
_model.soft_cost = items.soft_cost == null ? null : items.soft_cost;
_model.auth_number = items.auth_number == null ? null : items.auth_number;
_model.update_date = items.update_date == null ? DateTime.MinValue : items.update_date.ToLocalTime();
_model.decrease_reason = string.IsNullOrEmpty(items.decrease_reason) ? null : items.decrease_reason.Trim();
_model.decrease_handle = string.IsNullOrEmpty(items.decrease_handle) ? null : items.decrease_handle.Trim();
_model.detail_memo = string.IsNullOrEmpty(items.detail_memo) ? null : items.detail_memo.Trim();
model.Add(_model);
}
return(model.AsQueryable());
}
public void saveSM02(SM02ViewModel viewmodel)
{
sm02_soft_keep_detail _model = SM02VMtoM(viewmodel);
db.Update(_model);
}
public void addSM02(SM02ViewModel viewmodel)
{
sm02_soft_keep_detail _model = SM02VMtoM(viewmodel);
db.Insert(_model);
}
