public List <View_UserModel> View_UserFenYe <K>(int currentPage, int PageSize, out int rows)
{
var list = CreateContext().View_User.AsNoTracking().OrderBy(e => e.u_id).ToList();
rows = list.Count();
var data = list
.Skip((currentPage - 1) * PageSize)
.Take(PageSize)
.ToList();
List <View_UserModel> list2 = new List <View_UserModel>();
foreach (var item in data)
{
View_UserModel sd = new View_UserModel()
{
U_id = item.u_id,
U_name = item.u_name,
U_true_name = item.u_true_name,
U_password = item.u_password,
U_name1 = item.u_name1
};
list2.Add(sd);
}
return(list2);
}
public int View_UserUpdate(View_UserModel s)
{
View_User sd = new View_User()
{
u_id = s.U_id,
u_name = s.U_name,
u_true_name = s.U_true_name,
u_password = s.U_password,
u_name1 = s.U_name1
};
return(Update(sd));
}
public List <View_UserModel> View_UserSelect()
{
List <View_User> list = Select();
List <View_UserModel> list2 = new List <View_UserModel>();
foreach (View_User item in list)
{
View_UserModel sd = new View_UserModel()
{
U_id = item.u_id,
U_name = item.u_name,
U_true_name = item.u_true_name,
U_password = item.u_password,
U_name1 = item.u_name1
};
list2.Add(sd);
}
return(list2);;
}
public List <View_UserModel> SelectView_UserBy(int id)
{
MyDbContext db = CreateContext();
List <View_User> list = db.View_User.AsNoTracking()
.Where(e => e.u_id == id)
.Select(e => e)
.ToList();
List <View_UserModel> list2 = new List <View_UserModel>();
foreach (View_User item in list)
{
View_UserModel sd = new View_UserModel()
{
U_id = item.u_id,
U_name = item.u_name,
U_true_name = item.u_true_name,
U_password = item.u_password,
U_name1 = item.u_name1
};
list2.Add(sd);
}
return(list2);;
}
public int View_UserUpdate(View_UserModel sm)
{
return(ist.View_UserUpdate(sm));
}
public int View_UserDelete(View_UserModel sm)
{
return(ist.View_UserDelete(sm));
}
public int View_UserAdd(View_UserModel sm)
{
return(ist.View_UserAdd(sm));
}
