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