/// <summary> /// 更新商品档案 /// </summary> /// <param name="Mod"></param> public void UpdateMod(DsWhProduct Mod) { IDsWhProductDao.Instance.UpdateMod(Mod); }
/// <summary> /// 添加商品档案 /// </summary> /// <param name="Mod"></param> /// <returns></returns> public int InsertMod(DsWhProduct Mod) { return(IDsWhProductDao.Instance.InsertMod(Mod)); }
/// <summary> /// 更新商品档案 /// </summary> /// <param name="Mod"></param> public abstract void UpdateMod(DsWhProduct Mod);
/// <summary> /// 导入商品档案 /// </summary> /// <param name="stream"></param> /// <param name="SyUserNo"></param> /// <param name="DealerSysNo"></param> /// <param name="CusCode"></param> /// <returns></returns> public Model.Result ImportExcel(System.IO.Stream stream, int SyUserNo, int DealerSysNo, string CusCode) { DataTable dt = null; var cols = DicColsMapping.Select(p => p.Value).ToArray(); var existlst = new List <DsWhProduct>(); try { dt = ExcelUtil.ImportExcel(stream, cols); } catch (Exception ex) { //exception happened,some not caughted return(new Model.Result { Message = string.Format("数据导入错误,请选择正确的excel文件"), Status = false }); } if (dt == null) { //not all the cols mapped return(new Model.Result { Message = string.Format("请选择正确的excel文件!"), Status = false }); } List <DsWhProduct> productList = DsWhProductBo.Instance.GetProductModByDsSysNo(DealerSysNo); List <DsWhProduct> saveOrupdateList = new List <DsWhProduct>(); foreach (DataRow row in dt.Rows) { decimal price = 0; decimal.TryParse(row[DicColsMapping["ProPrice"]].ToString().Trim(), out price); decimal weight = 0; decimal.TryParse(row[DicColsMapping["ProWeight"]].ToString().Trim(), out weight); int SysNo = 0; DsWhProduct temppro = productList.Find(p => p.ProCode == row[DicColsMapping["ProCode"]].ToString().Trim()); if (temppro != null) { SysNo = temppro.SysNo; } DsWhProduct pro = new DsWhProduct() { Currency = row[DicColsMapping["Currency"]].ToString().Trim(), BrandName = row[DicColsMapping["BrandName"]].ToString().Trim(), CustomerCode = CusCode, DsSysNo = DealerSysNo, HsCode = row[DicColsMapping["HsCode"]].ToString().Trim(), ProCode = row[DicColsMapping["ProCode"]].ToString().Trim(), ProductEName = row[DicColsMapping["ProductEName"]].ToString().Trim(), ProductName = row[DicColsMapping["ProductName"]].ToString().Trim(), ProOrigin = row[DicColsMapping["ProOrigin"]].ToString().Trim(), ProSpec = row[DicColsMapping["ProSpec"]].ToString().Trim(), ProUnit = row[DicColsMapping["ProUnit"]].ToString().Trim(), ProPrice = price, ProWeight = weight, SysNo = SysNo }; saveOrupdateList.Add(pro); } foreach (var pro in saveOrupdateList) { if (pro.SysNo > 0) { UpdateMod(pro); } else { InsertMod(pro); } } return(new Model.Result { Message = "操作成功,通过商品编码检查导入的商品新增更新与否", Status = true }); }
/// <summary> /// 添加商品档案 /// </summary> /// <param name="Mod"></param> /// <returns></returns> public abstract int InsertMod(DsWhProduct Mod);