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);
}
