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