/// <summary>
/// me_得到开庄数
/// </summary>
public int Get_kz_num(int meid, int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT COUNT(*) FROM tb_BJL_Room WHERE UsID=@meid and state=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@meid", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
parameters[1].Value = meid;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt32(0));
}
else
{
return(0);
}
}
}
/// <summary>
/// me_得到用户币
/// </summary>
public long GetGold(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select XK3Money from tb_SWB ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt64(0));
}
else
{
return(0);
}
}
}
/// <summary>
/// 得到编号取奖品类型
/// </summary>
public int GetMyGoodsType(int GoodsCounts)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MyGoodsType from tb_DrawUser ");
strSql.Append(" where GoodsCounts=@GoodsCounts ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsCounts", SqlDbType.Int, 4)
};
parameters[0].Value = GoodsCounts;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt32(0));
}
else
{
return(0);
}
}
}
/// <summary>
/// 得到一个WinCent
/// </summary>
public long GetWinCent(string time1, string time2)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(WinCent) from tb_BQCPay ");
if (time1.Trim() != "")
{
strSql.Append(" where State!=0 and isSpier!=1 and AddTime BETWEEN '" + time1 + "' and '" + time2 + "'");
}
SqlParameter[] parameters =
{
new SqlParameter("@WinCent", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到签到时间
/// </summary>
public DateTime getQdTime(int UsID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select QdTime from tb_DrawJifen ");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4)
};
parameters[0].Value = UsID;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetDateTime(0));
}
else
{
return(DateTime.Now);
}
}
}
/// <summary>
/// me_得到总价钱
/// </summary>
public long get_usergoid(int usid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SUM(s.num * (m.price_in/2)) from tb_NC_mydaoju s inner join tb_NC_shop m on s.name_id=m.num_id AND s.usid=@usid AND s.suoding=0");
SqlParameter[] parameters =
{
new SqlParameter("@usid", SqlDbType.Int, 4)
};
parameters[0].Value = usid;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
try
{
return(reader.GetInt64(0));
}
catch
{
return(0);
}
}
else
{
return(0);
}
}
}
/// <summary>
/// 根据号码得到你的答案
/// </summary>
public string GetAnswer(int account)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Answer from tb_Question ");
strSql.Append(" where ID=@account ");
SqlParameter[] parameters =
{
new SqlParameter("@account", SqlDbType.Int, 4)
};
parameters[0].Value = account;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetString(0));
}
else
{
return("");
}
}
}
/// <summary>
/// 计算某ID给某ID的送礼次数
/// </summary>
public int GetCount(int UsID, int ToID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Count(ID) from tb_Shopsend");
strSql.Append(" where UsID=@UsID ");
strSql.Append(" and ToID=@ToID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@ToID", SqlDbType.Int, 4)
};
parameters[0].Value = UsID;
parameters[1].Value = ToID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个GetPayCentlast
/// </summary>
public long GetPayCentlast()
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select sum(BuyCent) from tb_Stkpay ");
strSql.Append(" where StkId=(select Top(1) ID from tb_StkList where State=1 Order by ID Desc) and isSpier!=1 and UsID in (select ID from tb_User where IsSpier!=1) ");
SqlParameter[] parameters =
{
new SqlParameter("@BuyCent", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
//得到本月收集币
public long GetCmg_AllcolletGoldmonth1(string time1, string time2)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(AllcolletGold) from tb_Cmg_Top ");
strSql.Append(" where Time BETWEEN '" + time1 + "' and '" + time2 + "'");
strSql.Append("and DcolletGold=10 and isrobot=0");
//strSql.Append(" order by sum(AllcolletGold)");
SqlParameter[] parameters =
{
new SqlParameter("@AllcolletGold", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
//得到总收集币
public long GetCmg_AllcolletGold1(int usID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(AllcolletGold) from tb_Cmg_Top ");
strSql.Append(" where usID=@usID ");
strSql.Append("and DcolletGold=10 ");
//strSql.Append(" order by sum(AllcolletGold)");
SqlParameter[] parameters =
{
new SqlParameter("@usID", SqlDbType.Int, 4)
};
parameters[0].Value = usID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到id玩的次数
/// </summary>
public int GetCmgcount(int usID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from tb_Cmg_Top ");
strSql.Append(" where jID=1 and datediff(day,Time,getdate())=0 and Changj='山涧小溪'");
strSql.Append("and usID=@usID ");
SqlParameter[] parameters =
{
new SqlParameter("@usID", SqlDbType.Int, 4)
};
parameters[0].Value = usID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个GetSysPaylast
/// </summary>
public long GetSysdayprizelast()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(sysdayprize) from tb_BQCList ");
strSql.Append(" where CID=(select Top(1) CID from tb_BQCList where State=1 Order by CID Desc) ");
SqlParameter[] parameters =
{
new SqlParameter("@sysdayprize", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到最低下注
/// </summary>
public int GetPtype(string GameName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ptype from tb_WinnersGame ");
strSql.Append(" where GameName=@GameName ");
SqlParameter[] parameters =
{
new SqlParameter("@GameName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = GameName;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt32(0));
}
else
{
return(0);
}
}
}
/// <summary>
/// me_得到道具数量
/// </summary>
public int Get_daojunum2(int meid, int ID, int iszengsong)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select num from tb_NC_mydaoju ");
strSql.Append(" where usid=@meid and huafei_id=@ID and iszengsong=@iszengsong ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@meid", SqlDbType.Int, 4),
new SqlParameter("@iszengsong", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
parameters[1].Value = meid;
parameters[2].Value = iszengsong;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
try
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt32(0));
}
else
{
return(0);
}
}
catch
{
return(0);
}
}
}
/// <summary>
/// me_得到设置游戏的总个数
/// </summary>
public int Get_yx()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) as a FROM tb_bossrobot WHERE type=1");
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString()))
{
try
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt32(0));
}
else
{
return(0);
}
}
catch
{
return(0);
}
}
}
/// <summary>
/// me_得到是否锁定
/// </summary>
public int Get_suoding(int meid, int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tb_NC_mydaoju ");
strSql.Append(" where usid=@meid and name_id=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@meid", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
parameters[1].Value = meid;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
try
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetInt32(0));
}
else
{
return(0);
}
}
catch
{
return(0);
}
}
}
/// <summary>
///得到特定房间ID和桌面table的最旧的下注时间
/// </summary>
public DateTime GetMinBetTime(int RoomID, int RoomDoTable, int type)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top(1)BetDate from tb_BaccaratUserDo ");
strSql.Append("where RoomID=@RoomID and RoomDoTable=@RoomDoTable and type=@type order by BetDate asc");
SqlParameter[] parameters =
{
new SqlParameter("@RoomID", SqlDbType.Int, 4),
new SqlParameter("@RoomDoTable", SqlDbType.Int, 4),
new SqlParameter("@type", SqlDbType.Int, 4)
};
parameters[0].Value = RoomID;
parameters[1].Value = RoomDoTable;
parameters[2].Value = type;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetDateTime(0));
}
else
{
return(DateTime.Now);
}
}
}
/// <summary>
/// 根据号码得到验证码
/// </summary>
public string GetCode(string Mypmobile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select code from tb_Question ");
strSql.Append(" where Mobile=@Mypmobile ");
SqlParameter[] parameters =
{
new SqlParameter("@Mypmobile", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Mypmobile;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetString(0));
}
else
{
return("");
}
}
}
/// <summary>
/// 得到特定房间ID和桌面table的最旧的下注时间
/// </summary>
/// <param name="RoomID"></param>
/// <param name="RoomDoTable"></param>
/// <returns></returns>
public DateTime GetMinTime(int RoomID, int RoomDoTable)
{
StringBuilder strSql = new StringBuilder();
//SELECT * from tb_BaccaratHistory where RoomID=16 and RoomDoTable=1 ORDER by BonusTimes ASC
strSql.Append("select top(1)BonusTimes from tb_BaccaratHistory ");
strSql.Append("where RoomID=@RoomID and RoomDoTable=@RoomDoTable order by BonusTimes asc");
SqlParameter[] parameters =
{
new SqlParameter("@RoomID", SqlDbType.Int, 4),
new SqlParameter("@RoomDoTable", SqlDbType.Int, 4)
};
parameters[0].Value = RoomID;
parameters[1].Value = RoomDoTable;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetDateTime(0));
}
else
{
return(DateTime.Now);
}
}
}
/// <summary>
/// 得到机器人投注次数
/// </summary>
public int GetRobotbuy(int usid, int luckid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from tb_Luckpay ");
strSql.Append(" where datediff(day,AddTime,getdate())=0 ");
strSql.Append("and UsID=@UsID and IsRobot=1 and LuckId=@luckid");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@LuckId", SqlDbType.Int, 4)
};
parameters[0].Value = usid;
parameters[1].Value = luckid;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到机器人投注次数
/// </summary>
public int GetcountRebot(int usid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from tb_HcPay ");
strSql.Append(" where datediff(day,AddTime,getdate())=0 ");
strSql.Append("and UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4)
};
parameters[0].Value = usid;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个WinCentlast5
/// </summary>
public long GetWinCentlast5()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(WinCent) from tb_BQCPay ");
strSql.Append("where CID in (select Top(5) CID from tb_BQCList where State=1 Order by CID Desc) and isSpier!=1 ");
SqlParameter[] parameters =
{
new SqlParameter("@WinCent", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// 根据用户ID和酷币查询影响的行数的ID
/// </summary>
/// <returns></returns>
public int GetRowByUsID(int UsID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT Top(1)* from tb_dawnlifeUser where UsID=@UsID order by coin desc ");
//strSql.Append("UsID=@UsID ");
//strSql.Append("and coin=@coin");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int),
};
parameters[0].Value = UsID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到用户昵称
/// </summary>
public string GetUsName(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UsName from tb_user ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetString(0));
}
else
{
return("");
}
}
}
/// <summary>
///me_得到特定房间ID和桌面table的最旧的下注时间
/// </summary>
public DateTime GetMinBetTime(int RoomID, int Play_Table)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top(1)updatetime from tb_BJL_Play ");
strSql.Append("where RoomID=@RoomID and Play_Table=@Play_Table order by updatetime ASC");
SqlParameter[] parameters =
{
new SqlParameter("@RoomID", SqlDbType.Int, 4),
new SqlParameter("@Play_Table", SqlDbType.Int, 4)
};
parameters[0].Value = RoomID;
parameters[1].Value = Play_Table;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetDateTime(0));
}
else
{
return(DateTime.Now);
}
}
}
/// <summary>
/// 得到
/// </summary>
public string GetMyGoodsbynum(int Num)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MyGoods from tb_DrawUser ");
strSql.Append(" where Num=@Num ");
SqlParameter[] parameters =
{
new SqlParameter("@Num", SqlDbType.Int, 4)
};
parameters[0].Value = Num;
using (SqlDataReader reader = SqlHelperUser.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
return(reader.GetString(0));
}
else
{
return(null);
}
}
}
/// 根据用户ID和day查询影响的行数的ID
/// </summary>
/// <returns></returns>
public int GetRowByUsID(int UsID, int day, long coin)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID from tb_dawnlifeDays where ");
strSql.Append("UsID=@UsID ");
strSql.Append("and day=@day ");
strSql.Append("and coin=@coin");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int),
new SqlParameter("@day", SqlDbType.Int),
new SqlParameter("@coin", SqlDbType.BigInt)
};
parameters[0].Value = UsID;
parameters[1].Value = day;
parameters[2].Value = coin;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一天内某个用户是经过帖子生成抽奖点值的值
/// </summary>
public int GetJfbyGame(int UsId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select sum(AcGold) from tb_DrawJifenlog ");
strSql.Append(" where UsId= " + UsId + " and datediff(d,AddTime,getdate())=0 and AcText like '%消费%' ");
SqlParameter[] parameters =
{
new SqlParameter("@AcGold", SqlDbType.Int)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个GetPayCent
/// </summary>
public long GetPayCent(string time1, string time2)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(Prize) from tb_BQCJackpot ");
if (time1.Trim() != "")
{
strSql.Append(" where (usID=1 or usID=0 or usID=2 or usID=3) and AddTime BETWEEN '" + time1 + "' and '" + time2 + "'");
}
SqlParameter[] parameters =
{
new SqlParameter("@Prize", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
