Exemple #1
0
        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;
        }
Exemple #2
0
        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;
        }
Exemple #3
0
        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;
        }