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