/// <summary>
/// 得到一个对象实体
/// </summary>
public M_income_statement GetModel(int income_statement_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 income_statement_id,targetid,bid_records_id,loan_number,borrower_registerid,annual_revenue,investment_amount,invest_time,current_investment_period,value_date,interest_payment_date,repayment_amount,repayment_period,investor_registerid,payment_status from hx_income_statement ");
strSql.Append(" where income_statement_id=@income_statement_id");
SqlParameter[] parameters =
{
new SqlParameter("@income_statement_id", SqlDbType.Int, 4)
};
parameters[0].Value = income_statement_id;
M_income_statement model = new M_income_statement();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(M_income_statement model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(M_income_statement model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(M_income_statement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hx_income_statement(");
strSql.Append("targetid,bid_records_id,loan_number,borrower_registerid,annual_revenue,investment_amount,invest_time,current_investment_period,value_date,interest_payment_date,repayment_amount,investor_registerid,payment_status,interestpayment,OutCustId,InCustId,BidOrderid,Principal,interestDay,TotalInstallments)");
strSql.Append(" values (");
strSql.Append("@targetid,@bid_records_id,@loan_number,@borrower_registerid,@annual_revenue,@investment_amount,@invest_time,@current_investment_period,@value_date,@interest_payment_date,@repayment_amount,@investor_registerid,@payment_status,@interestpayment,@OutCustId,@InCustId,@BidOrderid,@Principal,@interestDay,@TotalInstallments)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@targetid", SqlDbType.Int, 4),
new SqlParameter("@bid_records_id", SqlDbType.Int, 4),
new SqlParameter("@loan_number", SqlDbType.Decimal, 18),
new SqlParameter("@borrower_registerid", SqlDbType.Int, 4),
new SqlParameter("@annual_revenue", SqlDbType.Decimal, 17),
new SqlParameter("@investment_amount", SqlDbType.Decimal, 17),
new SqlParameter("@invest_time", SqlDbType.DateTime),
new SqlParameter("@current_investment_period", SqlDbType.Int, 4),
new SqlParameter("@value_date", SqlDbType.DateTime),
new SqlParameter("@interest_payment_date", SqlDbType.DateTime),
new SqlParameter("@repayment_amount", SqlDbType.Decimal, 17),
new SqlParameter("@investor_registerid", SqlDbType.Int, 4),
new SqlParameter("@payment_status", SqlDbType.Int, 4),
new SqlParameter("@interestpayment", SqlDbType.Decimal, 17),
new SqlParameter("@OutCustId", SqlDbType.VarChar, 50),
new SqlParameter("@InCustId", SqlDbType.VarChar, 50),
new SqlParameter("@BidOrderid", SqlDbType.Decimal, 20),
new SqlParameter("@Principal", SqlDbType.Decimal, 17),
new SqlParameter("@interestDay", SqlDbType.Int, 4),
new SqlParameter("@TotalInstallments", SqlDbType.Int, 4)
};
parameters[0].Value = model.targetid;
parameters[1].Value = model.bid_records_id;
parameters[2].Value = model.loan_number;
parameters[3].Value = model.borrower_registerid;
parameters[4].Value = model.annual_revenue;
parameters[5].Value = model.investment_amount;
parameters[6].Value = model.invest_time;
parameters[7].Value = model.current_investment_period;
parameters[8].Value = model.value_date;
parameters[9].Value = model.interest_payment_date;
parameters[10].Value = model.repayment_amount;
parameters[11].Value = model.investor_registerid;
parameters[12].Value = model.payment_status;
parameters[13].Value = model.interestpayment;
parameters[14].Value = model.OutCustId;
parameters[15].Value = model.InCustId;
parameters[16].Value = model.BidOrderid;
parameters[17].Value = model.Principal;
parameters[18].Value = model.interestDay;
parameters[19].Value = model.TotalInstallments;
List <string> slist = new List <string>();
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_income_statement DataRowToModel(DataRow row)
{
M_income_statement model = new M_income_statement();
if (row != null)
{
if (row["income_statement_id"] != null && row["income_statement_id"].ToString() != "")
{
model.income_statement_id = int.Parse(row["income_statement_id"].ToString());
}
if (row["targetid"] != null && row["targetid"].ToString() != "")
{
model.targetid = int.Parse(row["targetid"].ToString());
}
if (row["bid_records_id"] != null && row["bid_records_id"].ToString() != "")
{
model.bid_records_id = int.Parse(row["bid_records_id"].ToString());
}
if (row["loan_number"] != null && row["loan_number"].ToString() != "")
{
model.loan_number = decimal.Parse(row["loan_number"].ToString());
}
if (row["borrower_registerid"] != null && row["borrower_registerid"].ToString() != "")
{
model.borrower_registerid = int.Parse(row["borrower_registerid"].ToString());
}
if (row["annual_revenue"] != null && row["annual_revenue"].ToString() != "")
{
model.annual_revenue = decimal.Parse(row["annual_revenue"].ToString());
}
if (row["investment_amount"] != null && row["investment_amount"].ToString() != "")
{
model.investment_amount = decimal.Parse(row["investment_amount"].ToString());
}
if (row["invest_time"] != null && row["invest_time"].ToString() != "")
{
model.invest_time = DateTime.Parse(row["invest_time"].ToString());
}
if (row["current_investment_period"] != null && row["current_investment_period"].ToString() != "")
{
model.current_investment_period = int.Parse(row["current_investment_period"].ToString());
}
if (row["value_date"] != null && row["value_date"].ToString() != "")
{
model.value_date = DateTime.Parse(row["value_date"].ToString());
}
if (row["interest_payment_date"] != null && row["interest_payment_date"].ToString() != "")
{
model.interest_payment_date = DateTime.Parse(row["interest_payment_date"].ToString());
}
if (row["repayment_amount"] != null && row["repayment_amount"].ToString() != "")
{
model.repayment_amount = decimal.Parse(row["repayment_amount"].ToString());
}
if (row["repayment_period"] != null && row["repayment_period"].ToString() != "")
{
model.repayment_period = DateTime.Parse(row["repayment_period"].ToString());
}
if (row["investor_registerid"] != null && row["investor_registerid"].ToString() != "")
{
model.investor_registerid = int.Parse(row["investor_registerid"].ToString());
}
if (row["payment_status"] != null && row["payment_status"].ToString() != "")
{
model.payment_status = int.Parse(row["payment_status"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(M_income_statement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hx_income_statement set ");
strSql.Append("targetid=@targetid,");
strSql.Append("bid_records_id=@bid_records_id,");
strSql.Append("loan_number=@loan_number,");
strSql.Append("borrower_registerid=@borrower_registerid,");
strSql.Append("annual_revenue=@annual_revenue,");
strSql.Append("investment_amount=@investment_amount,");
strSql.Append("invest_time=@invest_time,");
strSql.Append("current_investment_period=@current_investment_period,");
strSql.Append("value_date=@value_date,");
strSql.Append("interest_payment_date=@interest_payment_date,");
strSql.Append("repayment_amount=@repayment_amount,");
strSql.Append("repayment_period=@repayment_period,");
strSql.Append("investor_registerid=@investor_registerid,");
strSql.Append("payment_status=@payment_status");
strSql.Append(" where income_statement_id=@income_statement_id");
SqlParameter[] parameters =
{
new SqlParameter("@targetid", SqlDbType.Int, 4),
new SqlParameter("@bid_records_id", SqlDbType.Int, 4),
new SqlParameter("@loan_number", SqlDbType.Decimal, 18),
new SqlParameter("@borrower_registerid", SqlDbType.Int, 4),
new SqlParameter("@annual_revenue", SqlDbType.Decimal, 17),
new SqlParameter("@investment_amount", SqlDbType.Decimal, 17),
new SqlParameter("@invest_time", SqlDbType.DateTime),
new SqlParameter("@current_investment_period", SqlDbType.Int, 4),
new SqlParameter("@value_date", SqlDbType.DateTime),
new SqlParameter("@interest_payment_date", SqlDbType.DateTime),
new SqlParameter("@repayment_amount", SqlDbType.Decimal, 17),
new SqlParameter("@repayment_period", SqlDbType.DateTime),
new SqlParameter("@investor_registerid", SqlDbType.Int, 4),
new SqlParameter("@payment_status", SqlDbType.Int, 4),
new SqlParameter("@income_statement_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.targetid;
parameters[1].Value = model.bid_records_id;
parameters[2].Value = model.loan_number;
parameters[3].Value = model.borrower_registerid;
parameters[4].Value = model.annual_revenue;
parameters[5].Value = model.investment_amount;
parameters[6].Value = model.invest_time;
parameters[7].Value = model.current_investment_period;
parameters[8].Value = model.value_date;
parameters[9].Value = model.interest_payment_date;
parameters[10].Value = model.repayment_amount;
parameters[11].Value = model.repayment_period;
parameters[12].Value = model.investor_registerid;
parameters[13].Value = model.payment_status;
parameters[14].Value = model.income_statement_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
