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