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