private static void GetProCatInfo(System.Data.DataSet dataset, List <ProductEntity> list)
{
var rows = dataset.Tables[0].Rows;
if (rows.Count > 2)
{
ProductCategoryProvider ProductCategory = new ProductCategoryProvider();
for (var i = 2; i < rows.Count; i++)
{
ProductEntity entity = new ProductEntity();
ProductCategoryEntity PCEntity = new ProductCategoryEntity();
var row = rows[i];
entity.SnNum = row[1].ToString();
if (string.IsNullOrEmpty(entity.SnNum))
{
continue;
}
entity.BarCode = row[2].ToString();
entity.ProductName = row[3].ToString();
entity.CateName = row[4].ToString();
PCEntity = ProductCategory.GetSingleCateName(entity.CateName);
if (PCEntity.IsNotNull())
{
entity.CateNum = PCEntity.CateNum;
}
else
{
entity.CateNum = "";
}
entity.Num = ConvertHelper.ToType <int>(row[5].ToString());
entity.MinNum = ConvertHelper.ToType <int>(row[6].ToString());
entity.MaxNum = ConvertHelper.ToType <int>(row[7].ToString());
entity.UnitName = row[8].ToString();
entity.UnitNum = entity.UnitNum;
entity.AvgPrice = ConvertHelper.ToType <double>(row[9].ToString());
entity.InPrice = ConvertHelper.ToType <double>(row[10].ToString());
entity.OutPrice = ConvertHelper.ToType <double>(row[11].ToString());
entity.NetWeight = ConvertHelper.ToType <double>(row[12].ToString());
entity.GrossWeight = ConvertHelper.ToType <double>(row[13].ToString());
entity.Remark = row[14].ToString();
entity.IsDelete = (int)EIsDelete.NotDelete;
entity.CreateTime = DateTime.Now;
list.Add(entity);
}
}
}
/// <summary>
/// 根据类别名称查询类别信息
/// </summary>
/// <param name="cateName"></param>
/// <returns></returns>
public ProductCategory_CE GetSingleCateName(string cateName)
{
if (cateName.IsEmpty())
{
return(null);
}
ProductCategoryProvider provider = new ProductCategoryProvider();
ProductCategoryEntity entity = provider.GetSingleCateName(cateName);
if (entity.IsNotNull())
{
ProductCategory_CE ce = ProductCategory_To.ToCE(entity);
return(ce);
}
return(null);
}