/// <summary>
/// 获得数据列表
/// </summary>
public List <ZhangWei.Model.Sale> DataTableToList(DataTable dt)
{
List <ZhangWei.Model.Sale> modelList = new List <ZhangWei.Model.Sale>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
ZhangWei.Model.Sale model;
for (int n = 0; n < rowsCount; n++)
{
model = new ZhangWei.Model.Sale();
if (dt.Rows[n]["Sale_ID"] != null && dt.Rows[n]["Sale_ID"].ToString() != "")
{
model.Sale_ID = int.Parse(dt.Rows[n]["Sale_ID"].ToString());
}
if (dt.Rows[n]["SaleDate"] != null && dt.Rows[n]["SaleDate"].ToString() != "")
{
model.SaleDate = DateTime.Parse(dt.Rows[n]["SaleDate"].ToString());
}
if (dt.Rows[n]["TradeNo"] != null && dt.Rows[n]["TradeNo"].ToString() != "")
{
model.TradeNo = dt.Rows[n]["TradeNo"].ToString();
}
if (dt.Rows[n]["Dept_ID"] != null && dt.Rows[n]["Dept_ID"].ToString() != "")
{
model.Dept_ID = int.Parse(dt.Rows[n]["Dept_ID"].ToString());
}
if (dt.Rows[n]["Employee_ID"] != null && dt.Rows[n]["Employee_ID"].ToString() != "")
{
model.Employee_ID = int.Parse(dt.Rows[n]["Employee_ID"].ToString());
}
if (dt.Rows[n]["StoreHouse_ID"] != null && dt.Rows[n]["StoreHouse_ID"].ToString() != "")
{
model.StoreHouse_ID = int.Parse(dt.Rows[n]["StoreHouse_ID"].ToString());
}
if (dt.Rows[n]["Address"] != null && dt.Rows[n]["Address"].ToString() != "")
{
model.Address = dt.Rows[n]["Address"].ToString();
}
if (dt.Rows[n]["Account"] != null && dt.Rows[n]["Account"].ToString() != "")
{
model.Account = dt.Rows[n]["Account"].ToString();
}
if (dt.Rows[n]["GatheringWay"] != null && dt.Rows[n]["GatheringWay"].ToString() != "")
{
model.GatheringWay = dt.Rows[n]["GatheringWay"].ToString();
}
if (dt.Rows[n]["Customer"] != null && dt.Rows[n]["Customer"].ToString() != "")
{
model.Customer = int.Parse(dt.Rows[n]["Customer"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ZhangWei.Model.Sale model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZhangWei.Model.Sale model)
{
return(dal.Add(model));
}
