/// <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);
