public ActionResult Form(SysRebateEntity model) { if (model.TipRebate > 100 || model.HourRebate > 100) { return(Error("返点不能大于100%")); } if (model.TipRebate < 0 || model.HourRebate < 0) { return(Error("返点不能小于0")); } if (model.id == 0) { var userModel = sysUserLogic.CheckUserName(model.UserAccount); if (userModel == null) { return(Error("当前用户名不存在,请重新输入")); } var rebateModel = sysRebateLogic.GetRebateByAccount(userModel.Id); if (rebateModel != null) { return(Error("用户已有平台返点信息,不可重复添加")); } model.ShopID = userModel.ShopID; model.UserID = userModel.Id; int row = sysRebateLogic.Insert(model); return(row > 0 ? Success() : Error()); } else { int row = sysRebateLogic.Update(model); return(row > 0 ? Success() : Error()); } }
/// <summary> /// 新增返点 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(SysRebateEntity model) { try { using (var db = GetInstance()) { model.CreateTime = DateTime.Now; model.ModifiedBy = OperatorProvider.Instance.Current.Account; model.ModifiedTime = model.CreateTime; return(db.Insertable(model).ExecuteReturnIdentity()); } } catch (Exception ex) { new LogLogic().Write(Level.Error, "新增返点", ex.Message, ex.StackTrace); } return(0); }
/// <summary> /// 更新返点 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(SysRebateEntity model) { try { using (var db = GetInstance()) { model.ModifiedBy = OperatorProvider.Instance.Current.Account; model.ModifiedTime = DateTime.Now; return(db.Updateable(model).UpdateColumns(it => new { it.TipRebate, it.HourRebate }).ExecuteCommand()); } } catch (Exception ex) { new LogLogic().Write(Level.Error, "修改商户", ex.Message, ex.StackTrace); } return(0); }
public int Insert(SysUser model, string password, string[] roleIds) { using (var db = GetInstance()) { try { db.Ado.BeginTran(); ////新增用户基本信息。 model.Id = Guid.NewGuid().ToString().Replace("-", ""); model.DeleteMark = "0"; model.CreateUser = OperatorProvider.Instance.Current.Account; model.CreateTime = DateTime.Now; model.ModifyUser = model.CreateUser; model.ModifyTime = model.CreateTime; model.Avatar = "/Content/framework/images/avatar.png"; int row = db.Insertable <SysUser>(model).ExecuteCommand(); if (row == 0) { db.Ado.RollbackTran(); return(row); } //新增新的角色 List <SysUserRoleRelation> list = new List <SysUserRoleRelation>(); foreach (string roleId in roleIds) { SysUserRoleRelation roleRelation = new SysUserRoleRelation { Id = Guid.NewGuid().ToString().Replace("-", ""), UserId = model.Id, RoleId = roleId, CreateUser = OperatorProvider.Instance.Current.Account, CreateTime = DateTime.Now }; list.Add(roleRelation); } row = db.Insertable <SysUserRoleRelation>(list).ExecuteCommand(); if (row == 0) { db.Ado.RollbackTran(); return(row); } //新增用户登陆信息。 SysUserLogOn userLogOnEntity = new SysUserLogOn(); userLogOnEntity.Id = Guid.NewGuid().ToString().Replace("-", ""); userLogOnEntity.UserId = model.Id; userLogOnEntity.SecretKey = userLogOnEntity.Id.DESEncrypt().Substring(0, 8); userLogOnEntity.Password = password.MD5Encrypt().DESEncrypt(userLogOnEntity.SecretKey).MD5Encrypt(); userLogOnEntity.LoginCount = 0; userLogOnEntity.IsOnLine = "0"; row = db.Insertable <SysUserLogOn>(userLogOnEntity).ExecuteCommand(); //初始化返点 SysRebateEntity rebateModel = new SysRebateEntity { ShopID = model.ShopID, UserID = model.Id, TipRebate = 0, HourRebate = 0, ModifiedBy = OperatorProvider.Instance.Current.Account, CreateTime = DateTime.Now, ModifiedTime = DateTime.Now }; row = db.Insertable <SysRebateEntity>(rebateModel).ExecuteCommand(); if (row == 0) { db.Ado.RollbackTran(); return(row); } db.Ado.CommitTran(); return(row); } catch (Exception ex) { db.Ado.RollbackTran(); new LogLogic().Write(Level.Error, "新增用户", ex.Message, ex.StackTrace); return(0); } } }
public ActionResult GetForm(int primaryKey) { SysRebateEntity entity = sysRebateLogic.Get(primaryKey); return(Content(entity.ToJson())); }