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