public void TransactionTest2()
{
var helper = dbHelper; //当前访问对象
helper.BeginTran(); //开启事物
try
{
var product = new ProductData()
{
ProductName = "test", BarCode = "1212"
};
//使用当前会话创建ProductDataManage实例
//ProductDataManage对象使用的数据访问和当前是一个
ProductDataManage.ContextInstance(this).Add(product);
var c = new CRL.ParameCollection();
c["userId"] = 1;
helper.Update <Order>(b => b.Id == 100, c);
helper.CommitTran();//提交
}
catch (Exception ex)
{
helper.RollbackTran();//如果出错回滚
}
}
public ActionResult Save(CRL.Package.RoleAuthorize.Department Department)
{
CRL.ParameCollection c = new CRL.ParameCollection();
c["name"] = Department.Name;
c["Disable"] = Department.Disable;
c["Sort"] = Department.Sort;
CRL.Package.RoleAuthorize.DepartmentBusiness.Instance.Update(b => b.SequenceCode == Department.SequenceCode && b.DataType == 0, c);
return(JsonResult(true, ""));
}
public ActionResult Update(CRL.Package.RoleAuthorize.Role role)
{
CRL.ParameCollection c = new CRL.ParameCollection();
c["Name"] = role.Name;
c["Remark"] = role.Remark;
CRL.Package.RoleAuthorize.RoleBusiness.Instance.Update(b => b.Id == role.Id, c);
return Redirect(Request.UrlReferrer.ToString());
return AutoBackResult("操作成功", Request.UrlReferrer.ToString());
}
public ActionResult Update(CRL.Package.RoleAuthorize.Role role)
{
CRL.ParameCollection c = new CRL.ParameCollection();
c["Name"] = role.Name;
c["Remark"] = role.Remark;
CRL.Package.RoleAuthorize.RoleBusiness.Instance.Update(b => b.Id == role.Id, c);
return(Redirect(Request.UrlReferrer.ToString()));
return(AutoBackResult("操作成功", Request.UrlReferrer.ToString()));
}
/// <summary>
/// 指定条件和参数进行更新
/// </summary>
/// <typeparam name="TModel"></typeparam>
/// <param name="expression"></param>
/// <param name="setValue"></param>
/// <returns></returns>
public int Update <TModel>(Expression <Func <TModel, bool> > expression, CRL.ParameCollection setValue) where TModel : CRL.IModel, new()
{
var query = CreateLambdaQuery <TModel>();
query.Where(expression);
var n = Update(query, setValue);
UpdateCacheItem <TModel>(expression, setValue);
return(n);
}
public void TestRelationUpdate()
{
var query = GetLambdaQuery();
query.Join <ProductData>((a, b) => a.Id == b.Id && b.Number > 10);
var c = new CRL.ParameCollection();
c["UserId"] = "$UserId"; //order.userid=product.userid
c["Remark"] = "2222"; //order.remark=2222
Update(query, c);
}
public ActionResult Update(CRL.Package.RoleAuthorize.Menu menu)
{
CRL.ParameCollection c = new CRL.ParameCollection();
menu.Url = GetUrl(menu.Url);
c["Name"] = menu.Name.Trim();
c["Url"] = menu.Url.Trim();
c["Disable"] = menu.Disable;
c["ShowInNav"] = menu.ShowInNav;
c["Sort"] = menu.Sort;
CRL.Package.RoleAuthorize.MenuBusiness.Instance.Update(b => b.Id == menu.Id, c);
//return AutoBackResult("操作成功", Request.UrlReferrer.ToString());
return(Redirect(Request.UrlReferrer.ToString()));
}
public void TestUpdate()
{
var helper = dbHelper; //当前访问对象
helper.BeginTran(); //开启事物
try
{
helper.InsertFromObj(new Order());
var c = new CRL.ParameCollection();
c["userId"] = 1;
helper.Update <Order>(b => b.Id == 100, c);
helper.CommitTran();//提交
}
catch (Exception ex)
{
helper.RollbackTran();//如果出错回滚
}
}
/// <summary>
/// 指定条件和参数进行更新
/// </summary>
/// <typeparam name="TModel"></typeparam>
/// <param name="expression"></param>
/// <param name="setValue"></param>
/// <returns></returns>
public int Update <TModel>(System.Linq.Expressions.Expression <Func <TModel, bool> > expression, CRL.ParameCollection setValue) where TModel : CRL.IModel, new()
{
var query = CreateLambdaQuery <TModel>();
query.Where(expression);
var n = Update(query, setValue);
System.Threading.Tasks.Task.Run(() =>
{
UpdateCacheItem <TModel>(expression, setValue);
});
return(n);
}
/// <summary> /// 使用完整查询更新 /// </summary> /// <typeparam name="TModel"></typeparam> /// <param name="query"></param> /// <param name="updateValue"></param> /// <returns></returns> public abstract int Update <TModel>(CRL.LambdaQuery.LambdaQuery <TModel> query, CRL.ParameCollection updateValue) where TModel : CRL.IModel, new();
/// <summary>
/// 关联更新
/// </summary>
/// <typeparam name="TModel"></typeparam>
/// <typeparam name="TJoin"></typeparam>
/// <param name="expression"></param>
/// <param name="updateValue"></param>
/// <returns></returns>
public abstract int Update <TModel, TJoin>(System.Linq.Expressions.Expression <Func <TModel, TJoin, bool> > expression, CRL.ParameCollection updateValue)
where TModel : CRL.IModel, new()
where TJoin : CRL.IModel, new();
public ActionResult Save(CRL.Package.RoleAuthorize.Department Department)
{
CRL.ParameCollection c = new CRL.ParameCollection();
c["name"] = Department.Name;
c["Disable"] = Department.Disable;
c["Sort"] = Department.Sort;
CRL.Package.RoleAuthorize.DepartmentBusiness.Instance.Update(b => b.SequenceCode == Department.SequenceCode && b.DataType == 0, c);
return JsonResult(true, "");
}
public ActionResult Update(CRL.Package.RoleAuthorize.Menu menu)
{
CRL.ParameCollection c = new CRL.ParameCollection();
menu.Url = GetUrl(menu.Url);
c["Name"] = menu.Name.Trim();
c["Url"] = menu.Url.Trim();
c["Disable"] = menu.Disable;
c["ShowInNav"] = menu.ShowInNav;
c["Sort"] = menu.Sort;
CRL.Package.RoleAuthorize.MenuBusiness.Instance.Update(b => b.Id == menu.Id, c);
//return AutoBackResult("操作成功", Request.UrlReferrer.ToString());
return Redirect(Request.UrlReferrer.ToString());
}
/// <summary>
/// 关联更新
/// </summary>
/// <typeparam name="TModel"></typeparam>
/// <typeparam name="TJoin"></typeparam>
/// <param name="expression"></param>
/// <param name="updateValue"></param>
/// <returns></returns>
public int Update <TModel, TJoin>(System.Linq.Expressions.Expression <Func <TModel, TJoin, bool> > expression, CRL.ParameCollection updateValue)
where TModel : CRL.IModel, new()
where TJoin : CRL.IModel, new()
{
var query = CreateLambdaQuery <TModel>();
query.Join(expression);
return(Update(query, updateValue));
}
/// <summary> /// 使用完整查询更新 /// </summary> /// <typeparam name="TModel"></typeparam> /// <param name="query"></param> /// <param name="updateValue"></param> /// <returns></returns> public abstract int Update <TModel>(ILambdaQuery <TModel> query, CRL.ParameCollection updateValue) where TModel : class;
