/// <summary> /// 产品信息提交 /// </summary> /// <returns></returns> public int ProductDetailEdit() { int _productId = FormString.IntSafeQ("productId"); int _productDetailId = FormString.IntSafeQ("productDetailId"); int _productType = FormString.IntSafeQ("productType"); int _status = FormString.IntSafeQ("status"); int _saleNum = FormString.IntSafeQ("saleNum"); decimal _tradePrice = FormString.DecimalSafeQ("tradePrice"); decimal _price = FormString.DecimalSafeQ("price"); int _stockNum = FormString.IntSafeQ("stockNum"); ProductDetailEntity entity = new ProductDetailEntity(); entity.ProductId = _productId; entity.Id = _productDetailId; entity.ProductType = _productType; entity.Status = _status; entity.SaleNum = _saleNum; entity.TradePrice = _tradePrice; entity.Price = _price; entity.StockNum = _stockNum; //if (_productType == (int)ProductType.SpecialPrice) //{ // entity.StockNum = _stockNum; //} //else if (_productType == (int)ProductType.Normal) //{ // entity.StockNum = 999999; //} int _result = ProductDetailBLL.Instance.AddProductDetail(entity); return(_result); }
public bool Post(ProductDetailModel model) { var entity = new ProductDetailEntity { Detail = model.Detail, ImgUrl1 = model.ImgUrl1, ImgUrl2 = model.ImgUrl2, ImgUrl3 = model.ImgUrl3, ImgUrl4 = model.ImgUrl4, ImgUrl5 = model.ImgUrl5, // Product = model.Product, }; if (_ProductDetailService.Create(entity).Id > 0) { return(true); } return(false); }
/// <summary> /// 插入一条记录到表ProductDetail,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="productDetail">待插入的实体对象</param> public int AddProductDetail(ProductDetailEntity entity) { string sql = @"insert into ProductDetail( [ProductId],[Price],[TradePrice],[StockNum],[SaleNum],[ProductType],[Status],IsBP,Sort)VALUES ( @ProductId,@Price,@TradePrice,@StockNum,@SaleNum,@ProductType,@Status,@IsBP,@Sort); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); db.AddInParameter(cmd, "@Price", DbType.Decimal, entity.Price); db.AddInParameter(cmd, "@TradePrice", DbType.Decimal, entity.TradePrice); db.AddInParameter(cmd, "@StockNum", DbType.Int32, entity.StockNum); db.AddInParameter(cmd, "@SaleNum", DbType.Int32, entity.SaleNum); db.AddInParameter(cmd, "@ProductType", DbType.Int32, entity.ProductType); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@IsBP", DbType.Int32, entity.IsBP); db.AddInParameter(cmd, "@Sort", DbType.Int32, entity.Sort); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
public bool Post(ProductDetailModel model) { var entity = new ProductDetailEntity { Name = model.Name, Detail = model.Detail, Img = model.Img, Img1 = model.Img1, Img2 = model.Img2, Img3 = model.Img3, Img4 = model.Img4, SericeInstruction = model.SericeInstruction, AddUser = model.AddUser, AddTime = model.AddTime, UpdUser = model.UpdUser, UpdTime = model.UpdTime, Ad1 = model.Ad1, Ad2 = model.Ad2, Ad3 = model.Ad3, }; if (_productDetailService.Create(entity).Id > 0) { return(true); } return(false); }
/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(ProductDetailEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[ProductDetail] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { where += " ProductId=@ProductId AND ProductType=@ProductType"; } else { where += " Id<>@Id AND ProductId=@ProductId AND ProductType=@ProductType"; } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); db.AddInParameter(cmd, "@ProductType", DbType.Int32, entity.ProductType); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <ProductDetailEntity> GetProductDetailAll() { string sql = @"SELECT [Id],[ProductId],[Price],[TradePrice],[StockNum],[SaleNum],[ProductType],[Status],[TimeStampCode] from dbo.[ProductDetail] WITH(NOLOCK) "; IList <ProductDetailEntity> entityList = new List <ProductDetailEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ProductDetailEntity entity = new ProductDetailEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.Price = StringUtils.GetDbDecimal(reader["Price"]); entity.TradePrice = StringUtils.GetDbDecimal(reader["TradePrice"]); entity.StockNum = StringUtils.GetDbInt(reader["StockNum"]); entity.SaleNum = StringUtils.GetDbInt(reader["SaleNum"]); entity.ProductType = StringUtils.GetDbInt(reader["ProductType"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.TimeStampCode = StringUtils.GetDbString(reader["TimeStampCode"]); entityList.Add(entity); } } return(entityList); }
/// <summary> /// 添加商品 /// </summary> /// <param name="model">商品model</param> /// <returns>提示信息</returns> public HttpResponseMessage Post(ProductModel model) { var category = _categoryService.GetCategoryById(model.CategoryId); var entity = new ProductEntity { Category = category, BussnessId = model.BussnessId, BussnessName = model.BussnessName, Price = model.Price, Name = model.Name, Status = model.Status, MainImg = model.MainImg, IsRecommend = model.IsRecommend, Sort = model.Sort, Stock = model.Stock, AddUser = _workContext.CurrentUser.Id, AddTime = DateTime.Now, UpdUser = _workContext.CurrentUser.Id, UpdTime = DateTime.Now, Subtitte = model.Subtitte, Contactphone = model.Contactphone, Type = model.Type, OldPrice = model.OldPrice, Owner = model.Owner // Detail = model.Detail, //Comments = model.Comments, // Parameters = model.Parameters, }; int id = _productService.Create(entity).Id; if (id > 0) { var productDetail = new ProductDetailEntity { Id = id, Name = model.Name, Detail = model.Detail, Img = model.Img, Img1 = model.Img1, Img2 = model.Img2, Img3 = model.Img3, Img4 = model.Img4, SericeInstruction = model.SericeInstruction, AddUser = _workContext.CurrentUser.Id, AddTime = DateTime.Now, UpdUser = _workContext.CurrentUser.Id, UpdTime = DateTime.Now, Ad1 = model.Ad1, Ad2 = model.Ad2, Ad3 = model.Ad3, }; if (_productDetailService.Create(productDetail).Id > 0) { return(PageHelper.toJson(PageHelper.ReturnValue(true, "数据添加成功"))); } return(PageHelper.toJson(PageHelper.ReturnValue(false, "商品详细添加失败"))); } return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据添加失败"))); }
public ProductDetailEntity Update(ProductDetailEntity entity) { try { _productdetailRepository.Update(entity); return(entity); } catch (Exception e) { _log.Error(e, "数据库操作出错"); return(null); } }
public bool Delete(ProductDetailEntity entity) { try { _productdetailRepository.Delete(entity); return(true); } catch (Exception e) { _log.Error(e, "数据库操作出错"); return(false); } }
/// <summary> /// 插入一条记录到表ProductDetail,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="productDetail">要添加的ProductDetail数据实体对象</param> public int AddProductDetail(ProductDetailEntity productDetail) { if (productDetail.Id > 0) { return(UpdateProductDetail(productDetail)); } else if (ProductDetailBLL.Instance.IsExist(productDetail)) { return((int)CommonStatus.ADD_Fail_Exist); } else { return(ProductDetailDA.Instance.AddProductDetail(productDetail)); } }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <ProductDetailEntity> GetProductDetailList(int pagesize, int pageindex, ref int recordCount) { string sql = @"SELECT [Id],[ProductId],[Price],[TradePrice],[StockNum],[SaleNum],[ProductType],[Status],[TimeStampCode] FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER, [Id],[ProductId],[Price],[TradePrice],[StockNum],[SaleNum],[ProductType],[Status],[TimeStampCode] from dbo.[ProductDetail] WITH(NOLOCK) WHERE 1=1 ) as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[ProductDetail] with (nolock) "; IList <ProductDetailEntity> entityList = new List <ProductDetailEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ProductDetailEntity entity = new ProductDetailEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.Price = StringUtils.GetDbDecimal(reader["Price"]); entity.TradePrice = StringUtils.GetDbDecimal(reader["TradePrice"]); entity.StockNum = StringUtils.GetDbInt(reader["StockNum"]); entity.SaleNum = StringUtils.GetDbInt(reader["SaleNum"]); entity.ProductType = StringUtils.GetDbInt(reader["ProductType"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.TimeStampCode = StringUtils.GetDbString(reader["TimeStampCode"]); entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { recordCount = StringUtils.GetDbInt(reader[0]); } else { recordCount = 0; } } return(entityList); }
/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="productDetail">待更新的实体对象</param> public int UpdateProductDetail(ProductDetailEntity entity) { string sql = @" UPDATE dbo.[ProductDetail] SET [ProductId]=@ProductId,[Price]=@Price,IsBP=@IsBP,[TradePrice]=@TradePrice,[DealerPrice]=@DealerPrice,[StockNum]=@StockNum,[SaleNum]=@SaleNum,[ProductType]=@ProductType,[Status]=@Status WHERE [Id]=@id"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); db.AddInParameter(cmd, "@Price", DbType.Decimal, entity.Price); db.AddInParameter(cmd, "@TradePrice", DbType.Decimal, entity.TradePrice); db.AddInParameter(cmd, "@DealerPrice", DbType.Decimal, entity.DealerPrice); db.AddInParameter(cmd, "@StockNum", DbType.Int32, entity.StockNum); db.AddInParameter(cmd, "@SaleNum", DbType.Int32, entity.SaleNum); db.AddInParameter(cmd, "@ProductType", DbType.Int32, entity.ProductType); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@IsBP", DbType.Int32, entity.IsBP); return(db.ExecuteNonQuery(cmd)); }
public HttpResponseMessage AddProduct([FromBody] JObject obj) { dynamic json = obj; JObject JProduct = json.product; JObject JProductDetail = json.productDetail; var product = JProduct.ToObject <ProductModel>(); var productDetail = JProductDetail.ToObject <ProductDetailModel>(); Regex reg = new Regex(@"^[^%@#!*~&',;=?$\x22]+$"); var m = reg.IsMatch(productDetail.Productname); if (!m) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "存在非法字符!"))); } else { //先创建productDetail,跟据部分productDetail部分重叠信息创建product; ProductDetailEntity PDE = new ProductDetailEntity() { Id = 0, Productdetail = productDetail.Productdetail, Productimg = productDetail.Productimg, Productimg1 = productDetail.Productimg1, Productimg2 = productDetail.Productimg2, Productimg3 = productDetail.Productimg3, Productimg4 = productDetail.Productimg4, Productname = productDetail.Productname, Sericeinstruction = productDetail.Sericeinstruction, Ad1 = productDetail.Ad1, Addtime = DateTime.Now, //Adduser = productDetail.Adduser, Adduser = _workContent.CurrentUser.Id.ToString(), Updtime = DateTime.Now, //Upduser = productDetail.Upduser Upduser = _workContent.CurrentUser.Id.ToString() }; ProductDetailEntity PDE2 = _productDetailService.Create(PDE); ClassifyEntity CE = _classifyService.GetClassifyById(product.ClassifyId); ProductBrandEntity CBE = _productBrandService.GetProductBrandById(product.ProductBrandId); ProductEntity PE = new ProductEntity() { Bussnessid = product.Bussnessid, BussnessName = "yoopoon", Commission = product.Commission, RecCommission = product.RecCommission, Dealcommission = product.Dealcommission, Price = product.Price, Classify = CE, ProductBrand = CBE, ProductDetail = PDE2, Productimg = product.Productimg, Productname = PDE.Productname, Recommend = product.Recommend, Sort = product.Sort, Status = product.Status, Stockrule = product.Stockrule, SubTitle = product.SubTitle, ContactPhone = product.ContactPhone, Updtime = DateTime.Now, //Upduser = PDE.Upduser, Upduser = _workContent.CurrentUser.Id.ToString(), Addtime = DateTime.Now, //Adduser = PDE.Adduser Adduser = _workContent.CurrentUser.Id.ToString() }; var Product = _productService.Create(PE); if (Product != null) { return(PageHelper.toJson(PageHelper.ReturnValue(true, "数据添加成功!", Product.Id))); } else { return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据添加失败!"))); } } //try //{ // return _productService.Create(PE).Id; //} //catch (Exception e) //{ // return -1; //} }
/// <summary> /// 更新一条ProductDetail记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="productDetail">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateProductDetail(ProductDetailEntity productDetail) { return(ProductDetailDA.Instance.UpdateProductDetail(productDetail)); }
/// <summary> /// 判断对象是否存在 /// </summary> /// <param name="dicEnum"></param> /// <returns></returns> public bool IsExist(ProductDetailEntity productDetail) { return(ProductDetailDA.Instance.ExistNum(productDetail) > 0); }