/// <summary>
///
/// </summary>
/// <param name="iContactId"></param>
/// <param name="sMonthlySalar"></param>
/// <param name="sOtherMonthlyIncome"></param>
private void UpdateProspectIncome(int iProspectIncomeID, string sMonthlySalar, string sOtherMonthlyIncome)
{
#region update ProspectIncome
ProspectIncome ProspectIncomeMgr = new ProspectIncome();
LPWeb.Model.ProspectIncome ProspectIncomeModel = ProspectIncomeMgr.GetModel(iProspectIncomeID);
if (sMonthlySalar == string.Empty)
{
ProspectIncomeModel.Salary = null;
}
else
{
ProspectIncomeModel.Salary = Convert.ToDecimal(sMonthlySalar);
}
if (sOtherMonthlyIncome == string.Empty)
{
ProspectIncomeModel.Other = null;
}
else
{
ProspectIncomeModel.Other = Convert.ToDecimal(sOtherMonthlyIncome);
}
ProspectIncomeMgr.Update(ProspectIncomeModel);
#endregion
}
/// <summary>
///
/// </summary>
/// <param name="iContactId"></param>
/// <param name="sMonthlySalar"></param>
/// <param name="sOtherMonthlyIncome"></param>
private void CreateProspectIncome(int iContactId, string sMonthlySalar, string sOtherMonthlyIncome)
{
#region create ProspectIncome
LPWeb.Model.ProspectIncome ProspectIncomeModel = new LPWeb.Model.ProspectIncome();
ProspectIncomeModel.ContactId = iContactId;
if (sMonthlySalar == string.Empty)
{
ProspectIncomeModel.Salary = null;
}
else
{
ProspectIncomeModel.Salary = Convert.ToDecimal(sMonthlySalar);
}
if (sOtherMonthlyIncome == string.Empty)
{
ProspectIncomeModel.Other = null;
}
else
{
ProspectIncomeModel.Other = Convert.ToDecimal(sOtherMonthlyIncome);
}
ProspectIncome ProspectIncomeMgr = new ProspectIncome();
ProspectIncomeMgr.Add(ProspectIncomeModel);
#endregion
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <LPWeb.Model.ProspectIncome> DataTableToList(DataTable dt)
{
List <LPWeb.Model.ProspectIncome> modelList = new List <LPWeb.Model.ProspectIncome>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LPWeb.Model.ProspectIncome model;
for (int n = 0; n < rowsCount; n++)
{
model = new LPWeb.Model.ProspectIncome();
if (dt.Rows[n]["ProspectIncomeId"] != null && dt.Rows[n]["ProspectIncomeId"].ToString() != "")
{
model.ProspectIncomeId = int.Parse(dt.Rows[n]["ProspectIncomeId"].ToString());
}
if (dt.Rows[n]["ContactId"] != null && dt.Rows[n]["ContactId"].ToString() != "")
{
model.ContactId = int.Parse(dt.Rows[n]["ContactId"].ToString());
}
if (dt.Rows[n]["Salary"] != null && dt.Rows[n]["Salary"].ToString() != "")
{
model.Salary = decimal.Parse(dt.Rows[n]["Salary"].ToString());
}
if (dt.Rows[n]["Overtime"] != null && dt.Rows[n]["Overtime"].ToString() != "")
{
model.Overtime = decimal.Parse(dt.Rows[n]["Overtime"].ToString());
}
if (dt.Rows[n]["Bonuses"] != null && dt.Rows[n]["Bonuses"].ToString() != "")
{
model.Bonuses = decimal.Parse(dt.Rows[n]["Bonuses"].ToString());
}
if (dt.Rows[n]["Commission"] != null && dt.Rows[n]["Commission"].ToString() != "")
{
model.Commission = decimal.Parse(dt.Rows[n]["Commission"].ToString());
}
if (dt.Rows[n]["Div_Int"] != null && dt.Rows[n]["Div_Int"].ToString() != "")
{
model.Div_Int = decimal.Parse(dt.Rows[n]["Div_Int"].ToString());
}
if (dt.Rows[n]["NetRent"] != null && dt.Rows[n]["NetRent"].ToString() != "")
{
model.NetRent = decimal.Parse(dt.Rows[n]["NetRent"].ToString());
}
if (dt.Rows[n]["Other"] != null && dt.Rows[n]["Other"].ToString() != "")
{
model.Other = decimal.Parse(dt.Rows[n]["Other"].ToString());
}
if (dt.Rows[n]["EmplId"] != null && dt.Rows[n]["EmplId"].ToString() != "")
{
model.EmplId = int.Parse(dt.Rows[n]["EmplId"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LPWeb.Model.ProspectIncome model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.ProspectIncome model)
{
return(dal.Add(model));
}
