public ActionResult GetRoleList(int?page) { page = page == null ? 1 : page; //string sql = "select m.*,d.ItemText StatusName from tb_Role m left join tb_Doption d on d.MoptionID=2 and d.ItemValue=m.Status where 1=1 "; string KeyWord = DNTRequest.GetString("KeyWord"); string Status = DNTRequest.GetString("Status"); int rows = DNTRequest.GetInt("rows", 10); //if (KeyWord != "") //{ // sql += " and (m.RoleName like '%" + KeyWord + "%') "; //} //if (Status != "") //{ // sql += " and (m.Status =" + Status + ")"; //} int count = 0; DataSet ds = ubll.GetList(); //DataSet ds = DataPageHelper.GetDataPage(DataPageHelper.GetPageSql(sql, page.Value, rows, "RoleID desc"), out count); List <Role> list = TBToList <Role> .ConvertToList(ds.Tables[0]).ToList(); var grid = new EasyuiDataGrid <List <Role> >(); grid.total = count; grid.rows = list; //JavaScriptSerializer js = new JavaScriptSerializer(); return(Json(grid, JsonRequestBehavior.AllowGet)); }
public ActionResult GetUserRoleList() { FlowersEntities ef = new FlowersEntities(); List <Role> list = new List <Role>(); UserMasterBLL ubb = new UserMasterBLL(); DataSet ds = ubb.GetList(); Role role = new Role(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { role.roleId = Convert.ToInt32(ds.Tables[0].Rows[i]["roleId"].ToString()); role.roleName = ds.Tables[0].Rows[i]["roleName"].ToString(); list.Add(role); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult UserlistEdit() { string id = DNTRequest.GetString("id"); List <SelectListItem> items1 = new List <SelectListItem>(); List <SelectListItem> items = new List <SelectListItem>(); Users model = new Users(); UserMasterBLL bll = new UserMasterBLL(); model = bll.GetModel(Convert.ToInt32(id)); DataSet ds = bll.GetList(); DataRow[] arr_row = ds.Tables[0].Select(); for (int i = 0; i < arr_row.Length; i++) { SelectListItem item = new SelectListItem(); item.Value = arr_row[i]["roleId"].ToString(); item.Text = arr_row[i]["roleName"].ToString(); items.Add(item); } ViewData["itemsrole"] = items; return(View(model)); }