/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.UserProspectColumns model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <LPWeb.Model.UserProspectColumns> DataTableToList(DataTable dt)
{
List <LPWeb.Model.UserProspectColumns> modelList = new List <LPWeb.Model.UserProspectColumns>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LPWeb.Model.UserProspectColumns model;
for (int n = 0; n < rowsCount; n++)
{
model = new LPWeb.Model.UserProspectColumns();
if (dt.Rows[0]["UserId"].ToString() != "")
{
model.UserId = int.Parse(dt.Rows[0]["UserId"].ToString());
}
if (dt.Rows[0]["Pv_Created"].ToString() != "")
{
if ((dt.Rows[0]["Pv_Created"].ToString() == "1") || (dt.Rows[0]["Pv_Created"].ToString().ToLower() == "true"))
{
model.Pv_Created = true;
}
else
{
model.Pv_Created = false;
}
}
if (dt.Rows[0]["PV_LeadSource"].ToString() != "")
{
if ((dt.Rows[0]["PV_LeadSource"].ToString() == "1") || (dt.Rows[0]["PV_LeadSource"].ToString().ToLower() == "true"))
{
model.Pv_Leadsource = true;
}
else
{
model.Pv_Leadsource = false;
}
}
if (dt.Rows[0]["PV_RefCode"].ToString() != "")
{
if ((dt.Rows[0]["PV_RefCode"].ToString() == "1") || (dt.Rows[0]["PV_RefCode"].ToString().ToLower() == "true"))
{
model.Pv_Refcode = true;
}
else
{
model.Pv_Refcode = false;
}
}
if (dt.Rows[0]["PV_LoanOfficer"].ToString() != "")
{
if ((dt.Rows[0]["PV_LoanOfficer"].ToString() == "1") || (dt.Rows[0]["PV_LoanOfficer"].ToString().ToLower() == "true"))
{
model.Pv_Loanofficer = true;
}
else
{
model.Pv_Loanofficer = false;
}
}
if (dt.Rows[0]["PV_Branch"].ToString() != "")
{
if ((dt.Rows[0]["PV_Branch"].ToString() == "1") || (dt.Rows[0]["PV_Branch"].ToString().ToLower() == "true"))
{
model.Pv_Branch = true;
}
else
{
model.Pv_Branch = false;
}
}
if (dt.Rows[0]["PV_Progress"].ToString() != "")
{
if ((dt.Rows[0]["PV_Progress"].ToString() == "1") || (dt.Rows[0]["PV_Progress"].ToString().ToLower() == "true"))
{
model.Pv_Progress = true;
}
else
{
model.Pv_Progress = false;
}
}
if (dt.Rows[0]["LV_Ranking"].ToString() != "")
{
if ((dt.Rows[0]["LV_Ranking"].ToString() == "1") || (dt.Rows[0]["LV_Ranking"].ToString().ToLower() == "true"))
{
model.Lv_Ranking = true;
}
else
{
model.Lv_Ranking = false;
}
}
if (dt.Rows[0]["LV_Amount"].ToString() != "")
{
if ((dt.Rows[0]["LV_Amount"].ToString() == "1") || (dt.Rows[0]["LV_Amount"].ToString().ToLower() == "true"))
{
model.Lv_Amount = true;
}
else
{
model.Lv_Amount = false;
}
}
if (dt.Rows[0]["LV_Rate"].ToString() != "")
{
if ((dt.Rows[0]["LV_Rate"].ToString() == "1") || (dt.Rows[0]["LV_Rate"].ToString().ToLower() == "true"))
{
model.Lv_Rate = true;
}
else
{
model.Lv_Rate = false;
}
}
if (dt.Rows[0]["LV_LoanOfficer"].ToString() != "")
{
if ((dt.Rows[0]["LV_LoanOfficer"].ToString() == "1") || (dt.Rows[0]["LV_LoanOfficer"].ToString().ToLower() == "true"))
{
model.Lv_Loanofficer = true;
}
else
{
model.Lv_Loanofficer = false;
}
}
if (dt.Rows[0]["LV_Lien"].ToString() != "")
{
if ((dt.Rows[0]["LV_Lien"].ToString() == "1") || (dt.Rows[0]["LV_Lien"].ToString().ToLower() == "true"))
{
model.Lv_Lien = true;
}
else
{
model.Lv_Lien = false;
}
}
if (dt.Rows[0]["LV_Progress"].ToString() != "")
{
if ((dt.Rows[0]["LV_Progress"].ToString() == "1") || (dt.Rows[0]["LV_Progress"].ToString().ToLower() == "true"))
{
model.Lv_Progress = true;
}
else
{
model.Lv_Progress = false;
}
}
if (dt.Rows[0]["LV_Branch"].ToString() != "")
{
if ((dt.Rows[0]["LV_Branch"].ToString() == "1") || (dt.Rows[0]["LV_Branch"].ToString().ToLower() == "true"))
{
model.Lv_Branch = true;
}
else
{
model.Lv_Branch = false;
}
}
if (dt.Rows[0]["LV_LoanProgram"].ToString() != "")
{
if ((dt.Rows[0]["LV_LoanProgram"].ToString() == "1") || (dt.Rows[0]["LV_LoanProgram"].ToString().ToLower() == "true"))
{
model.Lv_Loanprogram = true;
}
else
{
model.Lv_Loanprogram = false;
}
}
if (dt.Rows[0]["LV_LeadSource"].ToString() != "")
{
if ((dt.Rows[0]["LV_LeadSource"].ToString() == "1") || (dt.Rows[0]["LV_LeadSource"].ToString().ToLower() == "true"))
{
model.Lv_Leadsource = true;
}
else
{
model.Lv_Leadsource = false;
}
}
if (dt.Rows[0]["LV_RefCode"].ToString() != "")
{
if ((dt.Rows[0]["LV_RefCode"].ToString() == "1") || (dt.Rows[0]["LV_RefCode"].ToString().ToLower() == "true"))
{
model.Lv_Refcode = true;
}
else
{
model.Lv_Refcode = false;
}
}
if (dt.Rows[0]["LV_EstClose"].ToString() != "")
{
if ((dt.Rows[0]["LV_EstClose"].ToString() == "1") || (dt.Rows[0]["LV_EstClose"].ToString().ToLower() == "true"))
{
model.Lv_Estclose = true;
}
else
{
model.Lv_Estclose = false;
}
}
if (dt.Rows[0]["LV_PointFilename"].ToString() != "")
{
if ((dt.Rows[0]["LV_PointFilename"].ToString() == "1") || (dt.Rows[0]["LV_PointFilename"].ToString().ToLower() == "true"))
{
model.Lv_Pointfilename = true;
}
else
{
model.Lv_Pointfilename = false;
}
}
if (dt.Rows[n]["PV_Referral"].ToString() != "")
{
if ((dt.Rows[n]["PV_Referral"].ToString() == "1") || (dt.Rows[n]["PV_Referral"].ToString().ToLower() == "true"))
{
model.Pv_Referral = true;
}
else
{
model.Pv_Referral = false;
}
}
if (dt.Rows[n]["PV_Partner"].ToString() != "")
{
if ((dt.Rows[n]["PV_Partner"].ToString() == "1") || (dt.Rows[n]["PV_Partner"].ToString().ToLower() == "true"))
{
model.Pv_Partner = true;
}
else
{
model.Pv_Partner = false;
}
}
if (dt.Rows[n]["LV_Referral"].ToString() != "")
{
if ((dt.Rows[n]["LV_Referral"].ToString() == "1") || (dt.Rows[n]["LV_Referral"].ToString().ToLower() == "true"))
{
model.Lv_Referral = true;
}
else
{
model.Lv_Referral = false;
}
}
if (dt.Rows[n]["LV_Partner"].ToString() != "")
{
if ((dt.Rows[n]["LV_Partner"].ToString() == "1") || (dt.Rows[n]["LV_Partner"].ToString().ToLower() == "true"))
{
model.Lv_Partner = true;
}
else
{
model.Lv_Partner = false;
}
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(LPWeb.Model.UserProspectColumns model)
{
dal.Add(model);
}
