예제 #1
0
        public GetMyBookingListResponse GetMyBookingList(GetMyBookingListRequest request)
        {
            var result = new GetMyBookingListResponse()
            {
                ResultMessage = "获取我的公益课程列表成功",
                Result        = ResultCode.Success
            };

            try
            {
                using (var con = new DbConnectionProvider(dbName).GetOpenConnection())
                {
                    var parms = new DynamicParameters();
                    parms.Add("P_UserID", request.UserID, DbType.Int32);
                    parms.Add("P_BeginDate", request.BeginDate, DbType.DateTime);
                    parms.Add("P_EndDate", request.EndDate, DbType.DateTime);

                    result.MyBookingList = con.Query <CourseBookingDTO>("sp_GetMyBookingList"
                                                                        , parms
                                                                        , CommandType.StoredProcedure).ToList();
                }
            }
            catch (Exception ex)
            {
                result.ResultMessage = "获取我的公益课程列表异常";
                result.Result        = ResultCode.Error;
                result.Errors        = new List <string>();
                result.Errors.Add(ex.Message);
                LogHelper.WriteErrorLog(ex);
            }
            return(result);
        }
 public GetMyBookingListResponse GetMyBookingList(GetMyBookingListRequest request)
 {
     return(CourseBookingManager.GetInstance().GetMyBookingList(request));
 }