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