/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.StockMaterielDemand model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.StockMaterielDemand model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Hownet.Model.StockMaterielDemand> DataTableToList(DataTable dt)
{
List <Hownet.Model.StockMaterielDemand> modelList = new List <Hownet.Model.StockMaterielDemand>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
try
{
Hownet.Model.StockMaterielDemand model;
for (int n = 0; n < rowsCount; n++)
{
model = new Hownet.Model.StockMaterielDemand();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
else
{
model.ID = 0;
}
if (dt.Rows[n]["PlanID"].ToString() != "")
{
model.PlanID = int.Parse(dt.Rows[n]["PlanID"].ToString());
}
else
{
model.PlanID = 0;
}
if (dt.Rows[n]["MaterielID"].ToString() != "")
{
model.MaterielID = int.Parse(dt.Rows[n]["MaterielID"].ToString());
}
else
{
model.MaterielID = 0;
}
if (dt.Rows[n]["ColorID"].ToString() != "")
{
model.ColorID = int.Parse(dt.Rows[n]["ColorID"].ToString());
}
else
{
model.ColorID = 0;
}
if (dt.Rows[n]["ColorOneID"].ToString() != "")
{
model.ColorOneID = int.Parse(dt.Rows[n]["ColorOneID"].ToString());
}
else
{
model.ColorOneID = 0;
}
if (dt.Rows[n]["ColorTwoID"].ToString() != "")
{
model.ColorTwoID = int.Parse(dt.Rows[n]["ColorTwoID"].ToString());
}
else
{
model.ColorTwoID = 0;
}
if (dt.Rows[n]["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(dt.Rows[n]["Amount"].ToString());
}
else
{
model.Amount = 0;
}
if (dt.Rows[n]["NotAllotAmount"].ToString() != "")
{
model.NotAllotAmount = decimal.Parse(dt.Rows[n]["NotAllotAmount"].ToString());
}
else
{
model.NotAllotAmount = 0;
}
if (dt.Rows[n]["stockAmount"].ToString() != "")
{
model.stockAmount = decimal.Parse(dt.Rows[n]["stockAmount"].ToString());
}
else
{
model.stockAmount = 0;
}
if (dt.Rows[n]["stockNotAmount"].ToString() != "")
{
model.stockNotAmount = decimal.Parse(dt.Rows[n]["stockNotAmount"].ToString());
}
else
{
model.stockNotAmount = 0;
}
if (dt.Rows[n]["SizeID"].ToString() != "")
{
model.SizeID = int.Parse(dt.Rows[n]["SizeID"].ToString());
}
else
{
model.SizeID = 0;
}
if (dt.Rows[n]["MeasureID"].ToString() != "")
{
model.MeasureID = int.Parse(dt.Rows[n]["MeasureID"].ToString());
}
else
{
model.MeasureID = 0;
}
if (dt.Rows[n]["DepID"].ToString() != "")
{
model.DepID = int.Parse(dt.Rows[n]["DepID"].ToString());
}
else
{
model.DepID = 0;
}
if (dt.Rows[n]["MListID"].ToString() != "")
{
model.MListID = int.Parse(dt.Rows[n]["MListID"].ToString());
}
else
{
model.MListID = 0;
}
if (dt.Rows[n]["MainID"].ToString() != "")
{
model.MainID = int.Parse(dt.Rows[n]["MainID"].ToString());
}
else
{
model.MainID = 0;
}
if (dt.Rows[n]["IsEnd"].ToString() != "")
{
model.IsEnd = int.Parse(dt.Rows[n]["IsEnd"].ToString());
}
else
{
model.IsEnd = 0;
}
if (dt.Rows[n]["RepertoryAmount"].ToString() != "")
{
model.RepertoryAmount = decimal.Parse(dt.Rows[n]["RepertoryAmount"].ToString());
}
else
{
model.RepertoryAmount = 0;
}
if (dt.Rows[n]["NeedAmount"].ToString() != "")
{
model.NeedAmount = decimal.Parse(dt.Rows[n]["NeedAmount"].ToString());
}
else
{
model.NeedAmount = 0;
}
if (dt.Rows[n]["HasStockAmount"].ToString() != "")
{
model.HasStockAmount = decimal.Parse(dt.Rows[n]["HasStockAmount"].ToString());
}
else
{
model.HasStockAmount = 0;
}
if (dt.Rows[n]["OutAmount"].ToString() != "")
{
model.OutAmount = decimal.Parse(dt.Rows[n]["OutAmount"].ToString());
}
else
{
model.OutAmount = 0;
}
model.A = int.Parse(dt.Rows[n]["A"].ToString());
modelList.Add(model);
}
}
catch (Exception ex)
{ }
}
return(modelList);
}
