예제 #1
0
 public List<string> GetSqlByPicture(List<CoursePicture> plist,int course_id)
 {
     List<string> list = new List<string>();
     ICoursePictureImplMgr _p = new CoursePictureMgr(conStr);
     CoursePicture c = new CoursePicture();
     c.course_id = course_id;
     list.Add(_p.Delete(c));
     try
     {
         foreach (CoursePicture item in plist)
         {
             item.course_id = course_id;
             list.Add(_p.Save(item));
         }
         
         return list;
     }
     catch (Exception ex)
     {
         throw new Exception("CourseMgr-->GetSqlByPicture" + ex, ex);
     }
 }
예제 #2
0
        /// <summary>
        /// 獲取課程圖檔
        /// </summary>
        /// <returns></returns>

        public ActionResult GetCourseImg(int course_id = 0)
        {
            List<CoursePicture> list = new List<CoursePicture>();
            try
            {
                ICoursePictureImplMgr _coursePictureMgr = new CoursePictureMgr(connectionString);
                CoursePicture cp = new CoursePicture();
                cp.course_id = course_id;
   
                imgServerPath = imgServerPath + "/course/a/";
                list = _coursePictureMgr.Query(cp);
                for (int i = 0; i < list.Count;i++ )
                {
                    list[i].id =Convert.ToUInt32(i);
                    list[i].picture_name = list[i].picture_name.Replace(" ", imgServerPath);
                }

            }
            catch (Exception ex)
            {
                Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
                logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
                logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
                log.Error(logMessage);

            }
            return Json(new { images = list });
        }