Esempio n. 1
0
 public List<string> GetSqlByCourseDetail(List<CourseDetail> cdList, int courseId)
 {
     ICourseDetailImplMgr _detailMgr = new CourseDetailMgr(conStr);
     List<string> list = new List<string>();
     if (cdList == null)
         return null;
     int[] cdids = (from c in cdList where c.Course_Detail_Id != 0 select c.Course_Detail_Id).ToArray();
     string ids = string.Join(",", cdids);
     if (_detailMgr.Delete(cdList[0], ids))
     {
         foreach (CourseDetail cd in cdList)
         {
             if (cd.Course_Id == 0)
             {
                 cd.Course_Id = courseId;
             }
             if (cd.Course_Detail_Id == 0)
             {
                 list.Add(_detailMgr.Save(cd));
             }
             else
             {
                 list.Add(_detailMgr.Update(cd));
             }
         }
     }
     return list;
 }