public void WriteWebInfo(WebInfo webinfo)
{
string insertQuery = String.Format("insert into [{0}] ({1},{2}) values(@name,@host)",
ConstPR.webInfoName, ConstPR.name, ConstPR.host);
SQLiteParameter[] parameters = new SQLiteParameter[2];
parameters[0] = new SQLiteParameter("@name", webinfo.Name);
parameters[1] = new SQLiteParameter("@host", webinfo.Host);
try
{
sqliteHelper.Execute(insertQuery, parameters);
log.Info(String.Format("insert {0} record into DB success.",ConstPR.webInfoName));
}
catch (Exception ex)
{
log.ErrorException(String.Format("insert {0} record into DB failed.",ConstPR.webInfoName), ex);
}
}
public List<WebInfo> LoadWebInfo()
{
string QueryWebInfo = QueryHelper.GetInstance().GetQueryCommand("", "QueryWebInfo");
try
{
DataSet ds = sqliteHelper.GetDs(QueryWebInfo);
if (ds != null && ds.Tables != null && ds.Tables.Count > 0)
{
List<WebInfo> webList = new List<WebInfo>();
foreach (DataRow record in ds.Tables[0].Rows)
{
WebInfo webinfo = new WebInfo();
webinfo.Id = record[ConstPR.ID].ToString();
webinfo.Name = record[ConstPR.name].ToString();
webinfo.Host = record[ConstPR.host].ToString();
webinfo.GroupName = record[ConstPR.groupName].ToString();
WebHeaders headers = new WebHeaders();
headers.Accept = record[ConstPR.accept].ToString();
headers.AcceptEncoding = record[ConstPR.acceptEncoding].ToString();
headers.AcceptLanguage = record[ConstPR.acceptLanguage].ToString();
headers.UserAgent = record[ConstPR.userAgent].ToString();
headers.ContentType = record[ConstPR.contentType].ToString();
headers.ContentLength = record[ConstPR.contentLength].ToString();
headers.Connection = record[ConstPR.connection].ToString();
headers.Cookie = record[ConstPR.cookie].ToString();
webinfo.Headers = headers;
webList.Add(webinfo);
}
return webList;
}
}
catch (Exception ex)
{
log.ErrorException(String.Format("Load {0} failed", ConstPR.webInfoName), ex);
}
return null;
}