C# (CSharp) studentLeaveSystemEntities Examples

Example #1

 public JsonResult SelectLeaveBy(int rows, int pagesize, string stuNum)
 {
     using (var a = new studentLeaveSystemEntities())
     {
         var leave = db.LeaveInfo.SqlQuery("select top " + rows + "* from LeaveInfo where Lid not in(select top ((" + (pagesize - 1) + "*" + rows + ")) Lid from LeaveInfo) and Statu=0 and StuNum=" + stuNum);
         return(Json(leave, JsonRequestBehavior.AllowGet));
     }
 }