Beispiel #1
0
    private bool CheckExist_PROMOTE(string strPROMOTE_ID)
    {
        bool bResult = true;
        BCO.VAM15_BCO BCO = new BCO.VAM15_BCO(ConntionDB);

        if (strPROMOTE_ID != "")
        {
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(strPROMOTE_ID);
            DataTable dt = BCO.QueryForSLP(ParameterList);
            if (dt.Rows.Count == 0)
                bResult = false;
        }

        return bResult;
    }
    public string PROMOTE_NAME(string strPROMOTE_ID)
    {
        string Name = "";
        string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase;
        VAM15_BCO BCO = new VAM15_BCO(ConnectionDBStr);

        if (strPROMOTE_ID != "")
        {
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(strPROMOTE_ID);
            DataTable dt = BCO.QueryForSLP(ParameterList);
            Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["PROMOTE_NAME"].ToString() : "查無資料");
        }

        return Name;
    }