public override Result UpdatePriceStatus(decimal price, decimal shopPrice, decimal wholesalePrice, int status, int sysNo) { List <DBKey> keyList = new List <DBKey>(); keyList.Add(new DBKey() { KeyName = "WholesalePrice", Type = "decimal(18, 2)" }); CheckKeyExcel(keyList); Result result = new Result(); string Sql = string.Format("update DsSpecialPrice set Price = {0},ShopPrice = {3},WholesalePrice = {4},Status = {1} where SysNo = {2}", price, status, sysNo, shopPrice, wholesalePrice); int rowsAffected = Context.Sql(Sql).Execute(); if (rowsAffected > 0) { result.Status = true; result.Message = "更新成功"; result.StatusCode = 1; } else { result.Status = false; result.Message = "更新上架状态失败"; result.StatusCode = -1; return(result); } DsSpecialPrice entity = GetEntityBySysNo(sysNo); string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + entity.ProductSysNo + "' "; Context.Sql(sql).Execute(); return(result); }
/// <summary> /// 创建分销商产品特殊价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>系统编号</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public int Create(DsSpecialPrice model) { var sysNo = IDsSpecialPriceDao.Instance.Create(model); SysLog.Instance.Info(LogStatus.系统日志来源.后台, "创建分销商产品特殊价格", LogStatus.系统日志目标类型.分销商特殊价格, sysNo); return(sysNo); }
/// <summary> /// 获取特殊价格信息 /// </summary> /// <param name="SysNo">分销商商品系统编号</param> /// <returns>特殊价格信息</returns> /// <remarks>2016-2-24 王耀发 创建</remarks> //public override DsSpecialPrice GetEntityByProductSysNo(int ProductSysNo) //{ // return Context.Sql("select * from DsSpecialPrice where ProductSysNo=@ProductSysNo") // .Parameter("ProductSysNo", ProductSysNo) // .QuerySingle<DsSpecialPrice>(); //} public override Result UpdatePriceStatus(decimal price, decimal shopPrice, int status, int sysNo) { Result result = new Result(); string Sql = string.Format("update DsSpecialPrice set Price = {0},ShopPrice = {3},Status = {1} where SysNo = {2}", price, status, sysNo, shopPrice); int rowsAffected = Context.Sql(Sql).Execute(); if (rowsAffected > 0) { result.Status = true; result.Message = "更新成功"; result.StatusCode = 1; } else { result.Status = false; result.Message = "更新上架状态失败"; result.StatusCode = -1; return(result); } DsSpecialPrice entity = GetEntityBySysNo(sysNo); string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + entity.ProductSysNo + "' "; Context.Sql(sql).Execute(); return(result); }
/// <summary> /// 修改价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>受影响行</returns> /// <remarks>2013-09-06 周瑜 创建</remarks> public override int UpdatePrice(DsSpecialPrice model) { return(Context.Sql("update DsSpecialPrice set Price = @Price, LastUpdateBy = @LastUpdateBy, LastUpdateDate = @LastUpdateDate where SysNo = @SysNo") .Parameter("Price", model.Price) .Parameter("LastUpdateBy", model.LastUpdateBy) .Parameter("LastUpdateDate", model.LastUpdateDate) .Parameter("SysNo", model.SysNo) .Execute()); }
/// <summary> /// 更新分销商产品特殊价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>系统编号</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public override int Update(DsSpecialPrice model) { List <DBKey> keyList = new List <DBKey>(); keyList.Add(new DBKey() { KeyName = "WholesalePrice", Type = "decimal(18, 2)" }); CheckKeyExcel(keyList); return(Context.Update("DsSpecialPrice", model).AutoMap(x => x.SysNo).Where(x => x.SysNo).Execute()); }
/// <summary> /// 修改特殊价格状态: 禁用/启用 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>受影响行</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public override int UpdateStatus(DsSpecialPrice model) { int sysno = Context.Sql("update DsSpecialPrice set Status = @Status, LastUpdateBy = @LastUpdateBy, LastUpdateDate = @LastUpdateDate where SysNo = @SysNo") .Parameter("Status", model.Status) .Parameter("LastUpdateBy", model.LastUpdateBy) .Parameter("LastUpdateDate", model.LastUpdateDate) .Parameter("SysNo", model.SysNo) .Execute(); string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + model.ProductSysNo + "' "; Context.Sql(sql).Execute(); return(sysno); }
/// <summary> /// 创建分销商产品特殊价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>系统编号</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public override int Create(DsSpecialPrice model) { List <DBKey> keyList = new List <DBKey>(); keyList.Add(new DBKey() { KeyName = "WholesalePrice", Type = "decimal(18, 2)" }); CheckKeyExcel(keyList); int sysno = Context.Insert("DsSpecialPrice", model).AutoMap(x => x.SysNo).ExecuteReturnLastId <int>("SysNo"); ///更新库存信息,修改商品档案的更新时间 string sql = " update PdProduct set LastUpdateDate='" + DateTime.Now.ToString() + "' where SysNo='" + model.ProductSysNo + "' "; Context.Sql(sql).Execute(); return(sysno); }
/// <summary> /// 修改价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>返回影响行</returns> /// <remarks>2013-09-06 周瑜 创建</remarks> public int UpdatePrice(DsSpecialPrice model) { SysLog.Instance.Info(LogStatus.系统日志来源.后台, "修改价格", LogStatus.系统日志目标类型.分销商特殊价格, model.SysNo); return(IDsSpecialPriceDao.Instance.UpdatePrice(model)); }
public Result ImportSpecialPriceExcel(System.IO.Stream stream, int operatorSysno) { var result = new Result(); DataTable dt = null; var cols = DisColsMapping.Select(p => p.Value).ToArray(); var existlst = new List <PdProduct>(); try { dt = ExcelUtil.ImportExcel(stream, cols); } catch (System.Exception ex) { //exception happened,some not caughted result.Message = string.Format("数据导入错误,请选择正确的excel文件"); result.Status = false; return(result); } if (dt == null) { //not all the cols mapped result.Message = string.Format("请选择正确的excel文件!"); result.Status = false; return(result); } string msg = ""; var excellst = new List <PdProductList>(); var lstToInsert = new List <PdProductList>(); var lstToUpdate = new List <PdProductList>(); List <PdProduct> productList = Hyt.BLL.Product.PdProductBo.Instance.GetAllProductDataBase(); List <DsSpecialPrice> specProductList = DsSpecialPriceBo.Instance.GetAllProductDsSpecialPrice(); IList <DsDealer> dealerList = DsDealerBo.Instance.GetAllDealerList(); for (var i = 0; i < dt.Rows.Count; i++) { int excelRow = i + 2; for (var j = 0; j < dt.Columns.Count; j++) { if ((dt.Rows[i][j] == null || string.IsNullOrEmpty(dt.Rows[i][j].ToString().Trim()))) { result.Message = string.Format("excel表第{0}行第{1}列数据不能有空值", excelRow, (j + 1)); result.Status = false; return(result); } } //商品编号 var ErpCode = dt.Rows[i][DisColsMapping["ErpCode"]].ToString().Trim(); //条形码. var Barcode = dt.Rows[i][DisColsMapping["Barcode"]].ToString().Trim(); var DsDealerName = dt.Rows[i][DisColsMapping["DsDealerName"]].ToString().Trim(); var DsUserPrice = dt.Rows[i][DisColsMapping["DsUserPrice"]].ToString().Trim(); var ShopPrice = dt.Rows[i][DisColsMapping["ShopPrice"]].ToString().Trim(); var WholesalePrice = dt.Rows[i][DisColsMapping["WholesalePrice"]].ToString().Trim(); PdProduct tempProduct = productList.Find(p => p.ErpCode == ErpCode); List <DsDealer> tempDealer = dealerList.Where(p => p.DealerName == DsDealerName).ToList(); if (tempProduct != null && tempDealer.Count > 0 && !string.IsNullOrEmpty(DsUserPrice) && !string.IsNullOrEmpty(ShopPrice)) { DsSpecialPrice tempSpecialMod = specProductList.Find(p => p.DealerSysNo == tempDealer[0].SysNo && p.ProductSysNo == tempProduct.SysNo); DsSpecialPrice specialMod; try { specialMod = new DsSpecialPrice() { ProductSysNo = tempProduct.SysNo, DealerSysNo = tempDealer[0].SysNo, CreatedBy = 1, CreatedDate = System.DateTime.Now, LastUpdateBy = 1, LastUpdateDate = System.DateTime.Now, Price = decimal.Parse(DsUserPrice), ShopPrice = decimal.Parse(ShopPrice), WholesalePrice = decimal.Parse(WholesalePrice), Status = 1 }; } catch (System.Exception e) { if (!string.IsNullOrEmpty(msg)) { msg += ","; } msg += "商品编码:" + Barcode + "出现异常-" + e.Message; continue; } if (tempSpecialMod == null) { DsSpecialPriceBo.Instance.Create(specialMod); } else { specialMod.SysNo = tempSpecialMod.SysNo; DsSpecialPriceBo.Instance.Update(specialMod); } } else { if (!string.IsNullOrEmpty(msg)) { msg += ","; } if (tempProduct == null) { msg += "商品编码:" + Barcode + "出现异常-档案中无当前编码商品"; } if (tempDealer.Count == 0) { msg += "商品编码:" + Barcode + "出现异常-无指定分销商存在"; } if (string.IsNullOrEmpty(DsUserPrice)) { msg += "商品编码:" + Barcode + "出现异常-分销商会员价格不能为空"; } if (string.IsNullOrEmpty(ShopPrice)) { msg += "商品编码:" + Barcode + "出现异常-分销商线下门店价格不能为空"; } } } if (string.IsNullOrEmpty(msg)) { result.Message = "操作成功"; } else { result.Message = "操作成功-其中有部分商品有异常" + msg; } result.Status = true; return(result); }
/// <summary> /// 修改价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>受影响行</returns> /// <remarks>2013-09-06 周瑜 创建</remarks> public abstract int UpdatePrice(DsSpecialPrice model);
/// <summary> /// 修改特殊价格状态: 禁用/启用 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>受影响行</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public abstract int UpdateStatus(DsSpecialPrice model);
/// <summary> /// 创建分销商产品特殊价格 /// </summary> /// <param name="model">分销商产品特殊价格实体</param> /// <returns>系统编号</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public abstract int Create(DsSpecialPrice model);