private void _f_UserAdded(object sender, PostUserAddArgs e)
{
UserBaseInfo _cUser = e.User;
bool _find = false;
SinoSZClientBase.UserManagerService.UserManagerServiceClient _umsc = new SinoSZClientBase.UserManagerService.UserManagerServiceClient();
foreach (UserBaseInfo _user in this.CurrentPostUserList)
{
if (_user.UserID == _cUser.UserID)
{
_find = true;
}
}
if (!_find)
{
if (_umsc.AddUserPost(_cUser.UserID, CurrentPost.PostID))
{
this.gridView1.BeginUpdate();
this.CurrentPostUserList.Add(_cUser);
this.sinoCommonGrid1.DataSource = this.CurrentPostUserList;
this.gridView1.EndUpdate();
XtraMessageBox.Show(string.Format("用户{0}添加成功！", _cUser.UserName), "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
/// <summary>
/// 通过用户ID查找用户详细信息
/// </summary>
/// <param name="userId">用户ID</param>
/// <returns>返回用户详细信息</returns>
public UserBaseInfo GetUserBaseInfoByUserID(long userId)
{
//UserID OnlineStatusID UserLevel OnlineTime LastloginTime RegTime
var sql = $"SELECT UserID,NickName,Gender,BornDate,Province,City,Address,Phone FROM [UserBaseInfo] WHERE UserID={userId}";
var dr = DBHelper.SelectForReader(sql);
UserBaseInfo userBaseInfo = null;
if (dr.Read())
{
userBaseInfo = new UserBaseInfo()
{
UserID = userId,
NickName = dr.GetString(1),
Gender = dr.GetString(2),
BornDate = dr.GetDateTime(3),
Province = dr.GetString(4),
City = dr.GetString(5),
Address = dr.GetString(6),
Phone = dr.GetString(7),
User = _userService.GetUserByUserID(userId)
};
}
dr.Close();
return(userBaseInfo);
}
/// <summary>
/// 技师编辑微信绑定
/// </summary>
/// <param name="wxkey"></param>
/// <returns></returns>
public ActionResult WXBind(string wxkey)
{
LoginQrCode lcode = RedisUtil.Get <LoginQrCode>("SessionID:" + wxkey);
if (string.IsNullOrEmpty(wxkey))
{
return(Json(new { isok = false }));
}
if (lcode == null)
{
return(Json(new { isok = false }));
}
if (!lcode.IsLogin)
{
return(Json(new { isok = false }));
}
if (lcode.WxUser != null)
{
Account accountmodel = null;
if (!string.IsNullOrEmpty(lcode.WxUser.openid))
{
UserBaseInfo userInfo = UserBaseInfoBLL.SingleModel.GetModelByOpenId(lcode.WxUser.openid, lcode.WxUser.serverid);
if (userInfo == null)
{
userInfo = new UserBaseInfo();
userInfo.openid = lcode.WxUser.openid;
userInfo.nickname = lcode.WxUser.nickname;
userInfo.headimgurl = lcode.WxUser.headimgurl;
userInfo.sex = lcode.WxUser.sex;
userInfo.country = lcode.WxUser.country;
userInfo.city = lcode.WxUser.city;
userInfo.province = lcode.WxUser.province;
userInfo.unionid = lcode.WxUser.unionid;
UserBaseInfoBLL.SingleModel.Add(userInfo);
}
accountmodel = AccountBLL.SingleModel.GetAccountByWeixinUser(lcode.WxUser);
if (accountmodel == null)
{
return(Json(new { isok = false }));
}
Member member = MemberBLL.SingleModel.GetMemberByAccountId(accountmodel.Id.ToString());
member.LastModified = DateTime.Now;//记录登录时间
MemberBLL.SingleModel.Update(member);
RedisUtil.Remove("SessionID:" + wxkey);
//重置二维码
string sessonid = new Random().Next(1, 3) + DateTime.Now.ToString("mmssfffff");
if (null == RedisUtil.Get <LoginQrCode>("SessionID:" + sessonid))
{
LoginQrCode newWxkey = new LoginQrCode();
newWxkey.SessionId = sessonid;
newWxkey.IsLogin = false;
RedisUtil.Set <LoginQrCode>("SessionID:" + sessonid, newWxkey);
}
return(Json(new { isok = true, unionId = userInfo.unionid, key = sessonid }));
}
}
return(Json(new { isok = false }));
}
public async Task QueryUserInfo()
{
CommonProvider common = new CommonProvider();
UserBaseInfo user = await common.QueryUserInfo("2e128e04325c");
Assert.IsNotNull(user);
}
protected void PageBegin(HttpContext CurrentContext)
{
if (!CurrentUser.IsOnline())
{
#region 如果是开发测试模式,自动登录
if (ConfigHelper.GetConfigBool("IsDebug"))
{
string loginid = ConfigHelper.GetConfigString("DefaultLoginID");
string pass = ConfigHelper.GetConfigString("Pass");
LoginResult result;
UserBaseInfo uinfo = WEB.Module.LoginManage.LoginHelper.CheckLogin(loginid.Trim(), pass, out result);
if (result.Success)
{
IUser user = CurrentUser;
user.BaseInfo = uinfo;
}
}
#endregion
}
if (!CurrentUser.IsOnline())
{
//System.Web.HttpContext.Current.Response.Redirect("~/Manage/Layout/login.aspx?action=relogin");
ReturnMsg(CurrentContext, false, enumReturnTitle.Login, "会话失败，请重新登录。");
CurrentContext.Response.End();
}
else
{
}
}
public UserBackFullInfo()
{
BaseInfo = new UserBaseInfo();
UserOrgInfoList = new List <View_UserOrgInfo>();
UserDataInfoList = new Hashtable();
UserFeatureInfoList = new List <View_FeaturePosition>();
UserMenuInfoList = new List <View_MenuSys>();
}
private void ShowUserPostList()
{
if (this.userList1.IsUserSelected)
{
UserBaseInfo _user = this.userList1.FocusedUser;
this.userPostList1.UserInfo = _user;
}
}
public IList <UserBaseInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"select count(*) from UserBase ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.HnztcSystemDbConnString, CommandType.Text, sb.ToString(), cmdParms);
if (totalRecords == 0)
{
return(new List <UserBaseInfo>());
}
sb.Clear();
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
UserId,Nickname,HeadPicture,Sex,MobilePhone,TotalGold,TotalSilver,TotalIntegral,SilverLevel,ColorLevel,IntegralLevel,VIPLevel
from UserBase " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <UserBaseInfo> list = new List <UserBaseInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcSystemDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
UserBaseInfo model = new UserBaseInfo();
model.UserId = reader.GetGuid(1);
model.Nickname = reader.GetString(2);
model.HeadPicture = reader.GetString(3);
model.Sex = reader.GetString(4);
model.MobilePhone = reader.GetString(5);
model.TotalGold = reader.GetInt32(6);
model.TotalSilver = reader.GetInt32(7);
model.TotalIntegral = reader.GetInt32(8);
model.SilverLevel = reader.GetInt32(9);
model.ColorLevel = reader.GetInt32(10);
model.IntegralLevel = reader.GetInt32(11);
model.VIPLevel = reader.GetString(12);
list.Add(model);
}
}
}
return(list);
}
public async Task QueryBaseInfoTest()
{
UserContentProvider mine = new UserContentProvider();
LoginResult result = await mine.Login(Config.username, Config.password);
UserBaseInfo mr = await mine.QueryBaseInfo(result.Id.ToString(), result.MobileToken);
Assert.IsNotNull(mr);
}
/// <summary>
/// 添加新用户到基础表
/// </summary>
/// <param name="xml"></param>
public void RegisterOAuthUser(RequestXML xml)
{
try
{
if (xml == null)
{
return;
}
if (string.IsNullOrEmpty(xml.FromUserName))
{
return;
}
//log4net.LogHelper.WriteInfo(this.GetType(), $"扫码事件推送：{JsonConvert.SerializeObject(xml)}");
UserBaseInfo umodel = UserBaseInfoBLL.SingleModel.GetModelByOpenId(xml.FromUserName, xml.ToUserName);
if (umodel == null)
{
WeiXinUser wx = WxHelper.GetWxUserInfo(WxHelper.GetToken(), xml.FromUserName);
if (wx != null && !string.IsNullOrEmpty(wx.openid))
{
umodel = new UserBaseInfo();
umodel.headimgurl = wx.headimgurl;
umodel.nickname = wx.nickname;
umodel.openid = wx.openid;
umodel.unionid = wx.unionid;
umodel.country = wx.country;
umodel.sex = wx.sex;
umodel.city = wx.city;
umodel.province = wx.province;
umodel.serverid = xml.ToUserName;
UserBaseInfoBLL.SingleModel.Add(umodel);
}
}
else
{
WeiXinUser wx = WxHelper.GetWxUserInfo(WxHelper.GetToken(), xml.FromUserName);
if (wx != null && !string.IsNullOrEmpty(wx.openid) && umodel.headimgurl != wx.headimgurl)
{
umodel.headimgurl = wx.headimgurl;
UserBaseInfoBLL.SingleModel.Update(umodel, "headimgurl");
}
}
}
catch (Exception ex)
{
log4net.LogHelper.WriteInfo(this.GetType(), $"报错扫码事件推送：{JsonConvert.SerializeObject(ex)}");
log4net.LogHelper.WriteError(this.GetType(), ex);
}
}
/// <summary>
/// 登陆统一处理
/// </summary>
/// <param name="model"></param>
/// <param name="uInfo"></param>
/// <returns></returns>
private static bool login(ref LoginModel model, out UserBaseInfo uInfo)
{
if (LoginModel.Login(ref model, out uInfo))
{
CurrentUser.LoginTryTimes = 0;
CurrentUser.UserName = uInfo.Account;
CurrentUser.UserId = uInfo.UserId;
CurrentUser.NewUserId = uInfo.NewUserID;
CurrentUser.UserLevel = uInfo.Mlevel;
CurrentUser <UserBaseInfo> .BaseInfo = uInfo;
return(true);
}
CurrentUser.LoginTryTimes++;
return(false);
}
protected void OKIBtn_Click(object sender, ImageClickEventArgs e)
{
LoginResult result;
UserBaseInfo uinfo = LoginHelper.CheckLogin(UserIDTB.Text.Trim(), PassTB.Text, out result);
if (result.Success)
{
IUser user = CurrentUser;
user.BaseInfo = uinfo;
Response.Redirect(ConfigHelper.BackgroundFirstPage);
}
else
{
JsHelper.wShowMessage("登录失败！", this);
}
}
private void ExecuteLogoutCommand()
{
baseInfo = null;
if (GlobalValue.CurrentUserContext != null)
{
GlobalValue.CurrentUserContext.IsLogin = false;
GlobalValue.CurrentUserContext.Avatar = "ms-appx:///Assets/default_avatar.png";
}
this.MessengerInstance.Send <ChangeView>(new ChangeView()
{
FromView = ViewType.UserCenter,
ToView = ViewType.Login,
Event = EventType.Logout,
Context = GlobalValue.CurrentUserContext
});
}
public void DeleteCurretUser()
{
UserBaseInfo _cUser = this.FocusedUser;
if (_cUser == null)
{
return;
}
SinoSZClientBase.UserManagerService.UserManagerServiceClient _umsc = new SinoSZClientBase.UserManagerService.UserManagerServiceClient();
if (_umsc.DeleteUserOfPost(CurrentPost.PostID, _cUser.UserID))
{
this.gridView1.BeginUpdate();
this.CurrentPostUserList.Remove(_cUser);
this.sinoCommonGrid1.DataSource = this.CurrentPostUserList;
this.gridView1.EndUpdate();
}
else
{
}
}
public IList <UserBaseInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"select UserId,Nickname,HeadPicture,Sex,MobilePhone,TotalGold,TotalSilver,TotalIntegral,SilverLevel,ColorLevel,IntegralLevel,VIPLevel
from UserBase ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
IList <UserBaseInfo> list = new List <UserBaseInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcSystemDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
UserBaseInfo model = new UserBaseInfo();
model.UserId = reader.GetGuid(0);
model.Nickname = reader.GetString(1);
model.HeadPicture = reader.GetString(2);
model.Sex = reader.GetString(3);
model.MobilePhone = reader.GetString(4);
model.TotalGold = reader.GetInt32(5);
model.TotalSilver = reader.GetInt32(6);
model.TotalIntegral = reader.GetInt32(7);
model.SilverLevel = reader.GetInt32(8);
model.ColorLevel = reader.GetInt32(9);
model.IntegralLevel = reader.GetInt32(10);
model.VIPLevel = reader.GetString(11);
list.Add(model);
}
}
}
return(list);
}
public int Insert(UserBaseInfo model)
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"insert into UserBase (UserId,Nickname,HeadPicture,Sex,MobilePhone,TotalGold,TotalSilver,TotalIntegral,SilverLevel,ColorLevel,IntegralLevel,VIPLevel)
values
(@UserId,@Nickname,@HeadPicture,@Sex,@MobilePhone,@TotalGold,@TotalSilver,@TotalIntegral,@SilverLevel,@ColorLevel,@IntegralLevel,@VIPLevel)
" );
SqlParameter[] parms =
{
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Nickname", SqlDbType.NVarChar, 30),
new SqlParameter("@HeadPicture", SqlDbType.VarChar, 100),
new SqlParameter("@Sex", SqlDbType.NChar, 2),
new SqlParameter("@MobilePhone", SqlDbType.VarChar, 20),
new SqlParameter("@TotalGold", SqlDbType.Int),
new SqlParameter("@TotalSilver", SqlDbType.Int),
new SqlParameter("@TotalIntegral", SqlDbType.Int),
new SqlParameter("@SilverLevel", SqlDbType.Int),
new SqlParameter("@ColorLevel", SqlDbType.Int),
new SqlParameter("@IntegralLevel", SqlDbType.Int),
new SqlParameter("@VIPLevel", SqlDbType.NVarChar, 10)
};
parms[0].Value = model.UserId;
parms[1].Value = model.Nickname;
parms[2].Value = model.HeadPicture;
parms[3].Value = model.Sex;
parms[4].Value = model.MobilePhone;
parms[5].Value = model.TotalGold;
parms[6].Value = model.TotalSilver;
parms[7].Value = model.TotalIntegral;
parms[8].Value = model.SilverLevel;
parms[9].Value = model.ColorLevel;
parms[10].Value = model.IntegralLevel;
parms[11].Value = model.VIPLevel;
return(SqlHelper.ExecuteNonQuery(SqlHelper.HnztcSystemDbConnString, CommandType.Text, sb.ToString(), parms));
}
public UserBaseInfo GetModel(object UserId)
{
UserBaseInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 UserId,Nickname,HeadPicture,Sex,MobilePhone,TotalGold,TotalSilver,TotalIntegral,SilverLevel,ColorLevel,IntegralLevel,VIPLevel
from UserBase
where UserId = @UserId " );
SqlParameter parm = new SqlParameter("@UserId", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(UserId.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcSystemDbConnString, CommandType.Text, sb.ToString(), parm))
{
if (reader != null)
{
if (reader.Read())
{
model = new UserBaseInfo();
model.UserId = reader.GetGuid(0);
model.Nickname = reader.GetString(1);
model.HeadPicture = reader.GetString(2);
model.Sex = reader.GetString(3);
model.MobilePhone = reader.GetString(4);
model.TotalGold = reader.GetInt32(5);
model.TotalSilver = reader.GetInt32(6);
model.TotalIntegral = reader.GetInt32(7);
model.SilverLevel = reader.GetInt32(8);
model.ColorLevel = reader.GetInt32(9);
model.IntegralLevel = reader.GetInt32(10);
model.VIPLevel = reader.GetString(11);
}
}
}
return(model);
}
private async Task QueryBaseInfo()
{
if (IsSelf)
{
UserContentProvider user = new UserContentProvider();
baseInfo = await user.QueryBaseInfo(GlobalValue.CurrentUserContext.UserId, GlobalValue.CurrentUserContext.MobileToken);
}
else
{
CommonProvider common = new CommonProvider();
baseInfo = await common.QueryUserInfo(currentUserId);
}
Avatar = new Uri(baseInfo.Avatar);
FollowerCount = baseInfo.FollowersCount;
FollowingCount = baseInfo.FollowingCount;
LikedNotesCount = baseInfo.LikedNotesCount;
BookmarksCount = baseInfo.BookmarksCount;
SubscribingCount = baseInfo.SubscribingCollectionsCount + baseInfo.SubscribingNotebooksCount;
TotalWordage = baseInfo.TotalWordage;
TotalLikesReceived = baseInfo.TotalLikesReceived;
NotebooksCount = baseInfo.NotebooksCount;
currentUserId = baseInfo.Id.ToString();
}
public ActionResult Bind(LoginModel model, string returnUrl, string unionId = "")
{
ViewBag.Type = model.Type;
ViewBag.ReturnUrl = Uri.EscapeDataString(returnUrl.ToStringOrDefault());
ViewBag.smsTime = 120;
//普通登录
try
{
UserBaseInfo uInfo = new UserBaseInfo();
if (login(ref model, out uInfo))
{
//登录成功
AddAccountTokenToCookie(model.Token);
returnUrl = com.totyu.LYWorld.Common.GlobalFunc.Decrypt(returnUrl, "UrlHelper");
if (returnUrl.Contains("Register") || returnUrl.Contains("Login"))
{
Response.Redirect("/Home/Index");
}
else
{
return(RedirectToLocal(returnUrl));
}
}
}
catch (Exception)
{
ModelState.AddModelError("LoginOtherError", MessageHelper.Get("LoginOtherError"));
}
ModelState.Clear();
model.ValidatorCode = "";
ModelState.FillError(model.ErrList);
return(View(model));
}
public IList <UserBaseInfo> GetList()
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"select UserId,Nickname,HeadPicture,Sex,MobilePhone,TotalGold,TotalSilver,TotalIntegral,SilverLevel,ColorLevel,IntegralLevel,VIPLevel
from UserBase
order by LastUpdatedDate desc " );
IList <UserBaseInfo> list = new List <UserBaseInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.HnztcSystemDbConnString, CommandType.Text, sb.ToString()))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
UserBaseInfo model = new UserBaseInfo();
model.UserId = reader.GetGuid(0);
model.Nickname = reader.GetString(1);
model.HeadPicture = reader.GetString(2);
model.Sex = reader.GetString(3);
model.MobilePhone = reader.GetString(4);
model.TotalGold = reader.GetInt32(5);
model.TotalSilver = reader.GetInt32(6);
model.TotalIntegral = reader.GetInt32(7);
model.SilverLevel = reader.GetInt32(8);
model.ColorLevel = reader.GetInt32(9);
model.IntegralLevel = reader.GetInt32(10);
model.VIPLevel = reader.GetString(11);
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(UserBaseInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(UserBaseInfo model)
{
return(dal.Insert(model));
}
public int userAdd(UserBaseInfo user)
{
return(0);
}
public bool userBaseInfoUpdate(UserBaseInfo user)
{
return(false);
}
public ActionResult StoreManagerBindWx(string wxkey = "")
{
LoginQrCode lcode = RedisUtil.Get <LoginQrCode>("SessionID:" + wxkey);
if (string.IsNullOrEmpty(wxkey))
{
return(Json(new { success = false, msg = "没有wxkey！" }, JsonRequestBehavior.AllowGet));
}
if (lcode == null)
{
return(Json(new { success = false, msg = "lcode为NULL！" }, JsonRequestBehavior.AllowGet));
}
if (!lcode.IsLogin)
{
return(Json(new { success = false, msg = "未登录！" }, JsonRequestBehavior.AllowGet));
}
if (lcode.WxUser != null)
{
//已扫描
Account accountmodel = null;
if (!string.IsNullOrEmpty(lcode.WxUser.openid))
{
log4net.LogHelper.WriteInfo(this.GetType(), $"MiniappUserBaseInfo ");
UserBaseInfo userInfo = UserBaseInfoBLL.SingleModel.GetModelByOpenId(lcode.WxUser.openid, lcode.WxUser.serverid);
if (userInfo == null)
{
userInfo = new UserBaseInfo();
userInfo.openid = lcode.WxUser.openid;
userInfo.nickname = lcode.WxUser.nickname;
userInfo.headimgurl = lcode.WxUser.headimgurl;
userInfo.sex = lcode.WxUser.sex;
userInfo.country = lcode.WxUser.country;
userInfo.city = lcode.WxUser.city;
userInfo.province = lcode.WxUser.province;
userInfo.unionid = lcode.WxUser.unionid;
UserBaseInfoBLL.SingleModel.Add(userInfo);
}
accountmodel = AccountBLL.SingleModel.GetAccountByWeixinUser(lcode.WxUser);
if (accountmodel == null)
{
return(Json(new { success = true, msg = "找不到绑定账号！" }, JsonRequestBehavior.AllowGet));
}
Member member = MemberBLL.SingleModel.GetModel(string.Format("AccountId ='{0}'", accountmodel.Id.ToString()));
member.LastModified = DateTime.Now;//记录登录时间
MemberBLL.SingleModel.Update(member);
RedisUtil.Remove("SessionID:" + wxkey);
Int32 appId = Convert.ToInt32(Session["appId"] ?? "0");
Int32 storeId = Convert.ToInt32(Session["storeId"] ?? "0");
bool havingRole = UserRoleBLL.SingleModel.HavingRole(RoleType.分店管理员, appId, storeId);
if (havingRole)
{
return(Json(new { success = true, msg = "该店铺已经有管理者,请解绑后再重新绑定！", isBind = true }, JsonRequestBehavior.AllowGet));
}
//添加当前扫码用户于当前店铺的管理权限
TransactionModel tran = new TransactionModel();
tran.Add(UserRoleBLL.SingleModel.BuildAddSql(new UserRole()
{
RoleId = (int)RoleType.分店管理员, AppId = appId, StoreId = storeId, State = 1, UserId = accountmodel.Id, CreateDate = DateTime.Now, UpdateDate = DateTime.Now
}));
FootBath store = FootBathBLL.SingleModel.GetModel(storeId);
store.ShopManagerName = lcode.WxUser.nickname;
store.ShopManager = accountmodel.LoginId;
tran.Add(FootBathBLL.SingleModel.BuildUpdateSql(store));
bool isSuccess = UserRoleBLL.SingleModel.ExecuteTransactionDataCorect(tran.sqlArray);
if (!isSuccess)
{
return(Json(new { success = true, msg = "加入数据库失败！" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = true, msg = "绑定成功！", ShopManagerName = store.ShopManagerName, ShopManager = store.ShopManager }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, msg = "找不到openid！" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, msg = "绑定失败！" }, JsonRequestBehavior.AllowGet));
}
// return Json(new { success = false, msg = "绑定失败！" }, JsonRequestBehavior.AllowGet);
}
public ActionResult WXLogin(string wxkey = "")
{
LoginQrCode lcode = RedisUtil.Get <LoginQrCode>("SessionID:" + wxkey);
if (string.IsNullOrEmpty(wxkey))
{
return(Json(new { success = false, msg = "登录失败！" }, JsonRequestBehavior.AllowGet));
}
if (lcode == null)
{
return(Json(new { success = false, msg = "登录失败！" }, JsonRequestBehavior.AllowGet));
}
if (!lcode.IsLogin)
{
return(Json(new { success = false, msg = "登录失败！" }, JsonRequestBehavior.AllowGet));
}
if (lcode.WxUser != null)
{
//已扫描
Account accountmodel = null;
if (!string.IsNullOrEmpty(lcode.WxUser.openid))
{
log4net.LogHelper.WriteInfo(this.GetType(), $"MiniappUserBaseInfo ");
UserBaseInfo userInfo = UserBaseInfoBLL.SingleModel.GetModelByOpenId(lcode.WxUser.openid, lcode.WxUser.serverid);
if (userInfo == null)
{
userInfo = new UserBaseInfo();
userInfo.openid = lcode.WxUser.openid;
userInfo.nickname = lcode.WxUser.nickname;
userInfo.headimgurl = lcode.WxUser.headimgurl;
userInfo.sex = lcode.WxUser.sex;
userInfo.country = lcode.WxUser.country;
userInfo.city = lcode.WxUser.city;
userInfo.province = lcode.WxUser.province;
userInfo.unionid = lcode.WxUser.unionid;
UserBaseInfoBLL.SingleModel.Add(userInfo);
}
accountmodel = AccountBLL.SingleModel.GetAccountByWeixinUser(lcode.WxUser);
if (accountmodel == null)
{
return(Json(new { success = false, msg = "登录失败！" }, JsonRequestBehavior.AllowGet));
}
Member member = MemberBLL.SingleModel.GetModel(string.Format("AccountId ='{0}'", accountmodel.Id.ToString()));
member.LastModified = DateTime.Now;//记录登录时间
MemberBLL.SingleModel.Update(member);
RedisUtil.Remove("SessionID:" + wxkey);
//CookieHelper.Remove("agent_UserCookieNew");
//CookieHelper.Remove("dz_UserCookieNew");
//CookieHelper.Remove("regphoneuserid");
//Session["dz_MultiStoreAccountId"] = 0;
//string cookiedomain = ".vzan.com";
//Session["dz_UserCookieNew"] = accountmodel.Id.ToString();
//CookieHelper.SetCookie("dz_UserCookieNew", accountmodel.Id.ToString(), cookiedomain, 60 * 24 * 10);
return(Json(new { success = true, msg = accountmodel.Id.ToString() }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, msg = "登录失败！" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = false, msg = "登录失败！" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 取得基础数据 用于查询用户条件
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public Stream GetUserBase(Stream data)
{
#region 查找数据
ResGetUserBase response = new ResGetUserBase();
bool success = true;
try
{
UserBaseInfo userbase = new UserBaseInfo();
////代理店信息列表
//List<NodeInfo> agency_shop_list = List2Tree(COMPANYMSTRule.GetList());
////分公司信息列表
//List<NodeInfo> filiale_list = List2Tree(SUBCOMPANYMSTRule.GetList());
//代理店信息列表
List <COMPANYMST> agency_shop_list = COMPANYMSTRule.GetList();
//分公司信息列表
List <SUBCOMPANYMST> filiale_list = SUBCOMPANYMSTRule.GetList();
//代理店分公司树形结构数据
List <NodeInfo> company_list = GetCompanyTree(agency_shop_list, filiale_list);
//userbase.agency_shop_list = agency_shop_list;
//userbase.filiale_list = filiale_list;
userbase.company_list = company_list;
//组织数据
response.userbase = userbase;
//输出成功状态
success = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
#region 日志输出
CommonInfo.Error("获取用户列表数据错误" + ex.Message);
#endregion
}
//返回消息体
if (success)
{
response.SetSuccess();
}
else
{
////默认是失败
//response.SetFailed();
}
//将消息序列化为Json格式数据
DataContractJsonSerializer obj2Json = new DataContractJsonSerializer(typeof(ResGetUserBase));
MemoryStream ms = new MemoryStream();
obj2Json.WriteObject(ms, response);
//注意一定要设置流的位置到开始位置,否则没有消息输出
ms.Position = 0;
return(ms);
#endregion
}
public string Register(string username, string password, string nickname)
{
StringBuilder sb = null;
try
{
if (!Regex.IsMatch(password, PasswordExpression))
{
sb = new StringBuilder();
sb.Append("<RegisterInfo>");
sb.AppendFormat("<IsRegistered>{0}</IsRegistered>", false);
sb.AppendFormat("<ErrorMsg>{0}</ErrorMsg>", "密码必须是由数字或字母组成的字符串，且最小6位，最大30位！");
sb.Append("</RegisterInfo>");
return(sb.ToString());
}
if (!Regex.IsMatch(username, @"^(\d+){11}$"))
{
sb = new StringBuilder();
sb.Append("<RegisterInfo>");
sb.AppendFormat("<IsRegistered>{0}</IsRegistered>", false);
sb.AppendFormat("<ErrorMsg>{0}</ErrorMsg>", "注册失败，原因：用户名应是您的手机号！");
sb.Append("</RegisterInfo>");
return(sb.ToString());
}
MembershipUser user = null;
using (TransactionScope scope = new TransactionScope())
{
user = Membership.GetUser(username);
if (user != null)
{
sb = new StringBuilder();
sb.Append("<RegisterInfo>");
sb.AppendFormat("<IsRegistered>{0}</IsRegistered>", false);
sb.AppendFormat("<ErrorMsg>{0}</ErrorMsg>", "注册失败，已存在用户：" + username + "，请换一个账号再重试");
sb.Append("</RegisterInfo>");
return(sb.ToString());
}
user = Membership.CreateUser(username, password);
if (user == null)
{
sb = new StringBuilder();
sb.Append("<RegisterInfo>");
sb.AppendFormat("<IsRegistered>{0}</IsRegistered>", false);
sb.AppendFormat("<ErrorMsg>{0}</ErrorMsg>", "注册失败，请检查：密码正确格式应由数字或字母组成的字符串，且最小6位，最大30位");
sb.Append("</RegisterInfo>");
return(sb.ToString());
}
Roles.AddUserToRole(username, "Users");
UserBaseInfo ubModel = new UserBaseInfo();
ubModel.Nickname = nickname.Trim();
ubModel.UserId = Guid.Parse(user.ProviderUserKey.ToString());
ubModel.HeadPicture = "";
ubModel.Sex = "";
ubModel.MobilePhone = username;
ubModel.TotalGold = 0;
ubModel.TotalSilver = 0;
ubModel.TotalSilver = 0;
ubModel.SilverLevel = 0;
ubModel.ColorLevel = 0;
ubModel.IntegralLevel = 0;
ubModel.VIPLevel = "V0";
UserBase ubBll = new UserBase();
ubBll.Insert(ubModel);
scope.Complete();
}
sb = new StringBuilder();
sb.Append("<RegisterInfo>");
sb.AppendFormat("<IsRegistered>{0}</IsRegistered>", true);
sb.AppendFormat("<UserId>{0}</UserId>", user.ProviderUserKey);
sb.Append("</RegisterInfo>");
return(sb.ToString());
}
catch (Exception ex)
{
new CustomException(ex.Message, ex);
sb = new StringBuilder();
sb.Append("<RegisterInfo>");
sb.AppendFormat("<IsRegistered>{0}</IsRegistered>", false);
sb.Append("<ErrorMsg> 异常：" + ex.Message + "</ErrorMsg>");
sb.Append("</RegisterInfo>");
return(sb.ToString());
}
}
public PostUserAddArgs(UserBaseInfo _user)
{
userInfo = _user;
}
public Dialog_AddUserPost(UserBaseInfo _user)
{
InitializeComponent();
CurrentUser = _user;
InitForm();
}
