/// <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());
}
