/// <summary> /// 根据openid+unionid判断用户是否存在 /// </summary> /// <param name="openId"></param> /// <param name="unionId"></param> /// <returns></returns> public bool CheckUserExist(string openId, string unionId) { bool res = false; try { string sql = "SELECT id FROM user WHERE openId=@OpenId AND unionId=@UnionId;"; MySqlParameter[] param = { new MySqlParameter("@OpenId", openId), new MySqlParameter("@UnionId", unionId) }; res = MySqlHelper.ExecuteScalar(ConfigHelper.ConnStr, sql, param).ToInt() > 0; } catch (Exception ex) { LogHelper.Error(ex); } return(res); }
public string getCount(string casino, string time1, string time2, string enable) { string str = "select count(*) from agentaccount where 1=1"; if (casino != "0") { str += " and casino=" + casino.Replace("'", "") + ""; } if (time1 != "" || time2 != "") { time1 = time1 == "" ? time2 : time1; time2 = time2 == "" ? time1 : time2; str += " and date(operationTime)>=date('" + DateTime.Parse(time1) + "')"; str += " and date(operationTime)<=date('" + DateTime.Parse(time2) + "')"; } if (enable != "-1") { str += " and isEnable=" + enable + ""; } return(MySqlHelper.ExecuteScalar(str).ToString()); }
public int Insert(string UserId, string LoginIP, int SystemTypeId, string EquipmentNum) { int id = 0; try { string sql = @"INSERT INTO `loginlog`(userId,loginIP,loginTime,systemTypeId,equipmentNum) VALUES(@UserId,NOW(),@LoginIP,@SystemTypeId,@EquipmentNum);@@SELECT IDENTITY;"; MySqlParameter[] param = { new MySqlParameter("@UserId", UserId), new MySqlParameter("@LoginIP", LoginIP), new MySqlParameter("@SystemTypeId", SystemTypeId), new MySqlParameter("@EquipmentNum", EquipmentNum), }; id = MySqlHelper.ExecuteScalar(ConfigHelper.ConnStr, sql, param).ToInt(); } catch (Exception ex) { LogHelper.Error(ex); } return(id); }
public int getGameNameListNum(string gameName, string typeName) { try { string sql = string.Format("SELECT count(*) from gamename INNER JOIN type on gamename.gameType=type.ID where 1=1 "); if (!string.IsNullOrEmpty(gameName)) { sql += string.Format(" and gameName='{0}'", gameName); } if (!string.IsNullOrEmpty(typeName)) { sql += string.Format(" and typeName='{0}'", typeName); } int result = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, sql)); return(result); } catch { return(0); } }
public int getUserListNum(string id, string username) { try { string sql = string.Format("SELECT count(*) FROM `users` where 1=1 "); if (!string.IsNullOrEmpty(id)) { sql += string.Format(" and id={0}", id); } if (!string.IsNullOrEmpty(username)) { sql += string.Format(" and username='******'", username); } int result = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, sql)); return(result); } catch { return(0); } }
public int Insert(UserModel user) { int id = 0; try { string sql = @"INSERT INTO `user` (`userId`,`nickName`,`userAvatar`,`email`,`mobileNum`,`password`,`salt`,`userToken`,`tokenUpdateTime`,`tokenIsWork`,`authorizedTypeId`,`openId`,`unionId`,`extra`,`registerTime`,`createTime`,`updateTime`,`createIP`,`systemTypeId`,`equipmentNum`,`isDel`) VALUES(@UserId,@NickName,@UserAvatar,@Email,@MobileNum,@Password,@Salt,@UserToken,@TokenUpdateTime,@TokenIsWork,@AuthorizedTypeId,@OpenId,@UnionId,@Extra,NOW(),NOW(),NOW(),@CreateIP,@SystemTypeId,@EquipmentNum,@IsDel);@@SELECT IDENTITY;"; MySqlParameter[] param = { new MySqlParameter("@UserId", user.UserId), new MySqlParameter("@NickName", user.NickName), new MySqlParameter("@UserAvatar", user.UserAvatar), new MySqlParameter("@Email", user.Email), new MySqlParameter("@MobileNum", user.MobileNum), new MySqlParameter("@Password", EncryptHelper.MD5Encrypt(user.Password + ConfigHelper.Salt)), new MySqlParameter("@Salt", ConfigHelper.Salt), new MySqlParameter("@UserToken", user.UserToken), new MySqlParameter("@TokenUpdateTime", user.TokenUpdateTime), new MySqlParameter("@TokenIsWork", user.TokenIsWork), new MySqlParameter("@AuthorizedTypeId", user.AuthorizedTypeId), new MySqlParameter("@OpenId", user.OpenId), new MySqlParameter("@UnionId", user.UnionId), new MySqlParameter("@Extra", user.Extra), new MySqlParameter("@CreateIP", user.CreateIP), new MySqlParameter("@SystemTypeId", user.SystemTypeId), new MySqlParameter("@EquipmentNum", user.EquipmentNum), new MySqlParameter("@IsDel", user.IsDel) }; id = MySqlHelper.ExecuteScalar(ConfigHelper.ConnStr, sql, param).ToInt(); } catch (Exception ex) { LogHelper.Error(ex); } return(id); }
public int getMachineNum(string macNum, string address) { try { string sql = string.Format("SELECT count(*) from machine where 1=1 "); if (!string.IsNullOrEmpty(macNum)) { sql += string.Format(" machineNum='{0}'", macNum); } if (!string.IsNullOrEmpty(address)) { sql += string.Format(" and address like '%{0}%'", macNum); } int result = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, sql)); return(result); } catch { return(0); } }
//修改 public static Boolean UpdateSestlog(string magnerUser) { string sqls = "select count(*) from yafa.serverlog where magnerUser=?magnerUser and LoginTime=CURDATE()"; MySqlParameter[] parameter = new MySqlParameter[] { new MySqlParameter("?magnerUser", magnerUser) }; int count = Convert.ToInt32(MySqlHelper.ExecuteScalar(sqls, parameter)); if (count > 0) { string sqlupdate = "Update serverlog set LoginEnd=NOW() where magnerUser=?magnerUser and LoginTime=CURDATE()"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?magnerUser", magnerUser) }; bool isture = MySqlHelper.ExecuteNonQuery(sqlupdate, param) > 0; if (isture) { return(true); } else { return(false); } } else { string IP = Util.RequestHelper.GetIP(); string SQLS = "insert into yafa.serverlog (IP,LoginEnd,LoginTime,magnerUser)values(?IP,NOW(),CURDATE(),?magnerUser)"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?IP", IP), new MySqlParameter("?magnerUser", magnerUser) }; return(MySqlHelper.ExecuteNonQuery(SQLS, param) > 0); } }
//新增 public static Boolean AddSestlog(string IP, string LoginBegin, string LoginTime, string magnerUser) { string sqls = "select count(*) from yafa.serverlog where magnerUser=?magnerUser and LoginTime=CURDATE()"; MySqlParameter[] parameter = new MySqlParameter[] { new MySqlParameter("?magnerUser", magnerUser), new MySqlParameter("?LoginTime", LoginTime) }; int count = Convert.ToInt32(MySqlHelper.ExecuteScalar(sqls, parameter)); if (count < 1) { MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?IP", IP), new MySqlParameter("?magnerUser", magnerUser) }; return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0); } else { string sqlupdate = "Update serverlog set LoginBegin=NOW() where magnerUser=?magnerUser and LoginTime=CURDATE()"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?magnerUser", magnerUser) }; bool isture = MySqlHelper.ExecuteNonQuery(sqlupdate, param) > 0; if (isture) { return(true); } else { return(false); } } }
public string getAllCount(string casino, string dali, string id, string enable, string webPoss, string Company) { string str = "select count(*) from betaccount "; string where = "where"; if (casino != "0") { where += " casino=" + casino; } if (dali != "") { if (where == "where") { where += " agent='" + dali + "'"; } else { where += " and agent='" + dali + "'"; } } if (id != "") { if (where == "where") { where += " userid='" + id.Replace("'", "") + "'"; } else { where += " and userid='" + id.Replace("'", "") + "'"; } } if (enable != "-1") { if (where == "where") { where += " enable=" + enable; } else { where += " and enable=" + enable; } } if (webPoss != "") { if (where == "where") { where += " websitepossess=" + webPoss; } else { where += " and websitepossess=" + webPoss; } } if (Company != "") { if (where == "where") { where += " selfpossess=" + Company; } else { where += " and selfpossess=" + Company; } } if (where == "where") { return(MySqlHelper.ExecuteScalar(str).ToString()); } else { return(MySqlHelper.ExecuteScalar(str + where).ToString()); } }
public string getCount() { string str = "select count(*) from notice"; return(MySqlHelper.ExecuteScalar(str).ToString()); }