Пример #1
0
        /// <summary>
        /// 获取我的订单
        /// </summary>
        /// <param name="memberId"></param>
        /// <returns></returns>
        public List <MyOrder> GetOrders(int memberId, string orderNo)
        {
            var dic = new Dictionary <string, object>();

            dic.Add("@memberId", memberId);
            dic.Add("@orderNo", orderNo);
            return(DbHelperSQL.ExcuteProcedure <MyOrder>("PRO_MyOrder", dic));
        }
Пример #2
0
        public List <CourseProcess> GetClassLesson(int classId, int memberId)
        {
            var dic = new Dictionary <string, object>();

            dic.Add("@classId", classId);
            dic.Add("@memberId", memberId);
            return(DbHelperSQL.ExcuteProcedure <CourseProcess>("PRO_MemberClassLesson", dic));
        }
Пример #3
0
        public List <MemberSchedule> GetSchedule(int memberId, int month, int memberType)
        {
            Dictionary <string, object> dic = new Dictionary <string, object>();

            dic.Add("@memberId", memberId);
            dic.Add("@month", month);
            dic.Add("@memberType", memberType);
            return(DbHelperSQL.ExcuteProcedure <MemberSchedule>("pro_GetMyClassSchedule", dic));
        }
Пример #4
0
        /// <summary>
        /// 查课次
        /// </summary>
        /// <param name="memberId"></param>
        /// <param name="queryType"></param>
        /// <param name="classId"></param>
        /// <param name="courseType"></param>
        /// <returns></returns>
        public List <CourseDetail> GetPactCourse(int memberId, int queryType, int classId, int courseType)
        {
            var dic = new Dictionary <string, object>();

            dic.Add("@MemberId", memberId);
            dic.Add("@ClassType", 1);
            dic.Add("@QueryType", queryType);
            dic.Add("@CourseType", courseType);
            dic.Add("@ClassId", classId);
            dic.Add("@BeginDate", "");
            dic.Add("@EndDate", "");

            return(DbHelperSQL.ExcuteProcedure <CourseDetail>("pro_GetMyClassCourse", dic));
        }