public void Add(EMUserGroup entity) { using (IRepository session = SessionManager.CreateRepository(typeof(EMUserGroup))) { session.Save(entity); } }
/// <summary> /// 新增运营商(ado,采用事物) /// </summary> /// <param name="tenant">movo_tenant对应实体</param> /// <param name="userGroup">movo_usergroup对应实体</param> /// <param name="user">movo_user对应实体</param> public bool AddOperatingMerchant(EMTenant tenant, EMUserGroup userGroup, EMUser user) { EMTenant sameNameEntity = SelectByName(tenant.TenantName); if (sameNameEntity != null) { throw new Exception("已经有相同的名称的Tenant"); } MySqlConnection con = new MySqlConnection(MySqlDB.ConnString); con.Open(); MySqlTransaction trans = con.BeginTransaction(); MySqlCommand cmd = con.CreateCommand(); cmd.Transaction = trans; try { cmd.CommandText = string.Format(@"insert into movo_tenant(TenantCode,SuperTenantID,TenantName,CreateTime,ExpireTime,ContactName,PhoneNumber,TenantType,IsFreeze,QQ,Email,RegisterUserCode,RegisterUserName,LogoUrl,OperatorLevel) values(@TenantCode,@SuperTenantID,@TenantName,@CreateTime,@ExpireTime,@ContactName,@PhoneNumber,@TenantType,@IsFreeze,@QQ,@Email,@RegisterUserCode,@RegisterUserName,@LogoUrl,@OperatorLevel)"); cmd.Parameters.AddRange(new MySqlParameter[]{ new MySqlParameter("TenantCode",tenant.TenantCode), new MySqlParameter("SuperTenantID",tenant.SuperTenantID), new MySqlParameter("TenantName",tenant.TenantName), new MySqlParameter("CreateTime",tenant.CreateTime), new MySqlParameter("ExpireTime",tenant.ExpireTime), new MySqlParameter("ContactName",tenant.ContactName), new MySqlParameter("PhoneNumber",tenant.PhoneNumber), new MySqlParameter("TenantType",tenant.TenantType), new MySqlParameter("IsFreeze",tenant.IsFreeze), new MySqlParameter("QQ",tenant.QQ), new MySqlParameter("Email",tenant.Email), new MySqlParameter("RegisterUserCode",tenant.RegisterUserCode), new MySqlParameter("RegisterUserName",tenant.RegisterUserName), new MySqlParameter("LogoUrl",tenant.LogoUrl), new MySqlParameter("OperatorLevel",tenant.OperatorLevel) }); int addtenant = cmd.ExecuteNonQuery(); cmd.CommandText = string.Format(@"insert into movo_usergroup(UserGroupID,UserGroupName,TenantCode,IsAdminGroup) values(@gUserGroupID,@gUserGroupName,@gTenantCode,@gIsAdminGroup)"); cmd.Parameters.AddRange(new MySqlParameter[]{ new MySqlParameter("gUserGroupID",userGroup.UserGroupID), new MySqlParameter("gUserGroupName",userGroup.UserGroupName), new MySqlParameter("gTenantCode",userGroup.TenantCode), new MySqlParameter("gIsAdminGroup",userGroup.IsAdminGroup) }); int addusergroup = cmd.ExecuteNonQuery(); cmd.CommandText = string.Format(@"insert into movo_user(UserCode,UserName,UserGroupID,TenantCode,Password,RealName,Mobile,IsRegisterUser,LastLoginTime,CreateTime) values(@uUserCode,@uUserName,@uUserGroupID,@uTenantCode,@uPassword,@uRealName,@uMobile,@uIsRegisterUser,@uLastLoginTime,@uCreateTime)"); cmd.Parameters.AddRange(new MySqlParameter[]{ new MySqlParameter("uUserCode",user.UserCode), new MySqlParameter("uUserName",user.UserName), new MySqlParameter("uUserGroupID",user.UserGroupID), new MySqlParameter("uTenantCode",user.TenantCode), new MySqlParameter("uPassword",user.PassWord), new MySqlParameter("uRealName",user.RealName), new MySqlParameter("uMobile",user.Mobile), new MySqlParameter("uIsRegisterUser",user.IsRegisterUser), new MySqlParameter("uLastLoginTime",user.LastLoginTime), new MySqlParameter("uCreateTime",user.CreateTime) }); int adduser = cmd.ExecuteNonQuery(); if (addtenant >= 1 && addusergroup >= 1 && adduser >= 1) { trans.Commit(); } } catch (Exception ex) { trans.Rollback(); //加日志 return false; } finally { con.Close(); } return true; }
private EMUserGroup GetEMUserGroup(IdentityNoService identityNoServ, string tenantCode, UserInfoViewModel userInfoViewModel) { EMUserGroup group; group = new EMUserGroup() { IsAdminGroup = true, UserGroupID = identityNoServ.GetUserGroupID(), UserGroupName = "管理员", TenantCode = tenantCode, }; return group; }
private EMUser GetEMUser(IdentityNoService identityNoServ, UserInfoViewModel vm, EMTenant tenant, EMUserGroup group) { EMUser user; user = new EMUser() { UserCode = identityNoServ.GetUserSerialNo(), UserName = vm.UserName, UserGroupID = group.UserGroupID, Tenant = tenant, PassWord = vm.EncryptPwd, IsRegisterUser = true, Mobile = tenant.PhoneNumber, CreateTime = DateTime.Now }; return user; }
private static EMUserGroup GetEMUserGroup(IdentityNoService identityNoServ, string tenantCode) { EMUserGroup group; group = new EMUserGroup() { IsAdminGroup = true, UserGroupID = identityNoServ.GetUserGroupID(), UserGroupName = "管理员", TenantCode = tenantCode }; return group; }
private EMUser GetEMUser(IdentityNoService identityNoServ,string userName, string pwd, string email, string QQ, EMTenant tenant, EMUserGroup group) { EMUser user; user = new EMUser() { UserCode = identityNoServ.GetUserSerialNo(), UserName = userName, UserGroupID = group.UserGroupID, Tenant= tenant, PassWord = pwd, IsRegisterUser = true, CreateTime = DateTime.Now }; return user; }