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