public JsonResult GetOneOut(string ManuId)//获取菜单未添加的按钮
{
//DataSet ds = OPBiz.ExecuteSqlToDataSet(" select * from RMS_Buttons where Id not in( select Id from Function_Buttons where Id='" + ManuId + "')");
//return Json(ds.Tables[0], JsonRequestBehavior.AllowGet);
var mql = RMS_ButtonsSet.SelectAll().Where(RMS_ButtonsSet.Id.NotIn(RMS_MenuButtonsSet.Select(RMS_MenuButtonsSet.ButtonId).Where(RMS_MenuButtonsSet.ManuId.Equal(ManuId))));
List <RMS_Buttons> Rmodel = BDBiz.GetOwnList <RMS_Buttons>(mql);
return(Json(Rmodel, JsonRequestBehavior.AllowGet));
}
public JsonResult GetOneIn(string ManuId)//获取菜单已经添加的按钮
{
var mql = V_MenuButtonsSet.SelectAll().Where(V_MenuButtonsSet.ManuId.Equal(ManuId)).OrderByASC(V_MenuButtonsSet.OrderNo);
// var mql = RMS_ButtonsSet.SelectAll().Where(RMS_ButtonsSet.Id.In(RMS_MenuButtonsSet.Select(RMS_MenuButtonsSet.ButtonId).Where(RMS_MenuButtonsSet.ManuId.Equal(ManuId))));
// List<RMS_Buttons> Rmodel = BDBiz.GetOwnList<RMS_Buttons>(mql);
List <V_MenuButtons> Rmodel = BDBiz.GetOwnList <V_MenuButtons>(mql);
return(Json(Rmodel, JsonRequestBehavior.AllowGet));
}
