public override bool Insert(HistoryUserLogBrowseVO m) { CodeCommand command = new CodeCommand(); command.CommandText = INSERT; command.Parameters.Add(new SqlParameter() { ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@PvCount", Value = ParameterHelper.ConvertValue(m.PvCount) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@UvCount", Value = ParameterHelper.ConvertValue(m.UvCount) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@IpCount", Value = ParameterHelper.ConvertValue(m.IpCount) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@Price", Value = ParameterHelper.ConvertValue(m.Price) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId) }); int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command); if (result >= 1) { return(true); } return(false); }
public override int InsertIdentityId(HistoryUserLogBrowseVO m) { CodeCommand command = new CodeCommand(); command.CommandText = INSERT + "; select @@Identity"; command.Parameters.Add(new SqlParameter() { ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@PvCount", Value = ParameterHelper.ConvertValue(m.PvCount) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@UvCount", Value = ParameterHelper.ConvertValue(m.UvCount) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@IpCount", Value = ParameterHelper.ConvertValue(m.IpCount) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@Price", Value = ParameterHelper.ConvertValue(m.Price) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate) }); command.Parameters.Add(new SqlParameter() { ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId) }); var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command); return(int.Parse(result.ToString())); }
/// <summary> /// 汇总相关数据 /// </summary> /// <param name="time"></param> public void SummaryHistoryUserLogBrowse(DateTime time) { string timeid = time.ToString("yyyyMMdd"); string cmd = @"select time,adid,aduserid,count(*) pvcount,count(distinct(clientid)) uvcount,count(distinct(clientip)) ipcount from LogBrowseHistory where Time=$TIME$ group by time,adid,aduserid order by adid"; //替换汇总时间 cmd = cmd.Replace("$TIME$", timeid); ChartPara cp = new ChartPara(); cp.CommandText = cmd; DataTable table = m_acc.GetTable(cp); //获取所有的广告信息,获取相关的价格信息 var list = AdPageInfoBLL.Instance.GetModels(new AdPageInfoPara()); for (int i = 0; i < table.Rows.Count; i++) { HistoryUserLogBrowseVO his = new HistoryUserLogBrowseVO(); his.AdId = int.Parse(table.Rows[i]["adid"].ToString()); his.CreateUserId = 0; his.CreateDate = DateTime.Now; his.IpCount = int.Parse(table.Rows[i]["ipcount"].ToString()); his.UvCount = int.Parse(table.Rows[i]["uvcount"].ToString()); his.PvCount = int.Parse(table.Rows[i]["pvcount"].ToString()); his.UserId = int.Parse(table.Rows[i]["aduserid"].ToString()); his.Time = int.Parse(timeid); var adinfo = list.SingleOrDefault(p => p.Id == his.AdId); if (adinfo != null) { his.Price = adinfo.Money; his.Money = his.Price * his.IpCount; } HistoryUserLogBrowseBLL.Instance.Add(his); } }
public override string GetOtherConditionByModel(HistoryUserLogBrowseVO m) { return(""); }
public override string GetOrderByModel(HistoryUserLogBrowseVO m) { return(""); }