private Dictionary<int, NoticeModel> GetSqlcNotice(DataTable table) { Dictionary<int, NoticeModel> dic = new Dictionary<int, NoticeModel>(); foreach (DataRow dr in table.Rows) { NoticeModel noticemodel = new NoticeModel(); noticemodel.NoticeTitle = dr["Title"].ToString(); noticemodel.NoticeAuthor = dr["Author"].ToString(); noticemodel.NoticeID = Int32.Parse(dr["ID"].ToString()); noticemodel.NoticeContent = dr["Content"].ToString(); noticemodel.NoticeUpdateTime = ((DateTime)dr["Update_Time"]).ToString("yyyy/MM/dd HH:mm:ss.fff "); noticemodel.NoticeTime = dr["NoticeTime"].ToString(); noticemodel.NoticeType = dr["FileType"].ToString(); bool judge = bool.Parse(dr["IsFull"].ToString()); if (judge) { noticemodel.NoticeFullScreen = "1"; } else { noticemodel.NoticeFullScreen = "0"; } noticemodel.NoticeStarTime = dr["StartTime"].ToString(); noticemodel.NoticeEndTime = dr["Endtime"].ToString(); noticemodel.NoticePath = dr["FilePath"].ToString(); noticemodel.NoticeUri = dr["FileName"].ToString(); dic.Add(Int32.Parse(dr["ID"].ToString()), noticemodel); } return dic; }
private void LoadSavePath(NoticeModel model, string WebSit) { string SavePath = string.Empty; SavePath = model.NoticePath; switch (model.NoticeType) { case "2": SavePath = LoadPath + @"\Image\" + SavePath; DownLoad(WebSit, SavePath); break; case "3": SavePath = LoadPath + @"\Video\" + SavePath; DownLoad(WebSit, SavePath); break; case "4": SavePath = LoadPath + @"\Flash\" + SavePath; DownLoad(WebSit, SavePath); break; default: break; } }
private DbParameter[] ExecutionSelectNotice(NoticeModel DataPar) { string WebSit = WebPath + DataPar.NoticePath; DataPar.NoticePath = DataPar.NoticePath.Substring(DataPar.NoticePath.LastIndexOf('/') + 1); DbParameter[] sqliteparList = new DbParameter[13]; sqliteparList[0] = Db_Sqlite.CreateDbParameter("@UpdateTime", DataPar.NoticeUpdateTime); sqliteparList[1] = Db_Sqlite.CreateDbParameter("@Id", DataPar.NoticeID); sqliteparList[2] = Db_Sqlite.CreateDbParameter("@Author", DataPar.NoticeAuthor); sqliteparList[3] = Db_Sqlite.CreateDbParameter("@Content", DataPar.NoticeContent); sqliteparList[4] = Db_Sqlite.CreateDbParameter("@EndTime", DataPar.NoticeEndTime); sqliteparList[5] = Db_Sqlite.CreateDbParameter("@FullScreen", DataPar.NoticeFullScreen); sqliteparList[6] = Db_Sqlite.CreateDbParameter("@Path", DataPar.NoticePath); sqliteparList[7] = Db_Sqlite.CreateDbParameter("@StartTime", DataPar.NoticeStarTime); sqliteparList[8] = Db_Sqlite.CreateDbParameter("@NoticeTime", DataPar.NoticeTime); sqliteparList[9] = Db_Sqlite.CreateDbParameter("@Title", DataPar.NoticeTitle); sqliteparList[10] = Db_Sqlite.CreateDbParameter("@Type", DataPar.NoticeType); sqliteparList[11] = Db_Sqlite.CreateDbParameter("@Used", 1); sqliteparList[12] = Db_Sqlite.CreateDbParameter("@Uri", DataPar.NoticeUri); if (DataPar.NoticePath != null && DataPar.NoticePath != string.Empty) { LoadSavePath(DataPar, WebSit); } return sqliteparList; }