/// <summary>
/// ajax操作上新时间
/// </summary>
/// <param name="NewArrivalId"></param>
/// <param name="BrandNo"></param>
/// <param name="NewShelfDate"></param>
/// <returns></returns>
public ActionResult OperationNewShelf(string NewArrivalId, string BrandNo, string NewShelfDate)
{
Passport passport = PresentationHelper.GetPassport();//用户
SwfsFlagShipNewArrival arrival = new SwfsFlagShipNewArrival();
NewArrivalId = NewArrivalId == null || NewArrivalId == "" ? "0" : NewArrivalId;
SwfsFlagShipNewArrivalProductService service = new SwfsFlagShipNewArrivalProductService();
SwfsFlagShipNewArrival selectarrival = service.SelectBrandNoNewShelfDate(BrandNo, NewShelfDate);//查找某个品牌下的当前上新时间是否有数据
if (selectarrival != null)
{
return(Json(new { message = "该上新时间已经存在" }));
}
arrival.UpdateOperateUserId = passport.UserName;
arrival.BrandNo = BrandNo;
arrival.NewShelfDate = Convert.ToDateTime(NewShelfDate);
try
{
service.OperationNewShelf(arrival, Convert.ToInt32(NewArrivalId), passport.UserName);
return(Json(new { message = "操作成功" }));
}
catch (Exception e)
{
return(Json(new { message = "操作失败" }));
}
}
/// <summary>
/// 操作最新上架
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int OperationNewShelf(SwfsFlagShipNewArrival model, int NewArrivalId, string UserId)
{
//判断ID如果为空，那就是添加
if (NewArrivalId == 0)
{
model.OperateUserId = UserId;
model.NewArrivalTitle = "新品上架";
model.PageNo = "index";
model.PagePositionNo = "top";
model.PagePositionName = "新品上架";
model.CreateDate = System.DateTime.Now;
model.SortValue = 0;
model.Status = 1;
model.DataState = 1;
model.UpdateDate = System.DateTime.Now;
return(DapperUtil.Insert <SwfsFlagShipNewArrival>(model));
}
else//否则就是修改
{
model.UpdateDate = System.DateTime.Now;
model.NewArrivalId = NewArrivalId;
string str = "update SwfsFlagShipNewArrival set NewShelfDate='" + model.NewShelfDate + "',UpdateOperateUserId='" + model.UpdateOperateUserId + "',UpdateDate='" + model.UpdateDate + "' where NewArrivalId=" + model.NewArrivalId;
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("sqlstring", str);
return(DapperUtil.Query <int>("ComBeziWfs_SwfsFlagShipNewArrivalProductList_InsertsProduct", dic).FirstOrDefault());
}
}
