/// <summary>
/// 得到每月收集币
/// </summary>
public long GetCmgTopMcolletGold(int usID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select McolletGold from tb_CmgToplist");
strSql.Append(" where datediff(month,updatetime,getdate())=0 ");
strSql.Append(" and usID=@usID");
//strSql.Append(" where AllcolletGold=@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));
}
}
/// 根据用户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 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>
/// 得到一个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));
}
}
/// <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));
}
}
/// <summary>
/// 得到一天内某个用户是经过帖子生成抽奖点值的值
/// </summary>
public int GetJfbyCz(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>
/// 得到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));
}
}
//得到本月收集币
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));
}
}
/// 根据用户ID和coin查询影响的行数的ID
/// </summary>
/// <returns></returns>
public int GetRowByUsID(int UsID, long coin, long money)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ID from tb_dawnlifeTop where ");
strSql.Append("UsID=@UsID ");
strSql.Append("and coin=@coin ");
strSql.Append("and money=@money");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int),
new SqlParameter("@coin", SqlDbType.BigInt),
new SqlParameter("@money", SqlDbType.BigInt)
};
parameters[0].Value = UsID;
parameters[1].Value = coin;
parameters[2].Value = money;
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>
/// 得到一个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));
}
}
/// <summary>
/// 通过字段得到id
/// </summary>
public int GetID1(int usID, int stype)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID from tb_Cmg_notes");
strSql.Append(" where stype=@stype ");
strSql.Append("and usID=@usID");
SqlParameter[] parameters =
{
new SqlParameter("@stype", SqlDbType.Int, 4),
new SqlParameter("@usID", SqlDbType.Int, 4)
};
parameters[0].Value = stype;
parameters[1].Value = usID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到全部本月收集币
/// </summary>
public long GettoplistMcolletGoldsum()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(McolletGold) from tb_CmgToplist");
strSql.Append(" where datediff(month,updatetime,getdate())=0 ");
strSql.Append(" order by sum(McolletGold)");
//strSql.Append(" where AllcolletGold=@AllcolletGold ");
SqlParameter[] parameters =
{
new SqlParameter("@McolletGold", 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 GetXXCID(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top(1) datenum FROM tb_HP3_kjnum ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
SqlParameter[] parameters =
{
new SqlParameter("@datenum", SqlDbType.Int, 8)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(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>
/// 得到一个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>
/// 计算某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>
/// 得到每日收集币
/// </summary>
public long GetCmgTopDcolletGold(int usID, string time)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DcolletGold from tb_CmgToplist");
strSql.Append(" where Time BETWEEN '" + time + "" + " 00:00:00' and '" + time + "" + " 23:59:59'");
strSql.Append(" and usID=@usID");
//strSql.Append(" where AllcolletGold=@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>
/// 更新签到时间
/// </summary>
public void UpdateQdTime(int UsID, DateTime QdTime)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_DrawJifen set ");
strSql.Append("QdTime=@QdTime ");
strSql.Append(" where UsID=@UsID ");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@QdTime", SqlDbType.DateTime)
};
parameters[0].Value = UsID;
parameters[1].Value = QdTime;
SqlHelperUser.GetSingle(strSql.ToString(), parameters);
}
/// <summary>
/// 得到某分类的圈子数
/// </summary>
public int GetGroupNum(int Types)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(ID) from tb_Group");
strSql.Append(" where Types=" + Types + "");
object obj = SqlHelperUser.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 查找指定期数的比赛结果
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string FindResultByPhase(int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Result from tb_BQCList where CID=@CID");
SqlParameter parameters = new SqlParameter("@CID", SqlDbType.Int, 4);
parameters.Value = CID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return("");
}
else
{
return(Convert.ToString(obj));
}
}
/// <summary>
/// me_得到中奖注数
/// </summary>
public int get_jiangchi(int phase)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT nowprize FROM tb_JQC_Internet WHERE phase='" + phase + "'");
SqlParameter[] parameters =
{
new SqlParameter("@phase", SqlDbType.Int, 4)
};
parameters[0].Value = phase;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// me_得到中奖注数
/// </summary>
public string get_zhumeney(int phase)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT zhu_money FROM tb_JQC_Internet WHERE phase='" + phase + "'");
SqlParameter[] parameters =
{
new SqlParameter("@phase", SqlDbType.Int, 4)
};
parameters[0].Value = phase;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return("");
}
else
{
return(Convert.ToString(obj));
}
}
/// <summary>
/// me_得到该期某注的中奖人数
/// </summary>
public int count_renshu(int Lottery_issue, string Prize)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT SUM(" + Prize + "*VoteRate) FROM tb_JQC_Bet WHERE Lottery_issue=" + Lottery_issue + " AND " + Prize + ">0");
SqlParameter[] parameters =
{
new SqlParameter("@Lottery_issue", SqlDbType.Int, 4)
};
parameters[0].Value = Lottery_issue;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// me_得到该期总中奖人数
/// </summary>
public int count_zhu(int Lottery_issue)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT COUNT(*) FROM tb_JQC_Bet WHERE GetMoney>0 AND Lottery_issue='" + Lottery_issue + "'");
SqlParameter[] parameters =
{
new SqlParameter("@Lottery_issue", SqlDbType.Int, 4)
};
parameters[0].Value = Lottery_issue;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到中2等奖注数
/// </summary>
/// <param name="CID"></param>
/// <param name="IsPrize"></param>
/// <returns></returns>
public int countPrize2(int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum( Prize2Num*OverRide) from tb_BQCPay where CID=@CID and IsPrize2>0 ");
SqlParameter[] parameters =
{
new SqlParameter("@CID", SqlDbType.Int, 4),
};
parameters[0].Value = CID;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
//me_查询机器人购买次数
/// </summary>
public long Get_paijiang(int Lottery_issue)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT SUM(GetMoney) FROM tb_JQC_Bet WHERE Lottery_issue=@Lottery_issue");
SqlParameter[] parameters =
{
new SqlParameter("@Lottery_issue", SqlDbType.Int, 4)
};
parameters[0].Value = Lottery_issue;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 得到中奖的币
/// </summary>
/// <param name="CID"></param>
/// <param name="Isprize"></param>
/// <returns></returns>
public long Gold(int CID, int IsPrize)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select sum(WinCent) from tb_BQCPay where CID=" + CID + " and IsPrize=" + IsPrize + " ");
SqlParameter[] parameters =
{
new SqlParameter("@WinCent", SqlDbType.Int, 4)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据期号得到开奖类型和开奖时间
/// </summary>
public string GetStateTime(int SSCId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select StateTime from tb_SSClist where SSCId=" + SSCId);
SqlParameter[] parameters =
{
new SqlParameter("@StateTime", SqlDbType.NVarChar, 4000)
};
parameters[0].Value = 0;
object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(" ");
}
else
{
return(Convert.ToString(obj));
}
}