本文整理汇总了C#中SES.Service.OrmliteConnection.FirstOrDefault方法的典型用法代码示例。如果您正苦于以下问题：C# OrmliteConnection.FirstOrDefault方法的具体用法？C# OrmliteConnection.FirstOrDefault怎么用？C# OrmliteConnection.FirstOrDefault使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SES.Service.OrmliteConnection的用法示例。
在下文中一共展示了OrmliteConnection.FirstOrDefault方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Registry
public ActionResult Registry(RegistryModel item)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
var isExist = db.FirstOrDefault<Auth_User>(p => p.UserID == item.UserName);
item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : "";
item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : "";
item.UserName = !string.IsNullOrEmpty(item.UserName) ? item.UserName : "";
if (isExist != null)
return Json(new { success = false, message = "Người dùng đã tồn tại" });
var user = new Auth_User();
user.UserID = item.UserName;
user.DisplayName = item.UserName;
user.Phone = item.Phone;
user.Email = item.Email;
user.IsActive = true;
user.FullName = item.UserName;
user.Password = SqlHelper.GetMd5Hash(item.Password);
user.RowCreatedAt = DateTime.Now;
user.RowCreatedBy = "CustomerRegistry";
user.Note = "";
db.Insert<Auth_User>(user);
var detail = new Auth_UserInRole();
detail.UserID = item.UserName;
detail.RoleID = 3;
detail.RowCreatedAt = DateTime.Now;
detail.RowCreatedBy = "CustomerRegistry";
db.Insert<Auth_UserInRole>(detail);
return Json(new { success = true, message = "Đăng ký thành công" });
}
catch (Exception e)
{
return Json(new { success = false, message = e.Message });
}
finally { db.Close(); }
}