public int ModifyTeteShopItem(TeteShopItemInfo teteshopitem) { string sql = "update TeteShopItem set cateid=@cateid,itemid=@itemid,itemname=@itemname,picurl=@picurl,linkurl=@linkurl,nick=@nick,price=@price where id=@id"; SqlParameter[] param = CreateParameter(teteshopitem); return(DBHelper.ExecuteNonQuery(sql, param)); }
public int AddTeteShopItem(TeteShopItemInfo teteshopitem) { string sql = "insert TeteShopItem values(@cateid,@itemid,@itemname,@picurl,@linkurl,@nick,@price)"; SqlParameter[] param = CreateParameter(teteshopitem); return(DBHelper.ExecuteNonQuery(sql, param)); }
private static void InitItem(string nick, GoodsInfo cinfo, TeteShopItemInfo ainfo) { ainfo.Itemid = cinfo.num_iid; ainfo.Nick = Encrypt(nick); ainfo.Price = (double)cinfo.price; ainfo.Picurl = cinfo.pic_url; ainfo.Itemname = cinfo.title; ainfo.Cateid = cinfo.seller_cids; ainfo.Linkurl = "http://item.taobao.com/item.htm?id=" + ainfo.Itemid; }
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); //} }
private SqlParameter[] CreateParameter(TeteShopItemInfo teteshopitem) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@id", teteshopitem.Id), new SqlParameter("@cateid", teteshopitem.Cateid), new SqlParameter("@itemid", teteshopitem.Itemid), new SqlParameter("@itemname", teteshopitem.Itemname), new SqlParameter("@picurl", teteshopitem.Picurl), new SqlParameter("@linkurl", teteshopitem.Linkurl), new SqlParameter("@nick", teteshopitem.Nick), new SqlParameter("@price", teteshopitem.Price) }; return(param); }
private IList <TeteShopItemInfo> TeteShopItemPropertity(string sql, params SqlParameter[] param) { DataTable dt = DBHelper.ExecuteDataTable(sql, param); IList <TeteShopItemInfo> list = new List <TeteShopItemInfo>(); foreach (DataRow dr in dt.Rows) { TeteShopItemInfo teteshopitem = new TeteShopItemInfo(); teteshopitem.Id = Convert.ToInt32(dr["id"]); teteshopitem.Cateid = Convert.ToString(dr["cateid"]); teteshopitem.Itemid = Convert.ToString(dr["itemid"]); teteshopitem.Itemname = Convert.ToString(dr["itemname"]); teteshopitem.Picurl = Convert.ToString(dr["picurl"]); teteshopitem.Linkurl = Convert.ToString(dr["linkurl"]); teteshopitem.Nick = Convert.ToString(dr["nick"]); teteshopitem.Price = Convert.ToDouble(dr["price"]); list.Add(teteshopitem); } return(list); }