public ActionResult GetSOList()
{
int count = 0;
//string sql = @"select p.Uname,p.Sex,p.roleId,p.truename,p.UId from Users p order by UId desc";
//string sql = @"select * ,(select top 1 truename from [dbo].Users where UId=m.UId) as truename, (select roleName from Role where roleId in(select top 1 roleId from Users where UId=m.UId)) as roelName from .[dbo].Users m where " + strWhere;
DataSet ds = bll.GetsOrdermin();
// DataSet ds = DataPageHelper.GetDataPage(DataPageHelper.GetPageSql(sql, 7, rows, "UId desc"), out count);
List <VOrderSminxi> list = TBToList <VOrderSminxi> .ConvertToList(ds.Tables[0]).ToList();
var grid = new EasyuiDataGrid <List <VOrderSminxi> >();
grid.total = count;
grid.rows = list;
return(Json(grid, JsonRequestBehavior.AllowGet));
}
