/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.gp_BusinessNotes model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.gp_BusinessNotes model)
{
return(dal.Update(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <lgk.Model.gp_BusinessNotes> DataTableToList(DataTable dt)
{
List <lgk.Model.gp_BusinessNotes> modelList = new List <lgk.Model.gp_BusinessNotes>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
lgk.Model.gp_BusinessNotes model;
for (int n = 0; n < rowsCount; n++)
{
model = new lgk.Model.gp_BusinessNotes();
if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "")
{
model.ID = long.Parse(dt.Rows[n]["ID"].ToString());
}
if (dt.Rows[n]["UserID"] != null && dt.Rows[n]["UserID"].ToString() != "")
{
model.UserID = long.Parse(dt.Rows[n]["UserID"].ToString());
}
if (dt.Rows[n]["UserCode"] != null && dt.Rows[n]["UserCode"].ToString() != "")
{
model.UserCode = dt.Rows[n]["UserCode"].ToString();
}
if (dt.Rows[n]["BusinessType"] != null && dt.Rows[n]["BusinessType"].ToString() != "")
{
model.BusinessType = int.Parse(dt.Rows[n]["BusinessType"].ToString());
}
if (dt.Rows[n]["UserType"] != null && dt.Rows[n]["UserType"].ToString() != "")
{
model.UserType = int.Parse(dt.Rows[n]["UserType"].ToString());
}
if (dt.Rows[n]["BusinessTime"] != null && dt.Rows[n]["BusinessTime"].ToString() != "")
{
model.BusinessTime = DateTime.Parse(dt.Rows[n]["BusinessTime"].ToString());
}
if (dt.Rows[n]["BusinessAmount"] != null && dt.Rows[n]["BusinessAmount"].ToString() != "")
{
model.BusinessAmount = decimal.Parse(dt.Rows[n]["BusinessAmount"].ToString());
}
if (dt.Rows[n]["BusinessPrice"] != null && dt.Rows[n]["BusinessPrice"].ToString() != "")
{
model.BusinessPrice = decimal.Parse(dt.Rows[n]["BusinessPrice"].ToString());
}
if (dt.Rows[n]["SumMoney"] != null && dt.Rows[n]["SumMoney"].ToString() != "")
{
model.SumMoney = decimal.Parse(dt.Rows[n]["SumMoney"].ToString());
}
if (dt.Rows[n]["Poundage"] != null && dt.Rows[n]["Poundage"].ToString() != "")
{
model.Poundage = decimal.Parse(dt.Rows[n]["Poundage"].ToString());
}
if (dt.Rows[n]["AmountMoney"] != null && dt.Rows[n]["AmountMoney"].ToString() != "")
{
model.AmountMoney = decimal.Parse(dt.Rows[n]["AmountMoney"].ToString());
}
if (dt.Rows[n]["InStockAccount"] != null && dt.Rows[n]["InStockAccount"].ToString() != "")
{
model.InStockAccount = decimal.Parse(dt.Rows[n]["InStockAccount"].ToString());
}
if (dt.Rows[n]["InBonusAccount"] != null && dt.Rows[n]["InBonusAccount"].ToString() != "")
{
model.InBonusAccount = decimal.Parse(dt.Rows[n]["InBonusAccount"].ToString());
}
if (dt.Rows[n]["InManageAccount"] != null && dt.Rows[n]["InManageAccount"].ToString() != "")
{
model.InManageAccount = decimal.Parse(dt.Rows[n]["InManageAccount"].ToString());
}
if (dt.Rows[n]["FromUserID"] != null && dt.Rows[n]["FromUserID"].ToString() != "")
{
model.FromUserID = long.Parse(dt.Rows[n]["FromUserID"].ToString());
}
if (dt.Rows[n]["FromUserCode"] != null && dt.Rows[n]["FromUserCode"].ToString() != "")
{
model.FromUserCode = dt.Rows[n]["FromUserCode"].ToString();
}
if (dt.Rows[n]["SucTime"] != null && dt.Rows[n]["SucTime"].ToString() != "")
{
model.SucTime = DateTime.Parse(dt.Rows[n]["SucTime"].ToString());
}
if (dt.Rows[n]["Status"] != null && dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["Notes01"] != null && dt.Rows[n]["Notes01"].ToString() != "")
{
model.Notes01 = int.Parse(dt.Rows[n]["Notes01"].ToString());
}
if (dt.Rows[n]["Notes02"] != null && dt.Rows[n]["Notes02"].ToString() != "")
{
model.Notes02 = int.Parse(dt.Rows[n]["Notes02"].ToString());
}
if (dt.Rows[n]["Notes03"] != null && dt.Rows[n]["Notes03"].ToString() != "")
{
model.Notes03 = decimal.Parse(dt.Rows[n]["Notes03"].ToString());
}
if (dt.Rows[n]["Notes04"] != null && dt.Rows[n]["Notes04"].ToString() != "")
{
model.Notes04 = decimal.Parse(dt.Rows[n]["Notes04"].ToString());
}
if (dt.Rows[n]["Notes05"] != null && dt.Rows[n]["Notes05"].ToString() != "")
{
model.Notes05 = dt.Rows[n]["Notes05"].ToString();
}
if (dt.Rows[n]["Notes06"] != null && dt.Rows[n]["Notes06"].ToString() != "")
{
model.Notes06 = dt.Rows[n]["Notes06"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
