//前台部分代码
<select class="form-control input-sm select9" id="EventType" name="EventType" style="padding: 0 0 0 5px; width: 150px; float: left ">
                            <option value="1">离线管理员门禁操作.</option>
                            <option value="2">门禁按钮开门操作</option>
                            <option value="3">门磁报警</option>
                            <option value="4">门禁状态</option>
                            <option value="5">非法开门报警</option>
                            <option value="6">火警</option>
                            <option value="7">掉电报警</option>
                            <option value="8">读头状态</option>
                        </select>
//后台相关代码
public JsonResult GetMJEvent(int id, string BeginDate, string EndDate, int DeptID, int pageIndex, int pageNum)
        {
            if (Session["SysUser"] == null)
            {
                RedirectToAction("Login", "Home");
            }
            SysUser sysUser = Session["SysUser"] as SysUser;
            List<NewEvent> events = new List<NewEvent>();
            if (DeptID == 0 && sysUser.Role != "1")
                DeptID = sysUser.DeptID;
            DateTime Bdt = string.IsNullOrWhiteSpace(BeginDate) ? Convert.ToDateTime("1989-01-01") : Convert.ToDateTime(BeginDate);
            DateTime Edt = string.IsNullOrWhiteSpace(EndDate) ? Convert.ToDateTime("2099-12-30") : Convert.ToDateTime(EndDate).AddDays(1);

            string sqlCol = @" select 
                            ROW_NUMBER() OVER( ORDER BY lp.Time desc ) AS RowNumber,
                            lp.ID,mach.MachNo,lp.EventType,lp.Event State,lp.Time ,dept.DeptName ";

            string sql = @" from MJ_Event lp
                                join Mach_Info mach on lp.MachNo = mach.ID
                                join ComDepartment dept on mach.DeptID = dept.ID
                                where mach.DeptID in (select ID from GetDeptIDsByPID(" + DeptID + "," + sysUser.CompanyID + "))";
            if (id != 0)
                sql += " and lp.ID = " + id;
            else
            {
                sql += @"    and lp.Time > DATEADD(DD,-1, CONVERT(Date,'" + Bdt.ToString("yyyy-MM-dd") + @"'))
                         and lp.Time <DATEADD(DD,1, CONVERT(Date,'" + Edt.ToString("yyyy-MM-dd") + @"'))";
            }
            string sqlTable = "select * from ( " + sqlCol + sql + " ) tt";
            if (pageIndex > 0 && pageNum > 0)
            {
                int pageBegin = pageNum * (pageIndex - 1) + 1;
                int pageEnd = pageNum * pageIndex;
                sqlTable += " where tt.RowNumber between " + pageBegin + " and " + pageEnd;
            }
            string sqlCount = "select COUNT(1) " + sql;
            int pageCount = 0;
            using (dbContext.Database.Connection)
            {
                dbContext.Database.Connection.Open();
                DbCommand cmd = dbContext.Database.Connection.CreateCommand();
                cmd.CommandText = sqlTable;
                DbDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    events.Add(new NewEvent()
                    {
                        ID = Convert.ToInt32(reader["ID"]),
                        DeptName = reader["DeptName"].ToString(),
                        EventType = Convert.ToInt32(reader["EventType"]),
                        MachNo = reader["MachNo"].ToString(),
                        State = Convert.ToInt32(reader["State"]),
                        Time = reader["Time"].ToString(),
                    });
                }
                reader.Close();
                DbCommand cmd2 = dbContext.Database.Connection.CreateCommand();
                cmd2.CommandText = sqlCount;
                pageCount = Convert.ToInt32(cmd2.ExecuteScalar());
            }
            JObject jo = new JObject();
            jo["data"] = JArray.Parse(JsonConvert.SerializeObject(events));
            jo["pageCount"] = (int)Math.Ceiling((double)pageCount / (double)pageNum);
            jo["pageIndex"] = pageIndex;
            return Json(JsonConvert.SerializeObject(jo), JsonRequestBehavior.AllowGet);

        }
后台和前台还要加什么代码