//GET:店铺详情 public ActionResult Detail(int id, int page = 1, string orderby = "dft") { var shop = _shopService.GetShop(id); if (shop.IsNull()) { throw new HttpException(404, "Page not found"); } var isFaved = IsFavShop(shop.ID, _userFavShopService.GetListByUser(UserId)); var model = new ShopDetailModel { Shop = shop, Products = _productService.GetProductsByShop(shop.ID, page - 1, orderby), CollectionHtml = GetCollectActionboxHtml(isFaved, id) }; ViewBag.OrderBy = orderby; ViewBag.UserId = UserId; return(View(model)); }
public static void CreateThirdPartyShop(ShopDetailModel shopDetail) { try { using ( var dbhelper = DbHelper.CreateDbHelper(ConfigurationManager.ConnectionStrings["ThirdParty"].ConnectionString)) { using ( var cmd = new SqlCommand( "INSERT INTO ThirdPartySyncShops" + " VALUES (@PKID, @SimpleName, @CarparName, @FullName, @CompanyName, @RegionID, @Province, @CityID, @City, @DistrictID," + " @District, @Address, @AddressBrief, @Position, @Contact, @Telephone,@Mobile,@Cover,@POS," + " @WorkTime,@Images,@ShopType,@SuspendStartDateTime,@SuspendEndDateTime,@ShopLevel,@ServiceType,@ShopAICUrl,@MetalServiceType,@Date_CreateTime,@Date_ChangeTime)") { CommandTimeout = 10 * 60 } ) { DateTime time = DateTime.Now; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@PKID", shopDetail.ShopId); cmd.Parameters.AddWithValue("@SimpleName", shopDetail.SimpleName); cmd.Parameters.AddWithValue("@CarparName", shopDetail.CarparName); cmd.Parameters.AddWithValue("@FullName", shopDetail.FullName); cmd.Parameters.AddWithValue("@CompanyName", shopDetail.CompanyName); cmd.Parameters.AddWithValue("@RegionID", shopDetail.ProvinceId); cmd.Parameters.AddWithValue("@Province", shopDetail.Province); cmd.Parameters.AddWithValue("@CityID", shopDetail.CityId); cmd.Parameters.AddWithValue("@City", shopDetail.City); cmd.Parameters.AddWithValue("@DistrictID", shopDetail.DistrictId); cmd.Parameters.AddWithValue("@District", shopDetail.District); cmd.Parameters.AddWithValue("@Address", shopDetail.Address); cmd.Parameters.AddWithValue("@AddressBrief", shopDetail.AddressBrief); //cmd.Parameters.AddWithValue("@Description", shopDetail); cmd.Parameters.AddWithValue("@Position", (shopDetail.Position != null) ? string.Join(",", shopDetail.Position.Where(q => q > 0).Select(q => q).ToList()) : string.Empty); cmd.Parameters.AddWithValue("@Contact", shopDetail.Contact); cmd.Parameters.AddWithValue("@Telephone", shopDetail.Telephone); cmd.Parameters.AddWithValue("@Mobile", shopDetail.Mobile); cmd.Parameters.AddWithValue("@Cover", (shopDetail.Cover != null) ? string.Join(",", shopDetail.Cover.Where(q => q != null).Select(q => q).ToList()) : string.Empty); cmd.Parameters.AddWithValue("@POS", shopDetail.Pos); cmd.Parameters.AddWithValue("@WorkTime", shopDetail.WorkTime); cmd.Parameters.AddWithValue("@Images", (shopDetail.Images != null && shopDetail.Images.FirstOrDefault() != null) ? shopDetail.Images[0] : string.Empty); cmd.Parameters.AddWithValue("@ShopType", shopDetail.ShopType); cmd.Parameters.AddWithValue("@SuspendStartDateTime", shopDetail.SuspendStartDateTime); cmd.Parameters.AddWithValue("@SuspendEndDateTime", shopDetail.SuspendEndDateTime); cmd.Parameters.AddWithValue("@ShopLevel", shopDetail.ShopLevel != null ? shopDetail.ShopLevel.ShopStarLevel : 0); // cmd.Parameters.AddWithValue("@ShopBusinessType", shopDetail.shopb); cmd.Parameters.AddWithValue("@ServiceType", shopDetail.ServiceType); cmd.Parameters.AddWithValue("@ShopAICUrl", shopDetail.ShopAICUrl != null ? shopDetail.ShopAICUrl : string.Empty); cmd.Parameters.AddWithValue("@MetalServiceType", shopDetail.MetalServiceType); cmd.Parameters.AddWithValue("@Date_CreateTime", time); cmd.Parameters.AddWithValue("@Date_ChangeTime", time); dbhelper.ExecuteNonQuery(cmd); } } } catch (Exception ex) { TuhuShopSyncJob.Logger.Error("ShopID:" + shopDetail.ShopId + "occur error", ex); } }