/// <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)); }