/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/12/19 16:54:28</remarks> public bool Update(TxLogininfoEntity entity, DbTransaction trans = null) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_TxLogininfo_Update"); database.AddInParameter(commandWrapper, "@OpenId", DbType.AnsiString, entity.OpenId); database.AddInParameter(commandWrapper, "@OpenKey", DbType.AnsiString, entity.OpenKey); database.AddInParameter(commandWrapper, "@Pf", DbType.AnsiString, entity.Pf); database.AddInParameter(commandWrapper, "@Format", DbType.AnsiString, entity.Format); database.AddInParameter(commandWrapper, "@Ext", DbType.AnsiString, entity.Ext); database.AddInParameter(commandWrapper, "@Ext1", DbType.AnsiString, entity.Ext1); database.AddInParameter(commandWrapper, "@UpdateTime", DbType.DateTime, entity.UpdateTime); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到TxLogininfoEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public TxLogininfoEntity LoadSingleRow(IDataReader reader) { var obj = new TxLogininfoEntity(); obj.OpenId = (System.String)reader["OpenId"]; obj.OpenKey = (System.String)reader["OpenKey"]; obj.Pf = (System.String)reader["Pf"]; obj.Format = (System.String)reader["Format"]; obj.Ext = (System.String)reader["Ext"]; obj.Ext1 = (System.String)reader["Ext1"]; obj.UpdateTime = (System.DateTime)reader["UpdateTime"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="openId">openId</param> /// <returns>TxLogininfoEntity</returns> /// <remarks>2016/12/19 16:54:28</remarks> public TxLogininfoEntity GetById(System.String openId) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_TxLogininfo_GetById"); database.AddInParameter(commandWrapper, "@OpenId", DbType.AnsiString, openId); TxLogininfoEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
private bool doLoginNew(ref string cookie) { try { TxLogininfoEntity tLoginInfo = null; var platformId = GetParam("platform"); var userName = GetParam("openid"); if (ShareUtil.IsQunHei) { userName = GetParam("username"); } //if (userName.Length>0 && userName.Contains("h5_zhiqu")) // return false; var user = NbUserMgr.GetByAccount(userName, GetIp(), DateTime.Today.AddDays(-1), DateTime.Today, 0); var sessionId = ShareUtil.GenerateComb().ToString(); if (user != null) { UserAccountEntity userAccountEntity = new UserAccountEntity(user.Account, Guid.Empty, "", 1, platformId, sessionId); userAccountEntity.ExtraData = "d|pengyou|f"; var info = reader.GetManagerInfoByAccount(userAccountEntity.Account, GetIp(), UAFactory.Instance.IsTx); if (info.Code == (int)MessageCode.Success) { if (info.Data.NeedSelect == false) { if (ShareUtil.IsTx) { string openKey = GetParam("openkey"); string pf = GetParam("pf"); if (string.IsNullOrEmpty(pf)) { pf = "wanba_ts"; } string platform = GetParam("platform"); //userip //sig int appId = UAFactory.Instance.TxAppId; string appKey = UAFactory.Instance.TxAppKey; var result = WbUserInfo(userName, openKey, pf, platform, appId, appKey); if (result != 0) { OutputHelper.Output(result); } tLoginInfo = new TxLogininfoEntity(userName, openKey, pf, platform, "", "", DateTime.Now, DateTime.Now); } if (info.Data.ManagerInfo == null) { string playerName = ""; string logo = "1"; int templateId = 1; var createData = reader.CreateManager(UserAccount.Account, playerName, logo, templateId, UAHelper.GetRealIP()); if (createData.Code != (int)MessageCode.Success) { info.Code = createData.Code; OutputHelper.Output(info); } info = reader.GetManagerInfoByAccount(UserAccount.Account, GetIp(), UAFactory.Instance.IsTx);; } try { if (ShareUtil.IsH5A8) { UA_A8.UserAction("entergame", info.Data.ManagerInfo.Manager.Account, "", "", info.Data.ManagerInfo.Manager); } } catch (Exception) { } if (CheckLockState(info.Data.ManagerInfo.Manager.Idx)) { OutputHelper.Output(MessageCode.LoginOnlineLock); } //写入登录信息 cookie = UAHelper.SetFormsAuthentication(userAccountEntity.Account, info.Data.ManagerInfo.Manager.Idx, info.Data.ManagerInfo.Manager.Name, 1, sessionId); OnlineMgr.LoginSession(info.Data.ManagerInfo.Manager.Idx, sessionId); onlineClient.RiseOnlineTime(info.Data.ManagerInfo.Manager.Idx); info.Data.Cookie = cookie; Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, cookie)); var isSubscribe = GetParamBool("isSubscribe"); if (isSubscribe)//关注 { activityClient.DoShare(info.Data.ManagerInfo.Manager.Idx, 4); } if (ShareUtil.IsTx) { TxLogininfoMgr.InsertUpdate(tLoginInfo); } return(true); } return(true); } else { FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, user.Account, DateTime.Now, DateTime.Now.AddDays(10), false, userAccountEntity.ToString(), FormsAuthentication .FormsCookiePath); cookie = FormsAuthentication.Encrypt(ticket); Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, cookie)); return(false); } } return(false); } catch (Exception ex) { cookie = ex.ToString(); return(true); } }
public static bool InsertUpdate(TxLogininfoEntity txLogininfoEntity, DbTransaction trans = null, string zoneId = "") { TxLogininfoProvider provider = new TxLogininfoProvider(zoneId); return(provider.InsertUpdate(txLogininfoEntity, trans)); }