private SetModel GetSetModel(DataTable table)
{
SetModel setmodel = new SetModel();
if (table == null || table.Rows.Count == 0) return null;
setmodel.SetID = Int32.Parse(table.Rows[0]["Id"].ToString());
setmodel.SetIdelTime = table.Rows[0]["SysIdleTime"].ToString();
setmodel.SetNoticeShowTime = table.Rows[0]["PostShowTime"].ToString();
setmodel.SetUpdateTime = ((DateTime)table.Rows[0]["Updatetime"]).ToString("yyyy/MM/dd HH:mm:ss.fff ");
WebPath = table.Rows[0]["URL"].ToString();
return setmodel;
}
private DbParameter[] ExecutionSelectSet(SetModel DataPar)
{
DbParameter[] sqliteparList = new DbParameter[4];
sqliteparList[0] = Db_Sqlite.CreateDbParameter("@UpdateTime", DataPar.SetUpdateTime);
sqliteparList[1] = Db_Sqlite.CreateDbParameter("@Id", DataPar.SetID);
sqliteparList[2] = Db_Sqlite.CreateDbParameter("@IdleTime", DataPar.SetIdelTime);
sqliteparList[3] = Db_Sqlite.CreateDbParameter("@NoticeShowTime", DataPar.SetNoticeShowTime);
return sqliteparList;
}
