public static DataTable GetUserBrowseHistory(UserbrowsehistoryInfo browserhistory)
{
DataTable dtScanHistorys = HiCache.Get("DataCache-UserScanHistroys") as DataTable;
if (dtScanHistorys == null)
{
dtScanHistorys = new UserbrowsehistoryDao().GetUserBrowseHistory(browserhistory);
HiCache.Insert("DataCache-UserScanHistroys", dtScanHistorys);
}
return(dtScanHistorys);
}
public UserbrowsehistoryInfo GetUserBrowseHistory(int historyId)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_UserBrowseHistory WHERE HistoryId = @HistoryId");
this.database.AddInParameter(sqlStringCommand, "HistoryId", DbType.Int32, historyId);
UserbrowsehistoryInfo result = null;
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToModel <UserbrowsehistoryInfo>(dataReader);
}
return(result);
}
public static void SetUserBrowseHistory(UserbrowsehistoryInfo browserhistory)
{
DataTable dtScanHistorys = HiCache.Get("DataCache-UserScanHistroys") as DataTable;
if (dtScanHistorys == null)
{
dtScanHistorys = new DataTable();
dtScanHistorys.Columns.Add("ProductId", typeof(System.Int32));
dtScanHistorys.Columns.Add("UserId", typeof(System.Int32));
dtScanHistorys.Columns.Add("UserName", typeof(System.String));
dtScanHistorys.Columns.Add("BrowseTime", typeof(System.DateTime));
dtScanHistorys.Columns.Add("UserIP", typeof(System.String));
dtScanHistorys.Columns.Add("Description", typeof(System.String));
dtScanHistorys.Columns.Add("Sort", typeof(System.Int32));
dtScanHistorys.Columns.Add("Url", typeof(System.String));
dtScanHistorys.Columns.Add("BrowerTimes", typeof(System.Int32));
dtScanHistorys.Columns.Add("PlatType", typeof(System.Int32));
dtScanHistorys.Columns.Add("IP", typeof(System.Int64));
dtScanHistorys.Columns.Add("CategoryId", typeof(System.Int32));
}
if (dtScanHistorys.Rows.Count >= 2)
{
new UserbrowsehistoryDao().BulkUserBrowserHistory(dtScanHistorys);
dtScanHistorys.Rows.Clear();
}
DataRow row = dtScanHistorys.NewRow();
row["ProductId"] = browserhistory.ProductId;
row["UserId"] = browserhistory.UserId;
row["UserName"] = browserhistory.UserName ?? "";
row["BrowseTime"] = browserhistory.BrowseTime ?? DateTime.Now;
row["UserIP"] = browserhistory.UserIP ?? "";
row["Description"] = browserhistory.Description ?? "";
row["Sort"] = browserhistory.Sort;
row["Url"] = browserhistory.Url ?? "";
row["BrowerTimes"] = 1;
row["PlatType"] = browserhistory.PlatType;
row["IP"] = browserhistory.Ip;
row["CategoryId"] = browserhistory.CategoryId;
dtScanHistorys.Rows.Add(row);
new UserbrowsehistoryDao().BulkUserBrowserHistory(dtScanHistorys);
//HiCache.Insert("DataCache-UserScanHistroys", dtScanHistorys);
}
public DataTable GetUserBrowseHistory(UserbrowsehistoryInfo browserhistory)
{
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_UserBrowseHistoryAdd");
this.database.AddInParameter(storedProcCommand, "PlatType", DbType.Int32, browserhistory.PlatType);
this.database.AddInParameter(storedProcCommand, "ProductId", DbType.Int32, browserhistory.ProductId);
this.database.AddInParameter(storedProcCommand, "Url", DbType.String, browserhistory.Url);
this.database.AddInParameter(storedProcCommand, "UserName", DbType.String, browserhistory.UserName);
this.database.AddInParameter(storedProcCommand, "UserId", DbType.Int32, browserhistory.UserId);
this.database.AddInParameter(storedProcCommand, "UserIP", DbType.String, browserhistory.UserIP);
this.database.AddInParameter(storedProcCommand, "IP", DbType.Int64, browserhistory.Ip);
//return this.database.ExecuteNonQuery(storedProcCommand) == 1;返回bool类型
DataTable historyinfo = null;
using (IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
historyinfo = DataHelper.ConverDataReaderToDataTable(dataReader);
}
return(historyinfo);
}
