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