/// <summary>
/// 获取充值码
/// </summary>
/// <param name="db"></param>
/// <param name="userJxsInfoId"></param>
/// <returns></returns>
public static string Get90DaysStockInfo(WinnerDbContext db, int userJxsInfoId)
{
string sql = string.Format("select F_GetJxsTip({0}) as tip from dual", userJxsInfoId);
var tip = db.SqlQuery(sql).FirstOrDefault();
return(tip["TIP"].ToString());
}
/// <summary>
/// 是否完成任务
/// </summary>
/// <param name="db"></param>
/// <param name="nodeid"></param>
/// <param name="typeid">0-上月，1-本月</param>
/// <returns></returns>
public static bool IsFinishTask(WinnerDbContext db, int nodeid, int typeid)
{
string sql = string.Format("select F_IsBlTask({0},{1}) as task from dual", nodeid, typeid);
var num = db.SqlQuery(sql).FirstOrDefault();
return(Convert.ToInt32(num["TASK"].ToString()) > 0);
}
/// <summary>
/// 获取充值码
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public static string GetCentcard(WinnerDbContext db)
{
string getRandSql = "select GetCZMNum czm from dual ";
var rand = db.SqlQuery(getRandSql).FirstOrDefault();
return(rand["CZM"]?.ToString());
}
