private static SqlParameter[] CreateParameter(GoodPingInfo info)
{
SqlParameter[] param = new[]
{
new SqlParameter("@Nick", info.Nick),
new SqlParameter("@PingTimes", info.PingTimes),
new SqlParameter("@PingDate", info.PingDate),
new SqlParameter("@AddIP", info.AddIP)
};
return(param);
}
public IList <GoodPingInfo> GetGoodPingByNick(string nick)
{
IList <GoodPingInfo> list = new List <GoodPingInfo>();
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_BY_NICK, new SqlParameter("@Nick", nick));
foreach (DataRow dr in dt.Rows)
{
GoodPingInfo info = new GoodPingInfo();
info.Nick = dr["Nick"].ToString();
info.PingTimes = int.Parse(dr["PingTimes"].ToString());
info.PingDate = DateTime.Parse(dr["PingDate"].ToString());
info.AddIP = dr["AddIP"].ToString();
list.Add(info);
}
return(list);
}
public int UpdatePingInfo(GoodPingInfo info)
{
return(DBHelper.ExecuteNonQuery(SQL_UPDATE, CreateParameter(info)));
}
public int InsertGoodPing(GoodPingInfo info)
{
return(DBHelper.ExecuteNonQuery(SQL_INSERT, CreateParameter(info)));
}
protected void Btn_AddAds_Click(object sender, EventArgs e)
{
if (TB_Password.Text == "tuituiguang!(**gansibangtuiguang")
{
IList <BuyInfo> list = CacheCollection.GetAllBuyInfo();
if (list.Where(o => o.Nick == TB_Nick.Text.Trim()).ToList().Count > 0)
{
IList <GoodsInfo> glist = new GoodsService().SelectAllGoodsByNick(TB_Nick.Text.Trim());
if (glist.Count != 0)
{
GoodsInfo ginfo = null;
if (glist.Count == 1)
{
ginfo = glist[0];
}
else
{
ginfo = glist[new Random().Next(0, glist.Count)];
}
UserAdsInfo info = new UserAdsInfo();
info.AdsTitle = ginfo.GoodsName;
info.Id = Guid.NewGuid();
info.UserAdsState = 1;
info.AdsUrl = "http://item.taobao.com/item.htm?id=" + ginfo.GoodsId;
string cateId = ginfo.CateId;
TaoBaoGoodsClassInfo tcinfo = new TaoBaoGoodsClassService().SelectGoodsClass(cateId);
info.CateIds = ginfo.TaoBaoCId;
string cname = tcinfo == null ? "" : tcinfo.name;
info.SellCateName = GetTaoBaoCName(info.CateIds, cname);
info.AliWang = TB_Nick.Text.Trim();
info.Nick = TB_Nick.Text.Trim();
info.AdsPic = ginfo.GoodsPic;
info.Price = ginfo.GoodsPrice;
info.AddTime = DateTime.Now;
info.AdsId = GetRand(CacheCollection.GetAllAdsInfo().Where(o => o.AdsType == 1).ToList());
info.FeeId = list[0].FeeId;
info.AdsShowStartTime = DateTime.Now;
info.AdsShowFinishTime = DateTime.Now.AddDays(7);
info.UserAdsState = 1;
string taoId = info.CateIds;
info.CateIds = GetTaoBaoCId(taoId, taoId);
info.IsSend = 1; //表示是赠送的
//new UserAdsService().InsertUserAds(info);
GoodPingService pingDal = new GoodPingService();
IList <GoodPingInfo> pinginfoList = pingDal.GetGoodPingByNick(TB_Nick.Text.Trim());
if (pinginfoList.Count == 0)
{
GoodPingInfo pingInfo = new GoodPingInfo();
pingInfo.AddIP = Request.ServerVariables["REMOTE_ADDR"];
pingInfo.Nick = TB_Nick.Text.Trim();
pingInfo.PingDate = DateTime.Now;
pingInfo.PingTimes = 1;
pingDal.InsertGoodPing(pingInfo);
}
else
{
pinginfoList[0].AddIP = Request.ServerVariables["REMOTE_ADDR"];
pinginfoList[0].PingDate = DateTime.Now;
pinginfoList[0].PingTimes = pinginfoList[0].PingTimes + 1;
pingDal.UpdatePingInfo(pinginfoList[0]);
}
Page.RegisterStartupScript("恭喜", "<script>alert('赠送广告成功');</script>");
Response.Redirect("/SendUserAds.aspx");
}
}
else
{
Page.RegisterStartupScript("Error", "<script>alert('没有购买记录');</script>");
}
}
}