/// <summary> /// 修改上新信息 /// </summary> /// <param name="pkid">上新实体</param> /// <returns></returns> public int UpdateSWfsIndexNewArrivalManager(SWfsIndexNewArrival sWfsIndexNewArrival) { return(DapperUtil.Execute("ComBeziWfs_SWfsIndexNewArrival_UpdateManager", new { NewArrivalTitle = sWfsIndexNewArrival.NewArrivalTitle, StartDate = sWfsIndexNewArrival.StartDate, UpdateOperateUserId = sWfsIndexNewArrival.UpdateOperateUserId, UpdateDate = DateTime.Now, NewArrivalId = sWfsIndexNewArrival.NewArrivalId, })); }
/// <summary> /// 执行添加上新信息 /// </summary> /// <param name="sWfsIndexNewArrival">SWfsIndexNewArrival实体</param> /// <returns>返回主键id</returns> public int InsertNewArrivalInfo(SWfsIndexNewArrival model) { DynamicParameters dp = new DynamicParameters(); dp.Add("NewArrivalTitle", model.NewArrivalTitle, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input); dp.Add("SortValue", model.SortValue, System.Data.DbType.Int32, System.Data.ParameterDirection.Input); dp.Add("WebSiteNo", model.WebSiteNo, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input); dp.Add("PagePositionNo", model.PagePositionNo, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input); dp.Add("PagePositionName", model.PagePositionName, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input); dp.Add("PageNo", model.PageNo, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input); dp.Add("CreateDate", model.CreateDate, System.Data.DbType.DateTime, System.Data.ParameterDirection.Input); dp.Add("StartDate", model.StartDate, System.Data.DbType.DateTime, System.Data.ParameterDirection.Input); dp.Add("Status", model.Status, System.Data.DbType.Int16, System.Data.ParameterDirection.Input); dp.Add("DataState", model.DataState, System.Data.DbType.Int16, System.Data.ParameterDirection.Input); dp.Add("OperateUserId", model.OperateUserId, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input); var result = DapperUtil.Query <object>("ComBeziWfs_SWfsIndexNewArrival_InsertNewArrival", dp).FirstOrDefault(); return(int.Parse(result.ToString().Split('\'')[1])); }
/// <summary> /// 获取最新上架商品信息 /// </summary> /// <param name="pageNo"></param> /// <param name="pagePositionNo"></param> /// <returns></returns> public Dictionary <string, List <ProductInfoShoes> > GetNewArrivalProductListInfo(string pageNo = "", string pagePositionNo = "") { Dictionary <string, List <ProductInfoShoes> > diclist = new Dictionary <string, List <ProductInfoShoes> >(); //获取所有的商品列表信息 SWfsIndexNewArrival item = SelectNewArrivalInfo(pageNo, pagePositionNo); if (item != null) { DynamicParameters dp1 = new DynamicParameters(); dp1.Add("NewArrivalId", item.NewArrivalId, System.Data.DbType.Int32, System.Data.ParameterDirection.Input); List <ProductInfoShoes> slist = GetShoesNewProudecList(item.NewArrivalId.ToString()); if (slist.Count() > 0) { slist[0].NewArrivalId = item.NewArrivalId; slist[0].NewArrivalTitle = item.NewArrivalTitle; diclist.Add(item.NewArrivalId + "_" + item.PagePositionNo, slist); } } return(diclist); }
public ActionResult UpdateNewCommingManagerById() { //上新标题 string title = Request.Form["Title"].ToString(); //上新的编号 string id = Request.Form["CommingId"].ToString(); //上新的日期 string date = Request.Form["CreateTime"].ToString(); int Start = sWfsIndexNewArrivalService.SelSWfsIndexNewArrivalDatailDate(DateTime.Parse(date), int.Parse(id)); if (Start > 0) { return(Content("-1")); } //上新实体 SWfsIndexNewArrival sWfsIndexNewArrival = new SWfsIndexNewArrival(); sWfsIndexNewArrival.NewArrivalId = int.Parse(id); sWfsIndexNewArrival.NewArrivalTitle = title; sWfsIndexNewArrival.StartDate = DateTime.Parse(date); sWfsIndexNewArrival.UpdateOperateUserId = "admin"; int num = sWfsIndexNewArrivalService.UpdateSWfsIndexNewArrivalManager(sWfsIndexNewArrival); if (num == 0) { EnyimMemcachedClient.Instance.Remove("ComBeziWfs_NewArrivalProductInfo_GetNewArrivalProductInfoByStartDate_getNewArrivalInfo"); return(Content("修改失败!")); } else { return(Content("修改成功!")); } }
/// <summary> /// 执行添加上新信息 /// </summary> /// <param name="sWfsIndexNewArrival">SWfsIndexNewArrival实体</param> /// <returns>返回主键id</returns> public int AddSWfsIndexNewArrival(SWfsIndexNewArrival sWfsIndexNewArrival) { return(DapperUtil.Insert <SWfsIndexNewArrival>(sWfsIndexNewArrival, true)); }
public ActionResult AddNewCommingManager() { //上新标题 string title = Request.Form["Title"].ToString(); //上新的商品 string goods = Request.Form["CommingGoods"].ToString(); //上新的日期 string date = Request.Form["CreateTime"].ToString(); //上新实体 SWfsIndexNewArrival sWfsIndexNewArrival = new SWfsIndexNewArrival(); sWfsIndexNewArrival.NewArrivalTitle = title; sWfsIndexNewArrival.StartDate = DateTime.Parse(date); sWfsIndexNewArrival.OperateUserId = "admin"; sWfsIndexNewArrival.WebSiteNo = "shangpin.com"; sWfsIndexNewArrival.PageNo = "index"; sWfsIndexNewArrival.PagePositionNo = "INDEX_NA"; sWfsIndexNewArrival.PagePositionName = "首页上新"; sWfsIndexNewArrival.CreateDate = DateTime.Now; sWfsIndexNewArrival.UpdateDate = DateTime.Now; sWfsIndexNewArrival.EndDate = DateTime.Parse(date); sWfsIndexNewArrival.DataState = 1; sWfsIndexNewArrival.Status = 1; //获取当前用户 Passport passport = PresentationHelper.GetPassport(); sWfsIndexNewArrival.OperateUserId = passport.UserName; int Start = sWfsIndexNewArrivalService.SelSWfsIndexNewArrivalDatailDate(sWfsIndexNewArrival.StartDate, 0); if (Start > 0) { return(Content("-1")); } else { //执行添加上新返回主键编号以便于添加该上新下边的商品 int Pkid = sWfsIndexNewArrivalService.AddSWfsIndexNewArrival(sWfsIndexNewArrival); int sort = 50; int num = 0; if (Pkid != 0) { string[] arr = goods.Split(','); for (int i = 0; i < arr.Length; i++) { string[] arr1 = arr[i].Split('-'); SWfsIndexNewArrivalProductList sWfsIndexNewArrivalProductList = new SWfsIndexNewArrivalProductList(); sWfsIndexNewArrivalProductList.ProductNo = arr1[0]; sWfsIndexNewArrivalProductList.NewArrivalId = Pkid; sWfsIndexNewArrivalProductList.SortValue = sort--; sWfsIndexNewArrivalProductList.OperateUserId = passport.UserName; num += sWfsIndexNewArrivalProductListService.AddSWfsIndexNewArrivalProductList(sWfsIndexNewArrivalProductList); } } if (num == 0) { EnyimMemcachedClient.Instance.Remove("ComBeziWfs_NewArrivalProductInfo_GetNewArrivalProductInfoByStartDate_getNewArrivalInfo"); return(Content("添加失败!")); } else { return(Content("添加成功!")); } } }
/// <summary> /// 修改上新信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateNewArrivalInfo(SWfsIndexNewArrival model) { return(DapperUtil.Update <SWfsIndexNewArrival>(model)); }