public void Insert(SearchCondition condition)
{
CampusSearchLog log = new CampusSearchLog();
log.keyword = condition.KeyWord;
log.major = condition.MajorCategory;
log.location = condition.JobLocation;
log.publishtime = condition.JobDateTime;
log.jobtype = condition.JobType;
log.occupation = condition.OccupationCategory;
this.Insert(log);
}
public void Insert(CampusSearchLog log)
{
log.otherkey = "";
log.user_ip = ServerParams.ClientIP;
log.user_software = ServerParams.ClientSoftWare;
log.user_language = ServerParams.ClientLanguage;
log.url_other_param = ServerParams.UrlParam;
log.user_cookie = ServerParams.Cookie != null ? ServerParams.Cookie : " ";
if (log.user_cookie.Length >= 255)
{
log.user_cookie = log.user_cookie.Substring(0, 255);
}
IDatabase db = DataManager.CampusDB();
string strSQL = "INSERT INto campus_job_search_log(user_id, keyword, major, location, publishtime, jobtype, occupation, otherkey, user_ip, user_software, user_cookie, url_other_param, user_language)"
+ " VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}')";
strSQL = String.Format(strSQL, log.user_id, log.keyword, log.major, log.location, log.publishtime, log.jobtype, log.occupation, log.otherkey, log.user_ip, log.user_software, log.user_cookie, log.url_other_param, log.user_language);
db.Execute(strSQL);
}