/// <summary>
/// ��������б�
/// </summary>
public List<XHD.Model.CRM_invoice> DataTableToList(DataTable dt)
{
List<XHD.Model.CRM_invoice> modelList = new List<XHD.Model.CRM_invoice>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
XHD.Model.CRM_invoice model;
for (int n = 0; n < rowsCount; n++)
{
model = new XHD.Model.CRM_invoice();
if(dt.Rows[n]["id"]!=null && dt.Rows[n]["id"].ToString()!="")
{
model.id=int.Parse(dt.Rows[n]["id"].ToString());
}
if(dt.Rows[n]["Customer_id"]!=null && dt.Rows[n]["Customer_id"].ToString()!="")
{
model.Customer_id=int.Parse(dt.Rows[n]["Customer_id"].ToString());
}
if(dt.Rows[n]["Customer_name"]!=null && dt.Rows[n]["Customer_name"].ToString()!="")
{
model.Customer_name=dt.Rows[n]["Customer_name"].ToString();
}
if(dt.Rows[n]["invoice_num"]!=null && dt.Rows[n]["invoice_num"].ToString()!="")
{
model.invoice_num=dt.Rows[n]["invoice_num"].ToString();
}
if(dt.Rows[n]["invoice_type_id"]!=null && dt.Rows[n]["invoice_type_id"].ToString()!="")
{
model.invoice_type_id=int.Parse(dt.Rows[n]["invoice_type_id"].ToString());
}
if(dt.Rows[n]["invoice_type"]!=null && dt.Rows[n]["invoice_type"].ToString()!="")
{
model.invoice_type=dt.Rows[n]["invoice_type"].ToString();
}
if(dt.Rows[n]["invoice_amount"]!=null && dt.Rows[n]["invoice_amount"].ToString()!="")
{
model.invoice_amount=decimal.Parse(dt.Rows[n]["invoice_amount"].ToString());
}
if(dt.Rows[n]["invoice_content"]!=null && dt.Rows[n]["invoice_content"].ToString()!="")
{
model.invoice_content=dt.Rows[n]["invoice_content"].ToString();
}
if(dt.Rows[n]["invoice_date"]!=null && dt.Rows[n]["invoice_date"].ToString()!="")
{
model.invoice_date=DateTime.Parse(dt.Rows[n]["invoice_date"].ToString());
}
if(dt.Rows[n]["C_depid"]!=null && dt.Rows[n]["C_depid"].ToString()!="")
{
model.C_depid=int.Parse(dt.Rows[n]["C_depid"].ToString());
}
if(dt.Rows[n]["C_depname"]!=null && dt.Rows[n]["C_depname"].ToString()!="")
{
model.C_depname=dt.Rows[n]["C_depname"].ToString();
}
if(dt.Rows[n]["C_empid"]!=null && dt.Rows[n]["C_empid"].ToString()!="")
{
model.C_empid=int.Parse(dt.Rows[n]["C_empid"].ToString());
}
if(dt.Rows[n]["C_empname"]!=null && dt.Rows[n]["C_empname"].ToString()!="")
{
model.C_empname=dt.Rows[n]["C_empname"].ToString();
}
if(dt.Rows[n]["create_id"]!=null && dt.Rows[n]["create_id"].ToString()!="")
{
model.create_id=int.Parse(dt.Rows[n]["create_id"].ToString());
}
if(dt.Rows[n]["create_name"]!=null && dt.Rows[n]["create_name"].ToString()!="")
{
model.create_name=dt.Rows[n]["create_name"].ToString();
}
if(dt.Rows[n]["create_date"]!=null && dt.Rows[n]["create_date"].ToString()!="")
{
model.create_date=DateTime.Parse(dt.Rows[n]["create_date"].ToString());
}
if(dt.Rows[n]["order_id"]!=null && dt.Rows[n]["order_id"].ToString()!="")
{
model.order_id=int.Parse(dt.Rows[n]["order_id"].ToString());
}
if(dt.Rows[n]["isDelete"]!=null && dt.Rows[n]["isDelete"].ToString()!="")
{
model.isDelete=int.Parse(dt.Rows[n]["isDelete"].ToString());
}
if(dt.Rows[n]["Delete_time"]!=null && dt.Rows[n]["Delete_time"].ToString()!="")
{
model.Delete_time=DateTime.Parse(dt.Rows[n]["Delete_time"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(XHD.Model.CRM_invoice model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.CRM_invoice model)
{
return(dal.Update(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <XHD.Model.CRM_invoice> DataTableToList(DataTable dt)
{
List <XHD.Model.CRM_invoice> modelList = new List <XHD.Model.CRM_invoice>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
XHD.Model.CRM_invoice model;
for (int n = 0; n < rowsCount; n++)
{
model = new XHD.Model.CRM_invoice();
if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
if (dt.Rows[n]["Customer_id"] != null && dt.Rows[n]["Customer_id"].ToString() != "")
{
model.Customer_id = int.Parse(dt.Rows[n]["Customer_id"].ToString());
}
if (dt.Rows[n]["Customer_name"] != null && dt.Rows[n]["Customer_name"].ToString() != "")
{
model.Customer_name = dt.Rows[n]["Customer_name"].ToString();
}
if (dt.Rows[n]["invoice_num"] != null && dt.Rows[n]["invoice_num"].ToString() != "")
{
model.invoice_num = dt.Rows[n]["invoice_num"].ToString();
}
if (dt.Rows[n]["invoice_type_id"] != null && dt.Rows[n]["invoice_type_id"].ToString() != "")
{
model.invoice_type_id = int.Parse(dt.Rows[n]["invoice_type_id"].ToString());
}
if (dt.Rows[n]["invoice_type"] != null && dt.Rows[n]["invoice_type"].ToString() != "")
{
model.invoice_type = dt.Rows[n]["invoice_type"].ToString();
}
if (dt.Rows[n]["invoice_amount"] != null && dt.Rows[n]["invoice_amount"].ToString() != "")
{
model.invoice_amount = decimal.Parse(dt.Rows[n]["invoice_amount"].ToString());
}
if (dt.Rows[n]["invoice_content"] != null && dt.Rows[n]["invoice_content"].ToString() != "")
{
model.invoice_content = dt.Rows[n]["invoice_content"].ToString();
}
if (dt.Rows[n]["invoice_date"] != null && dt.Rows[n]["invoice_date"].ToString() != "")
{
model.invoice_date = DateTime.Parse(dt.Rows[n]["invoice_date"].ToString());
}
if (dt.Rows[n]["C_depid"] != null && dt.Rows[n]["C_depid"].ToString() != "")
{
model.C_depid = int.Parse(dt.Rows[n]["C_depid"].ToString());
}
if (dt.Rows[n]["C_depname"] != null && dt.Rows[n]["C_depname"].ToString() != "")
{
model.C_depname = dt.Rows[n]["C_depname"].ToString();
}
if (dt.Rows[n]["C_empid"] != null && dt.Rows[n]["C_empid"].ToString() != "")
{
model.C_empid = int.Parse(dt.Rows[n]["C_empid"].ToString());
}
if (dt.Rows[n]["C_empname"] != null && dt.Rows[n]["C_empname"].ToString() != "")
{
model.C_empname = dt.Rows[n]["C_empname"].ToString();
}
if (dt.Rows[n]["create_id"] != null && dt.Rows[n]["create_id"].ToString() != "")
{
model.create_id = int.Parse(dt.Rows[n]["create_id"].ToString());
}
if (dt.Rows[n]["create_name"] != null && dt.Rows[n]["create_name"].ToString() != "")
{
model.create_name = dt.Rows[n]["create_name"].ToString();
}
if (dt.Rows[n]["create_date"] != null && dt.Rows[n]["create_date"].ToString() != "")
{
model.create_date = DateTime.Parse(dt.Rows[n]["create_date"].ToString());
}
if (dt.Rows[n]["order_id"] != null && dt.Rows[n]["order_id"].ToString() != "")
{
model.order_id = int.Parse(dt.Rows[n]["order_id"].ToString());
}
if (dt.Rows[n]["isDelete"] != null && dt.Rows[n]["isDelete"].ToString() != "")
{
model.isDelete = int.Parse(dt.Rows[n]["isDelete"].ToString());
}
if (dt.Rows[n]["Delete_time"] != null && dt.Rows[n]["Delete_time"].ToString() != "")
{
model.Delete_time = DateTime.Parse(dt.Rows[n]["Delete_time"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
