示例#1
0
 public void UpdateAdRecord(AdRecordInfo adRecord)
 {
     SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@page", SqlDbType.NVarChar) };
     pt[0].Value = adRecord.ID;
     pt[1].Value = adRecord.Page;
     ShopMssqlHelper.ExecuteNonQuery(ShopMssqlHelper.TablePrefix + "UpdateAdRecord", pt);
 }
示例#2
0
        public static void UpdateAdRecord(AdRecordInfo adRecord)
        {
            AdRecordInfo info = ReadAdRecord(adRecord.ID, 0);

            dal.UpdateAdRecord(adRecord);
            if (adRecord.AdID != info.AdID)
            {
                AdBLL.ChangeAdCount(info.AdID, ChangeAction.Minus);
                AdBLL.ChangeAdCount(adRecord.AdID, ChangeAction.Plus);
            }
        }
示例#3
0
 public int AddAdRecord(AdRecordInfo adRecord)
 {
     SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@adID", SqlDbType.Int), new SqlParameter("@iP", SqlDbType.NVarChar), new SqlParameter("@date", SqlDbType.DateTime), new SqlParameter("@page", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) };
     pt[0].Value = adRecord.AdID;
     pt[1].Value = adRecord.IP;
     pt[2].Value = adRecord.Date;
     pt[3].Value = adRecord.Page;
     pt[4].Value = adRecord.UserID;
     pt[5].Value = adRecord.UserName;
     return(Convert.ToInt32(ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddAdRecord", pt)));
 }
示例#4
0
 public void PrepareAdRecordModel(SqlDataReader dr, List <AdRecordInfo> adRecordList)
 {
     while (dr.Read())
     {
         AdRecordInfo item = new AdRecordInfo();
         item.ID       = dr.GetInt32(0);
         item.AdID     = dr.GetInt32(1);
         item.IP       = dr[2].ToString();
         item.Date     = dr.GetDateTime(3);
         item.Page     = dr[4].ToString();
         item.UserID   = dr.GetInt32(5);
         item.UserName = dr[6].ToString();
         adRecordList.Add(item);
     }
 }
示例#5
0
        /// <summary>
        /// 页面加载
        /// </summary>
        protected override void PageLoad()
        {
            base.PageLoad();
            string       url      = RequestHelper.GetQueryString <string>("URL");
            AdRecordInfo adRecord = new AdRecordInfo();

            adRecord.AdID     = RequestHelper.GetQueryString <int>("AdID");
            adRecord.IP       = ClientHelper.IP;
            adRecord.Date     = RequestHelper.DateNow;
            adRecord.Page     = Request.ServerVariables["HTTP_REFERER"];
            adRecord.UserID   = base.UserID;
            adRecord.UserName = base.UserName;
            AdRecordBLL.AddAdRecord(adRecord);
            ResponseHelper.Redirect(url);
        }
示例#6
0
        public AdRecordInfo ReadAdRecord(int id, int userID)
        {
            SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@id", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int) };
            pt[0].Value = id;
            pt[1].Value = userID;
            AdRecordInfo info = new AdRecordInfo();

            using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadAdRecord", pt))
            {
                if (reader.Read())
                {
                    info.ID       = reader.GetInt32(0);
                    info.AdID     = reader.GetInt32(1);
                    info.IP       = reader[2].ToString();
                    info.Date     = reader.GetDateTime(3);
                    info.Page     = reader[4].ToString();
                    info.UserID   = reader.GetInt32(5);
                    info.UserName = reader[6].ToString();
                }
            }
            return(info);
        }
示例#7
0
 public static int AddAdRecord(AdRecordInfo adRecord)
 {
     adRecord.ID = dal.AddAdRecord(adRecord);
     AdBLL.ChangeAdCount(adRecord.AdID, ChangeAction.Plus);
     return(adRecord.ID);
 }