private static void ActionGoods(string nick, string session, TeteShopInfo info)
{
TeteShopItemService itemDal = new TeteShopItemService();
List <GoodsInfo> glist = TaoBaoAPI.GetGoodsInfoListByNick(info.Short, session, info.Appkey, info.Appsecret);
IList <TeteShopItemInfo> itemList = itemDal.GetAllTeteShopItem(Encrypt(nick));
List <TeteShopItemInfo> addList = new List <TeteShopItemInfo>();
List <TeteShopItemInfo> upList = new List <TeteShopItemInfo>();
foreach (GoodsInfo cinfo in glist)
{
List <TeteShopItemInfo> clist = itemList.Where(o => o.Itemid == cinfo.num_iid).ToList();
if (clist.Count > 0)
{
InitItem(nick, cinfo, clist[0]);
upList.Add(clist[0]);
}
else
{
TeteShopItemInfo ainfo = new TeteShopItemInfo();
InitItem(nick, cinfo, ainfo);
addList.Add(ainfo);
}
}
//添加
foreach (TeteShopItemInfo cinfo in addList)
{
itemDal.AddTeteShopItem(cinfo);
}
//修改
foreach (TeteShopItemInfo cinfo in upList)
{
itemDal.ModifyTeteShopItem(cinfo);
}
//删除
//List<TeteShopItemInfo> delList = new List<TeteShopItemInfo>();
//foreach (TeteShopItemInfo cinfo in itemList)
//{
// if (upList.Where(o => o.Itemid == cinfo.Itemid).ToList().Count == 0)
// {
// delList.Add(cinfo);
// }
//}
//foreach (TeteShopItemInfo cinfo in upList)
//{
// itemDal.DeleteTeteShopItem(cinfo.Id);
//}
}
public int UpdateShopInfo(TeteShopInfo info)
{
SqlParameter[] param = new[]
{
new SqlParameter("@ads", info.Ads),
new SqlParameter("@logo", info.Logo),
new SqlParameter("@guid", info.Guid)
};
return(DBHelper.ExecuteNonQuery(SQL_UPDATE, param));
}
public int InsertShop(TeteShopInfo info)
{
SqlParameter[] param = new[]
{
new SqlParameter("@guid", Guid.NewGuid()),
new SqlParameter("@nick", info.Nick),
new SqlParameter("@short", info.Short),
new SqlParameter("@appkey", info.Appkey),
new SqlParameter("@appsecret", info.Appsecret),
new SqlParameter("@session", info.Session),
new SqlParameter("@adddate", info.Adddate)
};
return(DBHelper.ExecuteNonQuery(SQL_INSERT, param));
}
public TeteShopInfo GetShopInfo(string nick)
{
TeteShopInfo info = null;
SqlParameter param = new SqlParameter("@nick", nick);
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_BY_NICK, param);
foreach (DataRow dr in dt.Rows)
{
info = new TeteShopInfo();
info.Guid = new Guid(dr["guid"].ToString());
info.Logo = dr["logo"] == DBNull.Value ? "" : dr["logo"].ToString();
info.Ads = dr["ads"] == DBNull.Value ? "" : dr["ads"].ToString();
info.Appsecret = dr["appsecret"].ToString();
info.Appkey = dr["appkey"].ToString();
}
return(info);
}
protected override void InitializeCulture()
{
string msg = "尊敬的用户您好，非常抱歉的告诉您，您尚未订购该功能，如需继续使用请购买该服务:<br><br>9元/月 <a href=' http://fuwu.taobao.com/item/subsc.htm?items=service-0-22762-6:1;' target='_blank'>立即购买</a><br>";
if (!string.IsNullOrEmpty(Request.QueryString["nick"]) && !string.IsNullOrEmpty(Request.QueryString["nicksession"]) && !string.IsNullOrEmpty(Request.QueryString["mobile"]))
{
HttpCookie cookie = new HttpCookie("nick", HttpUtility.UrlEncode(Request.QueryString["nick"]));
cookie.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
HttpCookie cookieSe = new HttpCookie("nicksession", Request.QueryString["nicksession"]);
cookieSe.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookieSe);
HttpCookie cookieM = new HttpCookie("mobile", Request.QueryString["nicksession"]);
cookieM.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookieM);
TeteShopService tss = new TeteShopService();
if (CacheCollection.GetNickSessionList().Where(o => o.Short == Request.QueryString["nick"]).ToList().Count == 0)
{
TeteShopInfo info = new TeteShopInfo();
info.Nick = Encrypt(Request.QueryString["nick"]);
info.Session = Request.QueryString["nicksession"];
info.Short = Request.QueryString["nick"];
info.Adddate = DateTime.Now;
info.Appkey = "12132145";
info.Appsecret = "1fdd2aadd5e2ac2909db2967cbb71e7f";
tss.InsertShop(info);
CacheCollection.RemoveCacheByKey(CacheCollection.KEY_ALLNICKSESSIONINFO);
}
}
else
{
if (Request.Cookies["nick"] == null || Request.Cookies["nicksession"] == null || Request.Cookies["mobile"] == null)
{
Response.Redirect("http://www.7fshop.com/top/market/buy.aspx?msg=" + msg);
}
}
//else
//{
// Session["nick"] = Request.Cookies["nick"].Value;
// Session["session"] = Request.Cookies["nicksession"].Value;
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
TeteShopInfo info = tsDal.GetShopInfo(nick);
if (info == null)
{
Page.RegisterStartupScript("错误", "<script>alert('您的身份不合法，请确定您已购买!');</script>");
return;
}
Tb_Ads.Text = info.Ads;
Tb_Logo.Text = info.Logo;
ViewState["guid"] = info.Guid;
}
}
public IList <TeteShopInfo> GetAllShopInfo()
{
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT);
IList <TeteShopInfo> list = new List <TeteShopInfo>();
foreach (DataRow dr in dt.Rows)
{
TeteShopInfo info = new TeteShopInfo();
info.Nick = dr["nick"].ToString();
info.Appkey = dr["appkey"].ToString();
info.Appsecret = dr["appsecret"].ToString();
info.Session = dr["session"].ToString();
info.Short = dr["short"].ToString();
list.Add(info);
}
return(list);
}
protected void Btn_Up_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Tb_Ads.Text.Trim()))
{
Page.RegisterStartupScript("提示", "<script>alert('请输入Ads链接地址!');</script>");
return;
}
if (string.IsNullOrEmpty(Tb_Logo.Text.Trim()))
{
Page.RegisterStartupScript("提示", "<script>alert('请输入Logo链接地址!');</script>");
return;
}
TeteShopInfo info = new TeteShopInfo();
info.Guid = new Guid(ViewState["guid"].ToString());
info.Ads = Tb_Ads.Text.Trim();
info.Logo = Tb_Logo.Text.Trim();
tsDal.UpdateShopInfo(info);
Page.RegisterStartupScript("提示", "<script>alert('更新成功!');</script>");
}
protected void Btn_Update_Click(object sender, EventArgs e)
{
string nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
string session = Request.Cookies["nicksession"].Value;
TeteShopCategoryService cateDal = new TeteShopCategoryService();
IList <TeteShopInfo> list = CacheCollection.GetNickSessionList().Where(o => o.Short == nick && o.Session == session).ToList();
TeteShopInfo info = null;
if (list.Count > 0)
{
info = list[0];
}
if (info == null)
{
Page.RegisterStartupScript("错误", "<script>alert('您的身份不合法，请确定您已购买!');</script>");
return;
}
IList <TeteShopCategoryInfo> cateList = cateDal.GetAllTeteShopCategory(Encrypt(nick));
IList <GoodsClassInfo> classList = TaoBaoAPI.GetGoodsClassInfoList(info.Short, session, info.Appkey, info.Appsecret);
if (classList == null)
{
Page.RegisterStartupScript("错误", "<script>alert('获取店铺分类出错!');</script>");
return;
}
List <TeteShopCategoryInfo> addList = new List <TeteShopCategoryInfo>();
List <TeteShopCategoryInfo> upList = new List <TeteShopCategoryInfo>();
foreach (GoodsClassInfo cinfo in classList)
{
List <TeteShopCategoryInfo> clist = cateList.Where(o => o.Cateid == cinfo.cid).ToList();
if (clist.Count > 0)
{
InitCate(nick, cinfo, clist[0]);
clist[0].Catecount = classList.Count(o => o.parent_cid == cinfo.cid);
upList.Add(clist[0]);
}
else
{
TeteShopCategoryInfo ainfo = new TeteShopCategoryInfo();
InitCate(nick, cinfo, ainfo);
ainfo.Catecount = classList.Count(o => o.parent_cid == cinfo.cid);
addList.Add(ainfo);
}
}
//添加
foreach (TeteShopCategoryInfo cinfo in addList)
{
cateDal.AddTeteShopCategory(cinfo);
}
//修改
foreach (TeteShopCategoryInfo cinfo in upList)
{
cateDal.ModifyTeteShopCategory(cinfo);
}
//删除
//List<TeteShopCategoryInfo> delList = new List<TeteShopCategoryInfo>();
//foreach (TeteShopCategoryInfo cinfo in cateList)
//{
// if (upList.Where(o => o.Cateid == cinfo.Cateid).ToList().Count == 0)
// {
// delList.Add(cinfo);
// }
//}
//foreach (TeteShopCategoryInfo cinfo in upList)
//{
// cateDal.DeleteTeteShopCategory(cinfo.Id);
//}
//更新商品
ActionGoods(nick, session, info);
//更新商品分类包含商品数量
IList <TeteShopCategoryInfo> nowCateList = cateDal.GetAllTeteShopCategory(Encrypt(nick));
TeteShopItemService itemDal = new TeteShopItemService();
for (int i = 0; i < nowCateList.Count; i++)
{
int count = itemDal.GetItemCountByCId(nowCateList[i].Cateid);
nowCateList[i].Catecount = count;
}
//修改
foreach (TeteShopCategoryInfo cinfo in nowCateList)
{
cateDal.ModifyTeteShopCategory(cinfo);
}
Page.RegisterStartupScript("更新提示", "<script>alert('更新成功!');</script>");
}