本文整理汇总了C#中SessionFactory.ExecuteScalar方法的典型用法代码示例。如果您正苦于以下问题：C# SessionFactory.ExecuteScalar方法的具体用法？C# SessionFactory.ExecuteScalar怎么用？C# SessionFactory.ExecuteScalar使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SessionFactory的用法示例。
在下文中一共展示了SessionFactory.ExecuteScalar方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: AddNavigation
public ActionResult AddNavigation()
{
string url = Request.Params["nav"];
string handleId = Request.Params["handleId"];
try
{
CurrentAccountId = UserActivity.UserNameIdMapHolder.GetId(CurrentAccountNo);
}
catch (Exception e)
{
Log.Error("系统获取用户ID失败，错误信息：{0}", e.Message);
}
using (var session = new SessionFactory().OpenSession())
{
const string sql =
"SELECT id 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 `url` = '{1}'";
var exceptId = session.ExecuteScalar<string>(string.Format(sql, CurrentAccountNo, url.Replace("'", "''"))).TryToLong();
if (!exceptId.HasValue)
{
return new JsonResult
{
Data = new { status = 100, message = "你未被授权，不能添加该项快捷操作！", handleId },
ContentEncoding = Encoding.UTF8
};
}
var item =
session.Load<AccountNavigationRef>(
m => m.Type.Equals(2) && m.OwnerId.Equals(CurrentAccountId) && m.NavigationId.Equals(exceptId));
if (item != null)
{
return new JsonResult
{
Data = new { status = 100, message = "你已添加该项快捷操作！", handleId },
ContentEncoding = Encoding.UTF8
};
}
item = new AccountNavigationRef
{
Type = 2,
OwnerId = CurrentAccountId,
NavigationId = exceptId.GetValueOrDefault(0),
CreatedAt = DateTime.Now,
CreatedBy = CurrentAccountNo
};
if (session.Create(item))
{
return new JsonResult
{
Data = new { status = 200, message = "增加成功！", handleId },
ContentEncoding = Encoding.UTF8
};
}
return new JsonResult
{
Data = new { status = 100, message = "操作失败！", handleId },
ContentEncoding = Encoding.UTF8
};
}
}示例2: OnActionExecuting
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (NotCheck) return;
const string missing = "___";
var accountNo = HttpContext.Current.User.Identity.Name ?? missing;
//if (accountNo.Equals("root", StringComparison.CurrentCultureIgnoreCase))
//{
// // 如果是系统管理员，验证通过
// if (IsAdminPass) return;
// if (!filterContext.HttpContext.IsDebuggingEnabled)
// {
// filterContext.Result = new RedirectResult("~/Base/Session/Forbidden");
// return;
// }
//}
const string sql = @"SELECT `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` = '{1}'";
using (var session = new SessionFactory().OpenSession())
{
var priviledge = session.ExecuteScalar<string>(string.Format(sql, accountNo, Name ?? missing));
if (string.IsNullOrEmpty(priviledge))
{
filterContext.Result = new RedirectResult("~/Base/Session/Forbidden");
}
}
//// session 变量取不到，验证失败
//var userPriviledgesObj = filterContext.HttpContext.Session[Const.AccountPriviledge];
//if (userPriviledgesObj == null)
//{
// filterContext.Result = new RedirectResult("~/Base/Session/Login");
// return;
//}
//// session 变量无值，验证失败
//var userPriviledges = userPriviledgesObj as List<string>;
//if (userPriviledges == null)
//{
// filterContext.Result = new RedirectResult("~/Base/Session/Login");
// return;
//}
//// session不包含所授，验证失败
//if (!userPriviledges.Contains(Name))
//{
// filterContext.Result = new RedirectResult("~/Base/Session/Login");
//}
}示例3: RemoveNavigation
public ActionResult RemoveNavigation()
{
string url = Request.Params["nav"];
string handleId = Request.Params["handleId"];
try
{
CurrentAccountId = UserActivity.UserNameIdMapHolder.GetId(CurrentAccountNo);
}
catch (Exception e)
{
Log.Error("系统获取用户ID失败，错误信息：{0}", e.Message);
}
using (var session = new SessionFactory().OpenSession())
{
const string sql = "SELECT id FROM `navigations` WHERE `url` = '{0}'";
var exceptId = session.ExecuteScalar<string>(string.Format(sql, url.Replace("'", "''"))).TryToLong();
if (
session.Delete<AccountNavigationRef>(
m => m.Type.Equals(2) && m.OwnerId.Equals(CurrentAccountId) && m.NavigationId.Equals(exceptId)))
{
return JsonDataResult(new { status = 200, message = "删除成功！", handleId });
}
return JsonDataResult(new { status = 100, message = "操作失败！", handleId });
}
}