/// <summary> /// /// </summary> /// <param name="SysNo"></param> /// <returns></returns> /// <remarkss>2016-04-05 王耀发 更新</remarks> public override int UpdateLgGaoJieGoodsInfoEntity(LgGaoJieGoodsInfo entity) { return(Context.Update("LgGaoJieGoodsInfo", entity) .AutoMap(o => o.SysNo) .Where("SysNo", entity.SysNo) .Execute()); }
/// <summary> /// 保存高捷商品配置信息 /// </summary> /// <param name="productModel"></param> /// <returns></returns> /// <remarks>2016-04-05 王耀发 创建</remarks> public Result SaveLgGaoJieGoodsInfo(LgGaoJieGoodsInfo model, SyUser user) { Result r = new Result() { Status = false }; LgGaoJieGoodsInfo entity = ILogisticsDao.Instance.GetLgGaoJieGoodsInfoEntityByPid(model.ProductSysNo); if (entity != null) { model.SysNo = entity.SysNo; model.CreatedDate = entity.CreatedDate; model.CreatedBy = entity.CreatedBy; model.LastUpdateBy = user.SysNo; model.LastUpdateDate = DateTime.Now; ILogisticsDao.Instance.UpdateLgGaoJieGoodsInfoEntity(model); r.Status = true; } else { model.CreatedDate = DateTime.Now; model.CreatedBy = user.SysNo; model.LastUpdateBy = user.SysNo; model.LastUpdateDate = DateTime.Now; ILogisticsDao.Instance.InsertLgGaoJieGoodsInfoEntity(model); r.Status = true; } return(r); }
/// <summary> /// /// </summary> /// <param name="SysNo"></param> /// <returns></returns> /// <remarkss>2016-04-05 王耀发 创建</remarks> public override int InsertLgGaoJieGoodsInfoEntity(LgGaoJieGoodsInfo entity) { entity.SysNo = Context.Insert("LgGaoJieGoodsInfo", entity) .AutoMap(o => o.SysNo) .ExecuteReturnLastId <int>("SysNo"); return(entity.SysNo); }
/// <summary> /// 新增商品备案信息 /// </summary> /// <param name="models">商品备案信息列表</param> /// <returns>空</returns> /// <remarks>2015-09-10 王耀发 创建</remarks> public override void CreateExcelGaoJieGoodsInfo(List <LgGaoJieGoodsInfo> models) { foreach (LgGaoJieGoodsInfo model in models) { LgGaoJieGoodsInfo GoodsInfoData = new LgGaoJieGoodsInfo(); GoodsInfoData.ProductSysNo = model.ProductSysNo; GoodsInfoData.goods_ptcode = model.goods_ptcode; GoodsInfoData.goods_name = model.goods_name; GoodsInfoData.brand = model.brand; GoodsInfoData.goods_spec = model.goods_spec; GoodsInfoData.ycg_code = model.ycg_code; GoodsInfoData.hs_code = model.hs_code; GoodsInfoData.goods_barcode = model.goods_barcode; GoodsInfoData.CreatedBy = model.CreatedBy; GoodsInfoData.CreatedDate = model.CreatedDate; GoodsInfoData.LastUpdateBy = model.LastUpdateBy; GoodsInfoData.LastUpdateDate = model.LastUpdateDate; int InfoSysNo = Context.Insert <LgGaoJieGoodsInfo>("LgGaoJieGoodsInfo", GoodsInfoData) .AutoMap(o => o.SysNo) .ExecuteReturnLastId <int>("SysNo"); } }
/// <summary> /// 导入excel /// </summary> /// <param name="stream">导入的excel stream format</param> /// <param name="operatorSysno">操作人员编号</param> /// <returns>封装的泛型result对象</returns> /// <remarks>2015-09-10 王耀发 创建</remarks> public Result ImportExcelGaoJie(Stream stream, int operatorSysno) { DataTable dt = null; var cols = DicColsMappingGaoJie.Select(p => p.Value).ToArray(); try { dt = ExcelUtil.ImportExcel(stream, cols); } catch (Exception ex) { //exception happened,some not caughted return(new Result { Message = string.Format("数据导入错误,请选择正确的excel文件"), Status = false }); } if (dt == null) { //not all the cols mapped return(new Result { Message = string.Format("请选择正确的excel文件!"), Status = false }); } var excellst = new List <LgGaoJieGoodsInfo>(); var lstToInsert = new List <LgGaoJieGoodsInfo>(); var lstToUpdate = new List <LgGaoJieGoodsInfo>(); for (var i = 0; i < dt.Rows.Count; i++) { int excelRow = i; for (var j = 0; j < dt.Columns.Count; j++) { //HS编码、条形码可以为空 if (j != 6 && j != 7) { if ((dt.Rows[i][j] == null || string.IsNullOrEmpty(dt.Rows[i][j].ToString()))) { return(new Result { Message = string.Format("excel表第{0}行数据不能有空值", (excelRow + 1)), Status = false }); } } } //商品编号 var ErpCode = dt.Rows[i][DicColsMappingGaoJie["ErpCode"]].ToString().Trim(); PdProduct pEntity = PdProductBo.Instance.GetProductByErpCode(ErpCode); if (pEntity == null) { return(new Result { Message = string.Format("excel表第{0}行商品编号不存在", (excelRow + 1)), Status = false }); } //物品名称 var goods_name = dt.Rows[i][DicColsMappingGaoJie["goods_name"]].ToString().Trim(); //税号 var goods_ptcode = dt.Rows[i][DicColsMappingGaoJie["goods_ptcode"]].ToString().Trim(); //品牌 var brand = dt.Rows[i][DicColsMappingGaoJie["brand"]].ToString().Trim(); //规格型号 var goods_spec = dt.Rows[i][DicColsMappingGaoJie["goods_spec"]].ToString().Trim(); //原产国代码 var ycg_code = dt.Rows[i][DicColsMappingGaoJie["ycg_code"]].ToString().Trim(); //HS编码 var hs_code = dt.Rows[i][DicColsMappingGaoJie["hs_code"]].ToString().Trim(); //条形码 var goods_barcode = dt.Rows[i][DicColsMappingGaoJie["goods_barcode"]].ToString().Trim(); var model = new LgGaoJieGoodsInfo { ProductSysNo = pEntity.SysNo, goods_name = goods_name, goods_ptcode = goods_ptcode, brand = brand, goods_spec = goods_spec, hs_code = hs_code, ycg_code = ycg_code, goods_barcode = goods_barcode, CreatedBy = operatorSysno, CreatedDate = DateTime.Now, LastUpdateBy = operatorSysno, LastUpdateDate = DateTime.Now }; excellst.Add(model); } var lstExisted = DataAccess.Logistics.ILogisticsDao.Instance.GetAllGaoJieGoodsInfo(); foreach (var excelModel in excellst) { if (lstExisted.Any(e => e.ProductSysNo == excelModel.ProductSysNo)) { lstToUpdate.Add(excelModel); } else //insert { lstToInsert.Add(excelModel); } } try { DataAccess.Logistics.ILogisticsDao.Instance.CreateExcelGaoJieGoodsInfo(lstToInsert); DataAccess.Logistics.ILogisticsDao.Instance.UpdateExcelGaoJieGoodsInfo(lstToUpdate); } catch (Exception ex) { SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Error, LogStatus.系统日志来源.后台, "导入高捷商品备案信息", LogStatus.系统日志目标类型.商品基本信息, 0, ex, null, operatorSysno); return(new Result { Message = string.Format("数据更新错误:{0}", ex.Message), Status = false }); } var msg = lstToInsert.Count > 0 ? string.Format("成功导入{0}条数据!", lstToInsert.Count) : ""; msg += lstToUpdate.Count > 0 ? string.Format("成功修改{0}条数据!", lstToUpdate.Count) : ""; return(new Result { Message = msg, Status = true }); }
/// <summary> /// 更新数据 /// </summary> /// <param name="entity">数据实体</param> /// <returns></returns> /// <remarkss>2016-04-05 王耀发 更新</remarks> public abstract int UpdateLgGaoJieGoodsInfoEntity(LgGaoJieGoodsInfo entity);
/// <summary> /// 插入数据 /// </summary> /// <param name="entity">数据实体</param> /// <returns>新增记录编号</returns> /// <remarkss>2016-04-05 王耀发 创建</remarks> public abstract int InsertLgGaoJieGoodsInfoEntity(LgGaoJieGoodsInfo entity);