public ActionResult CheckButtons() { var urlsContent = Request.Params["urls"]; var urls = JsonConvert.DeserializeObject<string[]>(urlsContent); if (urls.Length == 0) { return JsonData(urls); } const string sql = "SELECT LOWER(`url`) FROM `navigations` WHERE ((`auth_code` = 0) OR `id` IN ( SELECT `navigation_id` FROM `navigation_priviledges` WHERE (`flag` = 1 AND `owner_id` IN (SELECT `role_id` FROM `account_role_refs` WHERE `account_id` IN ( SELECT `id` FROM `accounts` WHERE `name` = '{0}'))) OR (`flag` = 2 AND `owner_id` IN ( SELECT `id` FROM `accounts` WHERE `name` = '{0}')))) AND `url` IN ({1})"; using (var session = new SessionFactory().OpenSession()) { var accountNo = User.Identity.Name; var resultUrls = session.ExecuteQuery<string>(string.Format(sql, accountNo, "'" + string.Join("','", urls) + "'")); return JsonData(resultUrls); } }
public ActionResult GetTipNames(FormCollection collection) { var names = (Request.Params["names"] + string.Empty).Split(','); if (names.Length == 0) { return ((BaseController)this).JsonData(new string[0]); } const string sql = "SELECT LOWER(`name`) FROM `navigations` WHERE `id` IN ( SELECT `navigation_id` FROM `navigation_priviledges` WHERE (`flag` = 1 AND `owner_id` IN (SELECT `role_id` FROM `account_role_refs` WHERE `account_id` IN ( SELECT `id` FROM `accounts` WHERE `name` = '{0}'))) OR (`flag` = 2 AND `owner_id` IN ( SELECT `id` FROM `accounts` WHERE `name` = '{0}'))) AND `name` IN ({1})"; using (var session = new SessionFactory().OpenSession()) { var accountNo = User.Identity.Name; var resultNames = session.ExecuteQuery<string>(string.Format(sql, accountNo, "'" + string.Join("','", names) + "'")); return ((BaseController)this).JsonData(resultNames); } }
public ActionResult SyncModelToDb() { var assembly = typeof(Account).Assembly; var modelNames = new List<string>(); var existModelNames = new List<string>(); IList<string> existList; using (var session = new SessionFactory().OpenSession()) { existList = session.ExecuteQuery<string>("show tables"); } foreach (var type in assembly.GetExportedTypes()) { var isMatched = type.FullName.IndexOf(PackageName, StringComparison.Ordinal) > -1 && type.FullName.IndexOf('.', 15) > -1 && type.IsClass; if (!isMatched) continue; var name = DevelopmentActivity.GetTableName(type); if (existList.Contains(name)) existModelNames.Add(type.FullName); else modelNames.Add(type.FullName); } existModelNames.Sort(); modelNames.Sort(); ViewData["modelNames"] = modelNames; ViewData["existModelNames"] = existModelNames; return View(); }