/// <summary> /// 获取店铺信息 /// </summary> /// <param name="UserId"></param> /// <param name="ScoreId"></param> /// <returns></returns> internal tbShopInfo GetInfoFromTb(string NickName, int ScoreId) { tbShopInfo shopinfo = new tbShopInfo(); ITopClient client = new DefaultTopClient(StaticSystemConfig.soft.ApiURL, StaticSystemConfig.soft.AppKey, StaticSystemConfig.soft.AppSecret); ShopGetRequest req = new ShopGetRequest(); req.Fields = "sid,cid,title,nick,desc,bulletin,pic_path,created,modified"; req.Nick = NickName; ShopGetResponse response = client.Execute(req); Top.Api.Domain.Shop shop = response.Shop; shopinfo.Bulletin = shop.Bulletin; shopinfo.CateId = (int)shop.Cid; shopinfo.Created = DateTime.Parse(shop.Created); shopinfo.Desc = shop.Desc; shopinfo.Modified = DateTime.Parse(shop.Modified); shopinfo.NickName = shop.Nick; shopinfo.PicPath = shop.PicPath; shopinfo.Score = new tbShopScore(); shopinfo.Score.ScoreId = ScoreId; if (shop.ShopScore != null) { shopinfo.Score.ItemScore = shop.ShopScore.ItemScore; shopinfo.Score.ServiceScore = shop.ShopScore.ServiceScore; shopinfo.Score.DeliveryScore = shop.ShopScore.DeliveryScore; } shopinfo.TbShopId = (int)shop.Sid; shopinfo.Title = shop.Title; return(shopinfo); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateShopInfo(tbShopInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbShopInfo set "); strSql.Append("TbShopId=@TbShopId,"); strSql.Append("ScoreId=@ScoreId,"); strSql.Append("CateId=@CateId,"); strSql.Append("NickName=@NickName,"); strSql.Append("Title=@Title,"); strSql.Append("[Desc]=@Desc,"); strSql.Append("Bulletin=@Bulletin,"); strSql.Append("PicPath=@PicPath,"); strSql.Append("Created=@Created,"); strSql.Append("Modified=@Modified"); strSql.Append(" where ShopId=@ShopId"); SqlParameter[] parameters = { new SqlParameter("@TbShopId", SqlDbType.Int, 4), new SqlParameter("@ScoreId", SqlDbType.Int, 4), new SqlParameter("@CateId", SqlDbType.Int, 4), new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@Desc", SqlDbType.VarChar, 500), new SqlParameter("@Bulletin", SqlDbType.VarChar, 200), new SqlParameter("@PicPath", SqlDbType.VarChar, 200), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@Modified", SqlDbType.DateTime), new SqlParameter("@ShopId", SqlDbType.Int, 4) }; parameters[0].Value = model.TbShopId; parameters[1].Value = model.Score.ScoreId; parameters[2].Value = model.CateId; parameters[3].Value = model.NickName; parameters[4].Value = model.Title; parameters[5].Value = model.Desc; parameters[6].Value = model.Bulletin; parameters[7].Value = model.PicPath; parameters[8].Value = model.Created; parameters[9].Value = model.Modified; parameters[10].Value = model.ShopId; int rows = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 插入一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertShopInfo(tbShopInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbShopInfo("); strSql.Append("TbShopId,ScoreId,CateId,NickName,Title,[Desc],Bulletin,PicPath,Created,Modified)"); strSql.Append(" values ("); strSql.Append("@TbShopId,@ScoreId,@CateId,@NickName,@Title,@Desc,@Bulletin,@PicPath,@Created,@Modified)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TbShopId", SqlDbType.Int, 4), new SqlParameter("@ScoreId", SqlDbType.Int, 4), new SqlParameter("@CateId", SqlDbType.Int, 4), new SqlParameter("@NickName", SqlDbType.VarChar, 50), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@Desc", SqlDbType.VarChar, 500), new SqlParameter("@Bulletin", SqlDbType.VarChar, 200), new SqlParameter("@PicPath", SqlDbType.VarChar, 200), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@Modified", SqlDbType.DateTime) }; parameters[0].Value = model.TbShopId; parameters[1].Value = model.Score.ScoreId; parameters[2].Value = model.CateId; parameters[3].Value = model.NickName; parameters[4].Value = model.Title; parameters[5].Value = model.Desc; parameters[6].Value = model.Bulletin; parameters[7].Value = model.PicPath; parameters[8].Value = model.Created; parameters[9].Value = model.Modified; object obj = DBHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 查询数据(by ShopId) /// </summary> /// <param name="ShopId"></param> /// <returns></returns> public tbShopInfo SelecttbShopInfoByShopId(string ShopId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ShopId,TbShopId,ScoreId,CateId,NickName,Title,[Desc],Bulletin,PicPath,Created,Modified from tbShopInfo "); strSql.Append(" where ShopId=@ShopId"); SqlParameter[] parameters = { new SqlParameter("@ShopId", SqlDbType.Int, 4) }; parameters[0].Value = ShopId; tbShopInfo model = new tbShopInfo(); DataSet ds = DBHelper.ExecuteDataSet(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ShopId"].ToString() != "") { model.ShopId = int.Parse(ds.Tables[0].Rows[0]["ShopId"].ToString()); } if (ds.Tables[0].Rows[0]["TbShopId"].ToString() != "") { model.TbShopId = int.Parse(ds.Tables[0].Rows[0]["TbShopId"].ToString()); } if (ds.Tables[0].Rows[0]["ScoreId"].ToString() != "") { model.Score = new tbShopScore(); model.Score.ScoreId = int.Parse(ds.Tables[0].Rows[0]["ScoreId"].ToString()); } if (ds.Tables[0].Rows[0]["CateId"].ToString() != "") { model.CateId = int.Parse(ds.Tables[0].Rows[0]["CateId"].ToString()); } if (ds.Tables[0].Rows[0]["NickName"] != null) { model.NickName = ds.Tables[0].Rows[0]["NickName"].ToString(); } if (ds.Tables[0].Rows[0]["Title"] != null) { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["Desc"] != null) { model.Desc = ds.Tables[0].Rows[0]["Desc"].ToString(); } if (ds.Tables[0].Rows[0]["Bulletin"] != null) { model.Bulletin = ds.Tables[0].Rows[0]["Bulletin"].ToString(); } if (ds.Tables[0].Rows[0]["PicPath"] != null) { model.PicPath = ds.Tables[0].Rows[0]["PicPath"].ToString(); } if (ds.Tables[0].Rows[0]["Created"].ToString() != "") { model.Created = DateTime.Parse(ds.Tables[0].Rows[0]["Created"].ToString()); } if (ds.Tables[0].Rows[0]["Modified"].ToString() != "") { model.Modified = DateTime.Parse(ds.Tables[0].Rows[0]["Modified"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 保存用户信息到数据库 /// </summary> /// <param name="us"></param> private tbClientUser Save(tbClientUser us, string token, string ExpiresIn) { GetShop gs = new GetShop(); using (TransactionScope scope = new TransactionScope()) { try { int shopid = 0; tbClientUser ClientUser = BClientUser.ExitisUser(us.TbUserId.ToString(), us.UserNick); if (ClientUser == null) { int ScoreId = 0; //从淘宝获取店铺信息 tbShopInfo ShopInfo = gs.GetInfoFromTb(us.UserNick, 0); if (ShopInfo.Score.ItemScore != null && ShopInfo.Score.ServiceScore != null) { //往数据库插入店铺评分表 ScoreId = BShopScore.InsertShopScore(ShopInfo.Score); } //获取返回自动生成的主键 ShopInfo.Score.ScoreId = ScoreId; //往店铺信息表中插入数据 shopid = BShopInfo.InsertShopInfo(ShopInfo); ShopInfo.ShopId = shopid; //插入用户信用表,并获取返回的ID int Creditid = BClientUserCredit.InsertUserCredit(new tbClientUserCredit { GoodNum = us.Credit.GoodNum, Level = us.Credit.Level, Score = us.Credit.Score, TotalNum = us.Credit.TotalNum }); us.UserShops = new List <tbClientUserShop>(); us.Credit.CreditId = Creditid; //插入用户信息表 int userid = BClientUser.InsertUser(us); //往用户店铺关系对应表中插入数据 BClientUserShop.InsertUserShop(new tbClientUserShop() { Shop = ShopInfo, SessionKey = token, UserId = userid }); us.UserShops.Add(new tbClientUserShop() { Shop = ShopInfo, SessionKey = token, UserId = userid }); } else { tbShopInfo shopinfo = new tbShopInfo(); tbClientUserShop usershop = BClientUserShop.SelectUserShopByUserId(ClientUser.UserId.ToString()); usershop.SessionKey = token; shopid = usershop.Shop.ShopId; shopinfo = BShopInfo.SelecttbShopInfoByShopId(shopid.ToString()); BClientUserShop.UpdateUserShop(usershop); //从淘宝获取店铺信息 tbShopInfo TBShopInfo = gs.GetInfoFromTb(us.UserNick, shopinfo.Score.ScoreId); TBShopInfo.ShopId = shopid; if (TBShopInfo.Score.ItemScore != null && TBShopInfo.Score.ServiceScore != null) { BShopScore.UpdateShopScore(new tbShopScore() { DeliveryScore = TBShopInfo.Score.DeliveryScore, ItemScore = TBShopInfo.Score.ItemScore, ServiceScore = TBShopInfo.Score.ServiceScore, ScoreId = shopinfo.Score.ScoreId }); } BShopInfo.UpdateShopInfo(TBShopInfo); us.UserId = ClientUser.UserId; BClientUserCredit.UpdateUserCredit(new tbClientUserCredit() { CreditId = ClientUser.Credit.CreditId, GoodNum = us.Credit.GoodNum, Level = us.Credit.Level, Score = us.Credit.Level, TotalNum = us.Credit.GoodNum }); us.Credit = new tbClientUserCredit(); us.Credit.CreditId = ClientUser.Credit.CreditId; BClientUser.UpdateUser(us); us.UserShops = new List <tbClientUserShop>(); us.UserShops.Add(usershop); usershop.Shop = new tbShopInfo(); usershop.Shop = shopinfo; } scope.Complete(); Hashtable ht = new Hashtable(); ht.Add("TBNick", us.UserNick); ht.Add("token", token); ht.Add("TbUserId", us.TbUserId); ht.Add("Shopid", shopid); DataCache.SetCache("UserInfo" + us.UserId, ht); } catch (Exception ex) { throw ex; } } return(us); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="ShopScore"></param> /// <returns></returns> public static bool UpdateShopInfo(tbShopInfo ShopInfo) { return(SetShopInfo.UpdateShopInfo(ShopInfo)); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="ShopScore"></param> /// <returns></returns> public static int InsertShopInfo(tbShopInfo ShopInfo) { return(SetShopInfo.InsertShopInfo(ShopInfo)); }