public void Modify(EMUser eMUser)
{
using (IRepository repository = SessionManager.CreateRepository(typeof(EMUser)))
{
repository.Update(eMUser);
}
}
public void Add(EMUser eMUser)
{
using (IRepository repository = SessionManager.CreateRepository(typeof(EMUser)))
{
repository.Save(eMUser);
}
}
private RUserInfo getReturnUserInfo(EMUser user)
{
RUserInfo info = new RUserInfo();
info.UserCode = user.UserCode;
info.UserName = user.UserName;
info.TenantCode = user.TenantCode;
//IEMTenantService service = new EMTenantService();
//EMTenant tenantInfo = service.Select(user.TenantCode);
if (user.Tenant != null)
{
info.TenantType = (int)user.Tenant.TenantType;
}
//TO DO 获取子运营商及子客户
return info;
}
/// <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 EMUser ConvertTo(EMUserViewModel entity)
{
EMUser model = null;
if (entity != null)
{
IUserService userService = new UserService();
EMUser eMUser = userService.GetUser(entity.UserCode);
model = new EMUser();
model.UserCode = entity.UserCode;
model.UserName = entity.UserName;
model.IsRegisterUser = entity.IsRegisterUser;
model.PassWord = entity.PassWord;
model.RealName = entity.RealName;
model.Mobile = entity.Mobile;
model.Tenant = new EMTenant() { TenantCode = entity.TenantCode };
model.LastLoginTime = entity.LastLoginTime;
if (eMUser != null)
model.CreateTime = eMUser.CreateTime;
model.UserGroupID = entity.UserGroupID;
}
return model;
}
private OperateMyDataViewModel ConvertTo(EMUser user)
{
if (user != null)
{
OperateMyDataViewModel model = new OperateMyDataViewModel();
model.UserCode = user.UserCode;
model.UserName = user.UserName;
model.Password = user.PassWord;
model.TenantCode = user.TenantCode;
//EMTenantService tenantService = new EMTenantService();
//EMTenant tenant = tenantService.Select(user.TenantCode);
if (user.Tenant != null)
{
model.TenantName = user.Tenant.TenantName;
model.PhoneNumber = user.Tenant.PhoneNumber;
model.ContactName = user.Tenant.ContactName;
if (user.Tenant.CreateTime.Equals(DateTime.MinValue))
model.CreateTime = DateTime.MaxValue;
else
model.CreateTime = user.Tenant.CreateTime;
if (user.Tenant.ExpireTime.Equals(DateTime.MinValue))
model.ExpireTime = DateTime.MaxValue;
else
model.ExpireTime = user.Tenant.ExpireTime;
model.Email = user.Tenant.Email;
model.QQ = user.Tenant.QQ;
model.TenantLogoImgURl = user.Tenant.LogoUrl;
}
return model;
}
return null;
}
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 UserInfoViewModel ConvertToViewModel(EMUser user)
{
UserInfoViewModel viewModel = new UserInfoViewModel();
viewModel.UserCode = user.UserCode;
viewModel.UserName = user.UserName;
viewModel.TenantCode = user.Tenant.TenantCode;//user.TenantCode;
viewModel.TenantName = user.Tenant.TenantName;
//viewModel.Password = user.PassWord;
viewModel.IsRegisterUser = user.IsRegisterUser;
return viewModel;
}
/// <summary>
/// 获取子用户列表
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="userGroupID">用户组</param>
/// <param name="tenantCode">租户编码</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">每页条数</param>
/// <param name="rowCount">总记录数</param>
/// <returns></returns>
public IList<EMUser> GetUserList(string userName, string userGroupID, string tenantCode, int pageIndex, int pageSize, ref int rowCount)
{
List<EMUser> uList = new List<EMUser>();
string sCmdText = string.Format(@"SELECT movo_user.CreateTime,movo_user.IsRegisterUser,movo_user.LastLoginTime,movo_user.Mobile,movo_user.PassWord,movo_user.RealName,movo_user.TenantCode,movo_user.UserCode,movo_user.UserGroupID,movo_user.UserName,movo_tenant.TenantCode tTenantCode,movo_tenant.SuperTenantID tSuperTenantID,movo_tenant.TenantName tTenantName,movo_tenant.CreateTime tCreateTime,movo_tenant.ExpireTime tExpireTime,
movo_tenant.ContactName tContactName,movo_tenant.PhoneNumber tPhoneNumber,movo_tenant.TenantType tTenantType,movo_tenant.IsFreeze tIsFreeze,movo_tenant.QQ tQQ,movo_tenant.Email tEmail,
movo_tenant.RegisterUserCode tRegisterUserCode,movo_tenant.RegisterUserName tRegisterUserName,movo_tenant.LogoUrl tLogoUrl,movo_tenant.OperatorLevel tOperatorLevel from movo_user left join movo_tenant on movo_tenant.TenantCode=movo_user.TenantCode where movo_tenant.TenantCode='{0}'", tenantCode);
string sql = string.Format(@"SELECT count(*) from movo_user left join movo_tenant on movo_tenant.TenantCode=movo_user.TenantCode where movo_tenant.TenantCode='{0}'", tenantCode);
if (!string.IsNullOrEmpty(userName))
{
sCmdText = sCmdText + string.Format(@" and movo_user.UserName like '%{0}%'", userName);
sql = sql + string.Format(@" and movo_user.UserName like '%{0}%'", userName);
}
if (!string.IsNullOrEmpty(userGroupID))
{
sCmdText = sCmdText + string.Format(@" and movo_user.UserGroupID={0}", long.Parse(userGroupID));
sql = sql + string.Format(@" and movo_user.UserGroupID={0}", long.Parse(userGroupID));
}
sCmdText = sCmdText + string.Format(@" order by movo_user.IsRegisterUser,movo_user.CreateTime desc limit {0},{1}", pageIndex, pageSize);
using (DbDataReader sdrCount = MySqlDB.GetDataReader(CommandType.Text, sql))
{
if (sdrCount != null)
{
while (sdrCount.Read())
{
rowCount = rowCount + Convert.ToInt32(sdrCount[0]);
}
}
sdrCount.Close();
}
using (DbDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, sCmdText))
{
if (sdr != null)
{
while (sdr.Read())
{
EMUser eu = new EMUser();
eu.CreateTime = sdr["CreateTime"].ToDateTime();
eu.IsRegisterUser = sdr["IsRegisterUser"].ToBoolean();
eu.LastLoginTime = sdr["LastLoginTime"].ToDateTimeNull();
eu.Mobile = sdr["Mobile"].ToString();
eu.PassWord = sdr["PassWord"].ToString();
eu.RealName = sdr["RealName"].ToString();
eu.TenantCode = sdr["TenantCode"].ToString();
eu.UserCode = sdr["UserCode"].ToString();
eu.UserGroupID = sdr["UserGroupID"].ToULongNull();
eu.UserName = sdr["UserName"].ToString();
EMTenant et = new EMTenant();
et.ContactName = sdr["tContactName"].ToString();
et.CreateTime = sdr["tCreateTime"].ToDateTime();
et.Email = sdr["tEmail"].ToString();
et.ExpireTime = sdr["tExpireTime"].ToDateTimeNull();
et.IsFreeze = sdr["tIsFreeze"].ToString() == "1" ? true : false;
et.LogoUrl = sdr["tLogoUrl"].ToString();
et.OperatorLevel = sdr["tOperatorLevel"].ToIntNull();
et.PhoneNumber = sdr["tPhoneNumber"].ToString();
et.QQ = sdr["tQQ"].ToString();
et.RegisterUserCode = sdr["tRegisterUserCode"].ToString();
et.RegisterUserName = sdr["tRegisterUserName"].ToString();
et.SuperTenantID = sdr["tSuperTenantID"].ToString();
et.TenantCode = sdr["tTenantCode"].ToString();
et.TenantName = sdr["tTenantName"].ToString();
et.TenantType = (EnumTenantType)sdr["tTenantType"].ToInt();
eu.Tenant = et;
uList.Add(eu);
}
}
sdr.Close();
}
return uList;
}
public EMUser GetLoginUser(string userName, string pwd)
{
string cmdText = "SELECT * FROM movo_user where UserName = @UserName and PassWord=@Pwd";
MySqlParameter[] cmdParams = new MySqlParameter[] {
new MySqlParameter("UserName", userName),
new MySqlParameter("Pwd", pwd)
};
EMUser res = null;
using (MySqlDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, cmdText, cmdParams))
{
if (sdr != null)
{
if (sdr.Read())
{
res = new EMUser();
res.UserCode = sdr["UserCode"].ToString();
res.UserName = userName;
res.UserGroupID = sdr["UserGroupID"].ToULongNull();
res.TenantCode = sdr["TenantCode"].ToString();
res.PassWord = pwd;
res.RealName = sdr["RealName"].ToString();
res.Mobile = sdr["Mobile"].ToString();
res.IsRegisterUser = sdr["IsRegisterUser"].ToBoolean();
res.LastLoginTime = sdr["LastLoginTime"].ToDateTimeNull();
res.CreateTime = sdr["CreateTime"].ToDateTime();
}
sdr.Close();
if (res != null)
{
res.Tenant = GetTenantInfoByTenantCode(res.TenantCode);
}
}
}
return res;
}
public EMUser GetUserFullInfo(string userCode)
{
EMUser res = new EMUser();
string scmdText = string.Format("SELECT * FROM movo_user u LEFT JOIN movo_tenant t ON u.TenantCode = t.TenantCode WHERE u.UserCode = '{0}'", userCode);
using (DbDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, scmdText))
{
if (sdr != null)
{
if (sdr.Read())
{
res.UserCode = userCode;
res.UserName = sdr["UserName"].ToString();
res.UserGroupID = sdr["UserGroupID"].ToULongNull();
res.TenantCode = sdr["TenantCode"].ToString();
res.PassWord = sdr["PassWord"].ToString();
res.RealName = sdr["RealName"].ToString();
res.Mobile = sdr["Mobile"].ToString();
res.IsRegisterUser = sdr["IsRegisterUser"].ToBoolean();
res.LastLoginTime = sdr["LastLoginTime"].ToDateTimeNull();
res.CreateTime = sdr["CreateTime"].ToDateTime();
res.Tenant = new EMTenant(); //租户信息
res.Tenant.TenantCode = sdr["TenantCode"].ToString();
res.Tenant.SuperTenantID = sdr["SuperTenantID"].ToString();
res.Tenant.TenantName = sdr["TenantName"].ToString();
res.Tenant.CreateTime = sdr["CreateTime"].ToDateTime();
res.Tenant.ExpireTime = sdr["ExpireTime"].ToDateTimeNull();
res.Tenant.ContactName = sdr["ContactName"].ToString();
res.Tenant.PhoneNumber = sdr["PhoneNumber"].ToString();
res.Tenant.TenantType = (EnumTenantType)sdr["TenantType"].ToInt();
res.Tenant.IsFreeze = sdr["IsFreeze"].ToString() == "1" ? true : false;
res.Tenant.QQ = sdr["QQ"].ToString();
res.Tenant.Email = sdr["Email"].ToString();
res.Tenant.RegisterUserCode = sdr["RegisterUserCode"].ToString();
res.Tenant.RegisterUserName = sdr["RegisterUserName"].ToString();
res.Tenant.LogoUrl = sdr["LogoUrl"].ToString();
res.Tenant.OperatorLevel = sdr["OperatorLevel"].ToIntNull();
}
}
}
return res;
}
/// <summary>
/// 新增子用户
/// </summary>
/// <param name="user">movo_user对应的实体</param>
/// <returns></returns>
public bool AddUser(EMUser user)
{
string sCmdText = string.Format(@"insert into movo_user(UserCode,UserName,UserGroupID,TenantCode,Password,RealName,Mobile,IsRegisterUser,LastLoginTime,CreateTime) values(@UserCode,@UserName,@UserGroupID,@TenantCode,@Password,@RealName,@Mobile,@IsRegisterUser,@LastLoginTime,@CreateTime)");
MySqlParameter[] parm = new MySqlParameter[] {
new MySqlParameter("UserCode", user.UserCode),
new MySqlParameter("UserName", user.UserName),
new MySqlParameter("UserGroupID", user.UserGroupID),
new MySqlParameter("TenantCode", user.TenantCode),
new MySqlParameter("Password", user.PassWord),
new MySqlParameter("RealName", user.RealName),
new MySqlParameter("Mobile", user.Mobile),
new MySqlParameter("IsRegisterUser", user.IsRegisterUser),
new MySqlParameter("LastLoginTime", user.LastLoginTime),
new MySqlParameter("CreateTime", user.CreateTime)
};
int iCount = MySqlDB.ExecuteNonQuery(CommandType.Text, sCmdText, parm);
//if (iCount > 0)
//{
// return true;
//}
return iCount > 0;
}
public void Update(EMUser aEMUser)
{
string cmdText = string.Format(@"UPDATE movo_user SET UserName=@UserName, UserGroupID=@UserGroupID, TenantCode=@TenantCode,
Password=@Password, RealName=@RealName, Mobile=@Mobile, IsRegisterUser=@IsRegisterUser, LastLoginTime=@LastLoginTime WHERE UserCode={0}", aEMUser.UserCode);
MySqlParameter[] sp = new MySqlParameter[] {
new MySqlParameter("UserName", aEMUser.UserName),
new MySqlParameter("UserGroupID", aEMUser.UserGroupID),
new MySqlParameter("TenantCode", aEMUser.TenantCode),
new MySqlParameter("Password", aEMUser.PassWord),
new MySqlParameter("RealName", aEMUser.RealName),
new MySqlParameter("Mobile", aEMUser.Mobile),
new MySqlParameter("IsRegisterUser", aEMUser.IsRegisterUser),
new MySqlParameter("LastLoginTime", aEMUser.LastLoginTime),
new MySqlParameter("CreateTime", aEMUser.CreateTime)
};
MySqlDB.ExecuteNonQuery(CommandType.Text, cmdText, sp);
/*
using (IRepository repository = SessionManager.CreateRepository(typeof(EMUser)))
{
repository.Update(eMUser);
}*/
}
public void UpdLastLoginTime(EMUser aEMUser)
{
string cmdText = string.Format(@"UPDATE movo_user SET LastLoginTime=@LastLoginTime WHERE UserCode={0}", aEMUser.UserCode);
MySqlParameter[] sp = new MySqlParameter[] {
new MySqlParameter("LastLoginTime", aEMUser.LastLoginTime)
};
MySqlDB.ExecuteNonQuery(CommandType.Text, cmdText, sp);
}
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;
}