public JsonResult AddViewRight(int ViewId, DateTime StartTime, DateTime EndTime, string UserCode)
{
Tnet_User daUser = new Tnet_User();
if (daUser.SelectUserCode(UserCode))
{
Tsql_View_Right daViewRight = new Tsql_View_Right()
{
ViewId = ViewId,
OwnerType = daUser.UserLevel,
OwnerId = daUser.UserId,
AuthTime = StartTime,
Timeout = EndTime
};
if (daViewRight.Verification(daUser.UserId, ViewId))
{
return(FailResult("该用户已绑定，请勿重复绑定"));
}
if (!daViewRight.Insert())
{
return(FailResult(daViewRight.PromptInfo.Message));
}
}
else
{
return(FailResult("该用户不存在"));
}
return(SuccessResult());
}
public bool Downgrade(int userId)
{
BeginTransaction();
Tnet_User dao = new Tnet_User();
dao.ReferenceTransactionFrom(Transaction);
if (!dao.SelectByPk(userId))
{
Rollback();
Alert("查询会员信息失败");
return(false);
}
int before = dao.User_Level;
if (((UserLevel)dao.User_Level & UserLevel.VIP会员) != UserLevel.VIP会员)
{
Alert("该会员已不是VIP");
return(true);
}
dao.User_Id = userId;
dao.User_Level = (dao.User_Level ^ (int)UserLevel.VIP会员);
if (!dao.Update())
{
Rollback();
Alert("更新会员级别失败");
return(false);
}
Tnet_Role_Expires daExpires = new Tnet_Role_Expires();
daExpires.ReferenceTransactionFrom(Transaction);
daExpires.User_Id = userId;
daExpires.User_Level = (int)UserLevel.VIP会员;
daExpires.Before_Level = before;
daExpires.After_Level = (before ^ (int)UserLevel.VIP会员);
daExpires.Remarks = "VIP到期系统自动降级";
if (!daExpires.Insert())
{
Rollback();
Alert("写入降级历史失败");
return(false);
}
Commit();
return(true);
}
/// <summary>
/// 新增会员
/// </summary>
/// <returns></returns>
public bool AddUser(string userName = null, string avatar = null)
{
var funcres = GetIntroducerId(this._refereeCode);
if (!funcres.Success)
{
Alert(funcres.Message);
return(false);
}
int? refereeId = funcres.Content;
int userId = this._userId.HasValue ? this._userId.Value : GetNewUserId();
string loginPwd = EncodePwd(_password, userId, _userCode);
string paypwd = null;
BeginTransaction();
Tnet_User daReg = new Tnet_User
{
User_Code = _userCode,
Login_Password = loginPwd,
Payment_Password = paypwd,
User_Name = userName ?? _userCode,
User_Status = (int)UserStatus.已激活,
User_Level = 0,
Father_Id = refereeId,
Auth_Status = 0,
Data_Source = 1,
Mobile_No = _userCode,
Photo_Url = avatar,
User_Nickname = userName
};
daReg.ReferenceTransactionFrom(Transaction);
if (!daReg.Insert(userId))
{
Rollback();
Alert("注册新会员失败");
return(false);
}
Commit();
return(true);
}
public JsonResult CheckInviter(string refereeCode)
{
if (string.IsNullOrEmpty(refereeCode))
{
return(FailResult("请输入邀请人账号"));
}
Tnet_User daUser = new Tnet_User();
if (!daUser.SelectByUserCode(refereeCode))
{
return(FailResult("输入的邀请人账号未注册"));
}
if (daUser.User_Status != (int)UserStatus.已激活)
{
return(FailResult("邀请人账号状态异常"));
}
var data = new
{
User_Code = daUser.User_Code,
User_Name = daUser.User_Name
};
return(SuccessResult(data));
}
private bool UpgradeUserRole(SubOrder subOrder, UserLevel level)
{
DateTime start = DateTime.Now;
BeginTransaction();
Tnet_User_Role daVip = new Tnet_User_Role();
daVip.ReferenceTransactionFrom(Transaction);
if (!daVip.SelectByUserId_UserLevel(subOrder.User_Id, (int)level))
{
daVip.User_Id = subOrder.User_Id;
daVip.Expire_Time = start.AddYears(1);
daVip.Last_Modify_Time = DateTime.Now;
daVip.User_Level = (int)level;
daVip.Role_Name = UserLevel.VIP会员.ToString();
if (!daVip.Insert())
{
Rollback();
return(false);
}
}
else
{
if (daVip.Expire_Time > start)
{
start = daVip.Expire_Time;
}
daVip.Expire_Time = start.AddYears(1);
daVip.Last_Modify_Time = DateTime.Now;
if (!daVip.Update())
{
Rollback();
return(false);
}
}
if (!string.IsNullOrEmpty(this.Order.Biz_Args))
{
JsonObject arg = JsonObject.Parse(this.Order.Biz_Args);
string org_code = arg.GetString("Org_Code");
if (!string.IsNullOrEmpty(org_code))
{
Tnet_Organization daOrg = new Tnet_Organization();
if (!daOrg.SelectByOrgCode(org_code))
{
Rollback();
Alert("归属俱乐部未找到");
return(false);
}
Tnet_User_Profile daProfile = new Tnet_User_Profile();
daProfile.ReferenceTransactionFrom(Transaction);
daProfile.User_Id = daVip.User_Id;
daProfile.Org_Id = daOrg.Org_Id;
daProfile.Last_Modify_Time = DateTime.Now;
if (!daProfile.Update())
{
Rollback();
Alert("修改归属信息失败");
return(false);
}
}
}
Tnet_User daUser = new Tnet_User();
daUser.ReferenceTransactionFrom(Transaction);
if (!daUser.UpdateUserLevel(subOrder.User_Id, level))
{
Rollback();
Alert("更新会员角色失败");
return(false);
}
Commit();
return(true);
}
private static int GetNewUserId()
{
Tnet_User daUser = new Tnet_User();
return(daUser.GetNewUserId());
}
private int GetNewUserId()
{
Tnet_User daReg = new Tnet_User();
return(daReg.GetNewUserId());
}
