public int Add(SqlTransaction trans, PrjReturnModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Fund_Prj_Loan_Return(");
builder.Append("FR_id,LoanID,FR_name,FR_data,FR_Money,FR_interest,FR_deduct,FR_remark,FR_flowState,FR_user,FR_Time,FR_Code)");
builder.Append(" values (");
builder.Append("@FR_id,@LoanID,@FR_name,@FR_data,@FR_Money,@FR_interest,@FR_deduct,@FR_remark,@FR_flowState,@FR_user,@FR_Time,@FR_Code)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@FR_id", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@LoanID", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@FR_name", SqlDbType.VarChar, 8), new SqlParameter("@FR_data", SqlDbType.DateTime), new SqlParameter("@FR_Money", SqlDbType.Decimal, 9), new SqlParameter("@FR_interest", SqlDbType.Decimal, 9), new SqlParameter("@FR_deduct", SqlDbType.Decimal, 9), new SqlParameter("@FR_remark", SqlDbType.VarChar, 0x3e8), new SqlParameter("@FR_flowState", SqlDbType.Int, 4), new SqlParameter("@FR_user", SqlDbType.VarChar, 8), new SqlParameter("@FR_Time", SqlDbType.DateTime), new SqlParameter("@FR_Code", SqlDbType.NChar, 14) };
commandParameters[0].Value = model.FR_id;
commandParameters[1].Value = model.LoanID;
commandParameters[2].Value = model.FR_name;
commandParameters[3].Value = model.FR_data;
commandParameters[4].Value = model.FR_Money;
commandParameters[5].Value = model.FR_interest;
commandParameters[6].Value = model.FR_deduct;
commandParameters[7].Value = model.FR_remark;
commandParameters[8].Value = model.FR_flowState;
commandParameters[9].Value = model.FR_user;
commandParameters[10].Value = model.FR_Time;
commandParameters[11].Value = model.FR_Code;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public PrjReturnModel GetModel(Guid FR_id)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 FR_id,LoanID,FR_name,FR_data,FR_Money,FR_interest,FR_deduct,FR_remark,FR_flowState,FR_user,FR_Time,FR_Code from Fund_Prj_Loan_Return ");
builder.Append(" where FR_id=@FR_id ");
PrjReturnModel model = null;
using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@FR_id", FR_id) }))
{
if (reader.Read())
{
model = this.ReaderBind(reader);
}
}
return(model);
}
public PrjReturnModel ReaderBind(IDataReader dataReader)
{
PrjReturnModel model = new PrjReturnModel();
if (dataReader["FR_Code"].ToString() != "")
{
model.FR_Code = dataReader["FR_Code"].ToString();
}
if (dataReader["FR_id"].ToString() != "")
{
model.FR_id = new Guid(dataReader["FR_id"].ToString());
}
if (dataReader["LoanID"].ToString() != "")
{
model.LoanID = new Guid(dataReader["LoanID"].ToString());
}
model.FR_name = dataReader["FR_name"].ToString();
if (dataReader["FR_data"].ToString() != "")
{
model.FR_data = new DateTime?(DateTime.Parse(dataReader["FR_data"].ToString()));
}
if (dataReader["FR_Money"].ToString() != "")
{
model.FR_Money = new decimal?(decimal.Parse(dataReader["FR_Money"].ToString()));
}
if (dataReader["FR_interest"].ToString() != "")
{
model.FR_interest = new decimal?(decimal.Parse(dataReader["FR_interest"].ToString()));
}
if (dataReader["FR_deduct"].ToString() != "")
{
model.FR_deduct = new decimal?(decimal.Parse(dataReader["FR_deduct"].ToString()));
}
model.FR_remark = dataReader["FR_remark"].ToString();
if (dataReader["FR_flowState"].ToString() != "")
{
model.FR_flowState = new int?(int.Parse(dataReader["FR_flowState"].ToString()));
}
model.FR_user = dataReader["FR_user"].ToString();
if (dataReader["FR_Time"].ToString() != "")
{
model.FR_Time = new DateTime?(DateTime.Parse(dataReader["FR_Time"].ToString()));
}
return(model);
}
