/// <summary>
/// GoodsInfoHelper 转换为 GoodsInfo
/// </summary>
/// <param name="goodsInfoHelper"></param>
/// <returns></returns>
public GoodsInfo GetGoodsInfo(GoodsInfoHelper goodsInfoHelper)
{
GoodsInfo goodsInfo = new GoodsInfo();
var sort = goodsInfoHelper.SortName;
var unit = goodsInfoHelper.UnitName;
var wholeSalerName = goodsInfoHelper.WholeSalerName;
//将Sort 转换为SortID
//在sort表中查询是否有该数据,有则返回ID 无则添加该类型 后返回ID
int sortId = sortInfoDal.GetSortIdByName(sort);
if (sortId == int.MaxValue)
{
//添加该类型
SortInfo sortInfo = new SortInfo();
sortInfo.SortName = sort;
sortInfo.DelFlag = false;
sortId = sortInfoDal.GetIdByAdd(sortInfo);
}
int unitId = unitInfoDal.GetUnitIdByName(unit);
if (unitId == int.MaxValue)
{
//添加该类型
UnitInfo unitInfo = new UnitInfo();
unitInfo.UnitName = unit;
unitInfo.DelFlag = false;
sortId = unitInfoDal.GetIdByAdd(unitInfo);
}
int wholesalerId = wholeSalerInfoDal.GetWholeSaleIdByName(wholeSalerName);
if (wholesalerId == int.MaxValue)
{
WholeSalerInfo wholeSalerInfo = new WholeSalerInfo();
wholeSalerInfo.SupName = wholeSalerName;
wholeSalerInfo.Management = "未知";
wholeSalerInfo.AddressInfo = "未知";
wholeSalerInfo.TelePhone = "未知";
wholeSalerInfo.AddressInfo = "未知";
wholeSalerInfo.DelFlag = false;
wholesalerId = wholeSalerInfoDal.GetIdByAdd(wholeSalerInfo);
}
goodsInfo.GoodsName = goodsInfoHelper.GoodsName;
goodsInfo.GoodsType = goodsInfoHelper.GoodsType;
goodsInfo.CreateTime = DateTime.Now;
goodsInfo.LastTime = goodsInfoHelper.LastTime;
goodsInfo.PayPrice = goodsInfoHelper.PayPrice;
goodsInfo.PurPrice = goodsInfoHelper.PurPrice;
goodsInfo.Remark = goodsInfoHelper.Remark;
goodsInfo.SalesCount = goodsInfoHelper.SalesCount;
goodsInfo.SurplusCount = goodsInfoHelper.SurplusCount;
goodsInfo.Total = goodsInfoHelper.Total;
goodsInfo.UnitId = unitId;
goodsInfo.SortId = sortId;
goodsInfo.WholeSalerId = wholesalerId;
return(goodsInfo);
}
/// <summary>
/// 将dataTable的一行转换为GoodsInfoHelper
/// </summary>
/// <param name="dataRow"></param>
/// <returns></returns>
public GoodsInfoHelper GetGoodsInfoHelperByDataRow(DataRow dataRow, out string errorMessage)
{
errorMessage = "";
GoodsInfoHelper goodsInfoHelper = new GoodsInfoHelper();
try
{
goodsInfoHelper.GoodsName = dataRow[0].ToString();
goodsInfoHelper.SortName = dataRow[1].ToString();
goodsInfoHelper.UnitName = dataRow[2].ToString();
goodsInfoHelper.GoodsType = dataRow[3].ToString();
goodsInfoHelper.Total = Convert.ToDouble(dataRow[4].ToString());
goodsInfoHelper.SalesCount = Convert.ToDouble(dataRow[5].ToString());
goodsInfoHelper.SurplusCount = Convert.ToDouble(dataRow[6].ToString());
goodsInfoHelper.PurPrice = Convert.ToDecimal(dataRow[7].ToString());
goodsInfoHelper.PayPrice = Convert.ToDecimal(dataRow[8].ToString());
goodsInfoHelper.CreateTime = DateTime.Now;
if (dataRow[9].ToString() == "")
{
goodsInfoHelper.WholeSalerName = "未知";
}
else
{
goodsInfoHelper.WholeSalerName = dataRow[9].ToString();
}
if (dataRow[10].ToString() != "")
{
goodsInfoHelper.LastTime = Convert.ToDateTime(dataRow[10].ToString());
}
goodsInfoHelper.Remark = dataRow[11].ToString();
return(goodsInfoHelper);
}
catch (Exception error)
{
errorMessage = error.Message;
//该行有数据出错
return(null);
}
}
