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));
}
