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(Courses courses, List<Contents> contents) { var m = new R(); try { string SQL1 = @"INSERT INTO [Courses]([CID],[CName],[Name],[Type],[Year],[Memo],[Cate],[Sort],[Teacher],[Length]) VALUES({0},'{1}','{2}',{3},{4},'{5}',{6},{7},'{8}',{9})"; string SQL2 = @"INSERT INTO [Contents]([CID],[CCID],[CCName],[Name],[Duration],[Url]) VALUES({0},{1},'{2}','{3}',{4},'{5}')"; var SQL = new StringBuilder(); SQL.Append("BEGIN"); SQL.AppendLine(); SQL.AppendFormat("DELETE FROM [Courses] WHERE CID = {0}", courses.CID); SQL.AppendLine(); SQL.AppendFormat("DELETE FROM [Contents] WHERE CID = {0}", courses.CID); SQL.AppendLine(); SQL.AppendFormat(SQL1, courses.CID, courses.CName, courses.Name, courses.Type, courses.Year, courses.Memo , courses.Cate , courses.Sort , courses.Teacher , courses.Length ); foreach (var c in contents) { SQL.AppendLine(); SQL.AppendFormat(SQL2, c.CID, c.CCID, c.CCName, c.Name, c.Duration, c.Url); } SQL.AppendLine(); SQL.Append("END"); log.Info(SQL.ToString()); var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.Text, SQL.ToString()); m.Code = 0; } catch (Exception ex) { m.Code = 300; m.Message = ex.Message; log.Error(ex.Message); } return m; }
public static R Cs(string excelPath) { var r = new R(); var ds = PreviewCs(excelPath); var dt = ds.Tables[0]; //int CurrentCID = BaseGet.Seed(2); foreach (DataRow dr in dt.Rows) { var info = new Courses(); info.CID = Get.Seed(2); info.CName = Convert.ToString(dr["CName"]); info.Name = Convert.ToString(dr["Name"]); info.Type = Convert.ToInt32(dr["Type"]); info.Year = Convert.ToInt32(dr["Year"]); info.Cate = Convert.ToInt32(dr["Cate"]); info.Sort = Convert.ToInt32(dr["Sort"]); info.Teacher = Convert.ToString(dr["Teacher"]); info.Length = Convert.ToDecimal(dr["Length"]); info.ActMinutes = Convert.ToDecimal(dr["ActMinutes"]); info.Tag = Convert.ToString(dr["Tag"]); ; info.Memo = Convert.ToString(dr["Memo"]); DAL.M.Update.Courses(info); } return r; }
public static R Courses(Courses info) { var m = new R(); try { SqlParameter[] param = { new SqlParameter("@CID",info.CID), new SqlParameter("@CName",info.CName), new SqlParameter("@Name",info.Name), new SqlParameter("@Type",info.Type), new SqlParameter("@Year",info.Year), new SqlParameter("@Cate",info.Cate), new SqlParameter("@Sort",info.Sort), new SqlParameter("@Teacher",info.Teacher), new SqlParameter("@ActMinutes",info.ActMinutes), new SqlParameter("@Length",info.Length), new SqlParameter("@Tag",info.Tag), new SqlParameter("@Memo",info.Memo) }; //param[0].Direction = ParameterDirection.InputOutput; string SQL = @"INSERT INTO [Courses] ( CID , CName , Name , Type , Year , Cate , Sort , Teacher , ActMinutes , Length , Tag , Memo) VALUES ( @CID, @CName , @Name , @Type , @Year , @Cate , @Sort , @Teacher , @ActMinutes , @Length , @Tag , @Memo)"; var r = SqlHelper.ExecuteNonQuery(SqlHelper.Local, CommandType.Text, SQL, param); m.Code = 0; // m.Value = Convert.ToInt32(param[0].Value); } catch (Exception ex) { m.Code = 300; m.Message = ex.Message; log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } return m; }
public ActionResult ImportCs2(string sCName) { var rl = new List<R>(); try { string FolderPath = ConfigurationManager.AppSettings.Get("ContentRoot"); var di = new DirectoryInfo(FolderPath); var dii = di.GetDirectories(sCName); foreach (var d in dii) { var r = new R(); string filename = Path.Combine(FolderPath, d.Name + "\\imsmanifest.xlsx"); if (System.IO.File.Exists(filename)) { var course = new Courses(); course.CName = d.Name; r = Import.Courses(filename, course, true); } else { r.Code = 101; r.Message = string.Format("File Not Found:{0}", filename); } rl.Add(r); } } catch (Exception ex) { log.Warn("{0},{1}", ex.Message, ex.StackTrace); var r = new R(); r.Code = 300; r.Message = ex.Message; rl.Add(r); } return Json(rl); }
public static Courses Courses(int CID,int MID,int Year,int Type) { var m = new Courses(); try { SqlParameter[] param = { new SqlParameter("@CID",CID), new SqlParameter("@MID",CID), new SqlParameter("@Year",CID), new SqlParameter("@Type",CID) }; var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_Courses", param); if (dr.Read()) { m.CID = CID; m.CName = Convert.ToString(dr["CName"]); m.Name = Convert.ToString(dr["Name"]); m.Type = Convert.ToInt32(dr["Type"]); m.Year = Convert.ToInt32(dr["Year"]); m.Cate = Convert.ToInt32(dr["CateX"]); m.Sort = Convert.ToInt32(dr["Sort"]); m.Teacher = Convert.ToString(dr["Teacher"]); m.Length = Convert.ToDecimal(dr["Length"]); m.Memo = Convert.ToString(dr["Memo"]); } dr.Close(); } catch (Exception ex) { log.Fatal("{0},{1}", ex.Message, ex.StackTrace); } return m; }
public static List<Courses> CoursesList(int Year,int Type) { var l = new List<Courses>(); try { SqlParameter[] param = { new SqlParameter("@Year",Year), new SqlParameter("@Type",Type) }; var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_CoursesList", param); while (dr.Read()) { var m = new Courses(); m.CID = Convert.ToInt32(dr["CID"]); m.Name = Convert.ToString(dr["Name"]); //m.Second = Convert.ToInt32(dr["Second"]); //m.Minutes = Convert.ToInt32(dr["Minutes"]); //m.Status = Convert.ToInt32(dr["Status"]); if (DBNull.Value != dr["Cate"]) m.Cate = Convert.ToInt32(dr["Cate"]); if (DBNull.Value != dr["Sort"]) m.Sort = Convert.ToInt32(dr["Sort"]); if (DBNull.Value != dr["Teacher"]) m.Teacher = Convert.ToString(dr["Teacher"]); if (DBNull.Value != dr["Length"]) m.Length = Convert.ToDecimal(dr["Length"]); m.Type = Convert.ToInt32(dr["Type"]); l.Add(m); } dr.Close(); } catch (Exception ex) { log.Fatal(ex.Message); log.Fatal(ex.StackTrace); } return l; }
public static R UpdateC(Courses c) { var m = new R(); try { string SQL = @"UPDATE [Courses] SET [Type] = @Type ,[Year] = @Year ,[Cate] = @Cate ,[Sort] = @Sort ,[Teacher] = @Teacher ,[ActMinutes] = @ActMinutes ,[Length] = @Length ,[Memo] = @Memo WHERE [CID] = @CID"; SqlParameter[] param = { new SqlParameter("@CID",c.CID), new SqlParameter("@Type",c.Type), new SqlParameter("@Year",c.Year), new SqlParameter("@Cate",c.Cate), new SqlParameter("@Sort",c.Sort), new SqlParameter("@ActMinutes",c.ActMinutes), new SqlParameter("@Teacher",c.Teacher), new SqlParameter("@Length",c.Length), new SqlParameter("@Memo",c.Memo) }; var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.Text, SQL, param); m.Code = 0; m.Value = 0; m.Message = "sucess"; } catch (Exception ex) { m.Code = 300; m.Message = ex.Message; log.Fatal(ex.Message); log.FatalException(ex.Message, ex); } 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; }