本文整理汇总了C#中SES.Service.OrmliteConnection.UpdateOnly方法的典型用法代码示例。如果您正苦于以下问题：C# OrmliteConnection.UpdateOnly方法的具体用法？C# OrmliteConnection.UpdateOnly怎么用？C# OrmliteConnection.UpdateOnly使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SES.Service.OrmliteConnection的用法示例。
在下文中一共展示了OrmliteConnection.UpdateOnly方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SavePermission
public ActionResult SavePermission(int RoleID, string Action, string MenuIDs)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if(RoleID == 0 || string.IsNullOrEmpty(Action))
return Json(new { success = false, message = "Có dữ liệu rỗng" });
if (string.IsNullOrEmpty(MenuIDs))
{
db.UpdateOnly(new Auth_Action() { IsAllowed = false, RowUpdatedAt = DateTime.Now, RowUpdatedBy = currentUser.UserID },
onlyFields: p => new { p.IsAllowed, p.RowUpdatedAt, p.RowUpdatedBy },
where: p => p.RoleID == RoleID && p.Action == Action);
}
else
{
db.ExecuteNonQuery("p_Auth_Action_Save_By_RoleID @RoleID, @UserID, @Action, @MenuIDs", new
{
RoleID = RoleID,
UserID = currentUser.UserID,
Action = Action,
MenuIDs = MenuIDs
});
}
return Json(new { success = true });
}
catch (Exception e) { return Json(new { success = false, message = e.Message }); }
finally { db.Close(); }
}示例2: SaveCustomerHirerachy
public ActionResult SaveCustomerHirerachy(string CustomerID, string CustomerHirerachyIDs)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (string.IsNullOrEmpty(CustomerHirerachyIDs))
{
db.UpdateOnly(new CustomerHirerachyDetail() { Status = false, UpdatedAt = DateTime.Now, UpdatedBy = currentUser.UserID },
onlyFields: p => new { p.Status, p.UpdatedAt, p.UpdatedBy },
where: p => p.CustomerID == CustomerID);
}
else
{
db.ExecuteNonQuery("p_CustomerHirerachyDetail_Save_By_CustomerID @CustomerID, @UserID, @CustomerHirerachyIDs", new
{
CustomerID = CustomerID,
UserID = currentUser.UserID,
CustomerHirerachyIDs = CustomerHirerachyIDs
});
}
return Json(new { success = true });
}
catch (Exception e) { return Json(new { success = false, message = e.Message }); }
finally { db.Close(); }
}