Exemple #1
0
        public DataTable ActiveList(string shopId, ActiveListParam activeListParam)
        {
            StringBuilder selectBuilder = new StringBuilder();

            selectBuilder.AppendFormat(ActiceSqls.SELECT_T_BUSS_ACTIVE_AND_T_BUSS_MEMBER_CHECK_STORE, shopId, activeListParam.title);
            string    select = selectBuilder.ToString();
            DataTable dt     = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0];

            return(dt);
        }
Exemple #2
0
        public int Drainage(string activeId, string shopId, ActiveListParam activeListParam)
        {
            StringBuilder selectBuilder = new StringBuilder();

            selectBuilder.AppendFormat(ActiceSqls.SELECT_DRAINAGE_FROM_T_BUSS_ACTIVE, activeId, shopId, activeListParam.title);
            string    select = selectBuilder.ToString();
            DataTable dt     = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0];
            int       count  = dt.Rows.Count;

            return(count);
        }