本文整理汇总了C#中SessionFactory.ExecuteQuery方法的典型用法代码示例。如果您正苦于以下问题：C# SessionFactory.ExecuteQuery方法的具体用法？C# SessionFactory.ExecuteQuery怎么用？C# SessionFactory.ExecuteQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SessionFactory的用法示例。
在下文中一共展示了SessionFactory.ExecuteQuery方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CheckButtons
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);
}
}示例2: GetTipNames
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);
}
}示例3: SyncModelToDb
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();
}