public int Delete(PwdModels entity)
{
return(DBCore.Deleteable(entity).With(SqlWith.RowLock).ExecuteCommand());
}
/// <summary>
/// 添加/修改
/// </summary>
/// <param name="entity"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool AddAndUpUsers(UsersModels entity, out string message)
{
message = "系统错误";
entity.UTime = DateTime.Now;
entity.IsAdministrator = false;
entity.States = 1;
entity.Types = 1;
if (string.IsNullOrWhiteSpace(entity.UserName))
{
message = "用户名错误";
return(false);
}
if (string.IsNullOrWhiteSpace(entity.UserPwd))
{
message = "密码错误";
return(false);
}
var pwdEntity = new PwdModels
{
UTime = DateTime.Now,
PassWords = MD5Core.GetStringMD5(entity.UserPwd)
};
if (string.IsNullOrWhiteSpace(entity.OpenId))
{
entity.CTime = DateTime.Now;
entity.IsDeleted = false;
entity.OpenId = Guid.NewGuid().ToString();
entity.Remark = "后台用户数据";
pwdEntity.CTime = entity.CTime;
pwdEntity.JoinOpenId = entity.OpenId;
pwdEntity.IsDeleted = false;
pwdEntity.OpenId = Guid.NewGuid().ToString();
pwdEntity.Remark = "用户密码";
pwdEntity.PwdType = (int)EnumCore.PwdType.后台登录;
if (IocRepository.IocUsersRepository.InsertBool(entity) && IocRepository.IocPwdRepository.InsertBool(pwdEntity))
{
message = "添加成功";
return(true);
}
return(false);
}
var upEntity = GetUsersModel(entity.OpenId) ?? new UsersModels();
if (string.IsNullOrWhiteSpace(upEntity.OpenId))
{
return(false);
}
var upPwdEntity = GetPwdByUserOpenId(upEntity.OpenId);
if (string.IsNullOrWhiteSpace(upPwdEntity.OpenId))
{
return(false);
}
upPwdEntity.PassWords = pwdEntity.PassWords;
upPwdEntity.UTime = entity.UTime;
upEntity.UserName = entity.UserName;
upEntity.UTime = entity.UTime;
if (IocRepository.IocUsersRepository.Update(upEntity) > 0 && IocRepository.IocPwdRepository.Update(upPwdEntity) > 0)
{
message = "修改成功";
return(true);
}
return(false);
}
public int Update(PwdModels entity)
{
return(DBCore.Updateable(entity).With(SqlWith.UpdLock).Where(true).ExecuteCommand());
}
public bool InsertBool(PwdModels entity)
{
return(DBCore.Insertable(entity).With(SqlWith.UpdLock).ExecuteCommandIdentityIntoEntity());
}
public PwdModels InsertEntity(PwdModels entity)
{
return(DBCore.Insertable(entity).With(SqlWith.UpdLock).ExecuteReturnEntity());
}
public long InsertLong(PwdModels entity)
{
return(DBCore.Insertable(entity).With(SqlWith.UpdLock).ExecuteReturnBigIdentity());
}
public int InsertInt(PwdModels entity)
{
return(DBCore.Insertable(entity).With(SqlWith.UpdLock).ExecuteCommand());
}
