C# (CSharp) DAL Views.V_SchemeCountの例

コード例 #1

ファイル: LotteryPrint.cs プロジェクト: object8421/ichari

    public string GetLottery(long SiteID, string ValidCode)
    {
        if (!CheckValidCode(ValidCode))
        {
            return("");
        }

        string UseLotteryList = new Sites()[SiteID].UseLotteryList;

        DataTable dt = new DAL.Views.V_SchemeCount().Open("*", "[ID] in (select [ID] from T_Lotteries where [ID] in (" + UseLotteryList + ") and PrintOutType = 0)", "[Order]");

        if (dt == null)
        {
            return("");
        }

        DataSet ds = new DataSet();

        dt.TableName = "Lottery";
        ds.Tables.Add(dt);

        return(ds.GetXml());
    }

コード例 #2

ファイル: LotteryPrint.cs プロジェクト: ichari/ichari

    public string GetLottery(long SiteID, string ValidCode)
    {
        if (!CheckValidCode(ValidCode))
        {
            return "";
        }

        string UseLotteryList = new Sites()[SiteID].UseLotteryList;

        DataTable dt = new DAL.Views.V_SchemeCount().Open("*", "[ID] in (select [ID] from T_Lotteries where [ID] in (" + UseLotteryList + ") and PrintOutType = 0)", "[Order]");

        if (dt == null)
        {
            return "";
        }

        DataSet ds = new DataSet();
        dt.TableName = "Lottery";
        ds.Tables.Add(dt);

        return ds.GetXml();
    }