public static List<Contents> Contents(int CID) { var l = new List<Contents>(); try { SqlParameter[] param = { new SqlParameter("@CID",CID) }; var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_Contents", param); while (dr.Read()) { var m = new Contents(); m.CID = Convert.ToInt32(dr["CID"]); m.CCID = Convert.ToInt32(dr["CCID"]); m.Name = Convert.ToString(dr["Name"]); m.Duration = Convert.ToInt32(dr["Duration"]); m.Url = Convert.ToString(dr["Url"]); l.Add(m); } dr.Close(); } catch (Exception ex) { log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return l; }
public static R Courses(string imsmanifest, Courses course) { var m = new R(); try { var rl = new List<Contents>(); var xd = new XmlDocument(); var nsmgr = new XmlNamespaceManager(xd.NameTable); nsmgr.AddNamespace("a", "http://www.imsproject.org/xsd/imscp_rootv1p1p2"); xd.Load(imsmanifest); var xtilte = xd.SelectSingleNode("//a:organization//a:title[1]", nsmgr); course.Name = xtilte.InnerText; if (!string.IsNullOrEmpty(course.Name)) { course.Name = course.Name.Trim().Trim(' '); } var xnl = xd.SelectNodes("//a:organization//a:item[@identifierref]", nsmgr); for (int i = 0; i < xnl.Count; i++) { var xn = xnl.Item(i); var xn2 = xd.SelectSingleNode("//a:resources/a:resource[@identifier='" + xn.Attributes["identifierref"].Value + "']", nsmgr); var c = new Contents(); c.CName = course.CName; c.CCID = i + 1; c.CCName = xn.Attributes["identifier"].Value; c.Name = xn.FirstChild.InnerText; c.Url = xn2.Attributes["href"].Value; rl.Add(c); } m = CoursesSavedb(course, rl); log.Info("import:{0},{1},{2}", m.Code, m.Value, m.Message); } catch (Exception ex) { log.Error(ex.Message); log.Error(ex.StackTrace); m.Message = ex.Message; m.Code = 300; } return m; }
public static R Courses(string excelPath, Courses course, bool isMP4) { var m = new R(); try { var rl = new List<Contents>(); //rl.Add(c); string SQL = "Select * from [sheet1$]"; var dr = excel.ExcuteReader(excelPath, SQL); int i = 0; while (dr.Read()) { i = i + 1; try { if (dr["章节"] != DBNull.Value && dr["文件"] != DBNull.Value) { var c = new Contents(); c.CName = course.CName; c.CCID = i; c.CCName = ""; c.Name = Convert.ToString(dr["章节"]); c.Url = Convert.ToString(dr["文件"]); c.MIME = "video/mp4"; rl.Add(c); } } catch (Exception ex1) { m.Code = 301; m.Message = ex1.Message; log.Error("{0},{1}", ex1.Message, ex1.StackTrace); } } dr.Close(); dr.Dispose(); m = CoursesSavedb(course, rl); log.Info("import:{0},{1},{2}", m.Code, m.Value, m.Message); } catch (Exception ex) { log.Error(ex.Message); log.Error(ex.StackTrace); m.Message = ex.Message; m.Code = 300; } return m; }