private void SaveData() { decimal _Loan = 0m; if (decimal.TryParse(M_Loan, out _Loan)) { Contract_Loan_Model CLM = new Contract_Loan_Model(); CLM.ContractID = UID; CLM.Card_ID = Card_ID; CLM.Card_Name = Card_Name; CLM.M_Loan = _Loan; CLM.Loan_Balance = _Loan; CLM.M_Loan_Months = int.Parse(M_Loan_Months); CLM.M_Replay_Type = M_Replay_Type; CLM.Current_Month = 1; CLM.M_Rate_Month = _M_Rate_Month; CLM.M_Rate_Year = _M_Rate_Year; CLM.UserID = RequestSession.GetSessionUser().UserId.ToString(); DateTime StartDate; if (DateTime.TryParse(Loan_StartDate.Value, out StartDate)) { CLM.Loan_StartDate = StartDate; string _SettleDate = ""; int _day = int.Parse(StartDate.ToString("dd")); if (_day < 20)//当月20号是第一期 { _SettleDate = string.Format("{0}-{1}-20", StartDate.Year, StartDate.Month); } else { _SettleDate = string.Format("{0}-{1}-20", StartDate.Year, StartDate.AddMonths(1).Month); } CLM.Loan_SettleDate = DateTime.Parse(_SettleDate); } bool reslt = ciday.Contract_Loan_Add(CLM); if (reslt) { this.Save.Visible = false; ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('操作成功!');setTimeout('OpenClose()','2000');</script>"); } else { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('操作失败!');</script>"); } } else { ClientScript.RegisterStartupScript(Page.GetType(), "", "<script language=javascript>layer.msg('贷款金额不合法!');</script>"); } }
public bool Contract_Loan_Add(Contract_Loan_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Contract_Loan("); strSql.Append("ContractID,Card_ID,Card_Name,M_Loan,Loan_Balance,M_Loan_Months,M_Replay_Type,Current_Month,Loan_StartDate,Loan_SettleDate,UserID,M_Rate_Month,M_Rate_Year)"); strSql.Append(" values ("); strSql.Append("@ContractID,@Card_ID,@Card_Name,@M_Loan,@Loan_Balance,@M_Loan_Months,@M_Replay_Type,@Current_Month,@Loan_StartDate,@Loan_SettleDate,@UserID,@M_Rate_Month,@M_Rate_Year)"); SqlParam[] param = new SqlParam[] { new SqlParam("@ContractID", model.ContractID), new SqlParam("@Card_ID", model.Card_ID), new SqlParam("@Card_Name", model.Card_Name), new SqlParam("@M_Loan", model.M_Loan), new SqlParam("@Loan_Balance", model.Loan_Balance), new SqlParam("@M_Loan_Months", model.M_Loan_Months), new SqlParam("@M_Replay_Type", model.M_Replay_Type), new SqlParam("@Current_Month", model.Current_Month), new SqlParam("@Loan_StartDate", model.Loan_StartDate), new SqlParam("@Loan_SettleDate", model.Loan_SettleDate), new SqlParam("@UserID", model.UserID), new SqlParam("@M_Rate_Month", model.M_Rate_Month), new SqlParam("@M_Rate_Year", model.M_Rate_Year) }; int rows = DataFactory.SqlDataBase().ExecuteBySql(strSql, param); if (rows > 0) { return(true); } else { return(false); } }