public override IModel CreateModel(SqlDataReader dr) { FinBusInvAllotDetail finbusinvallotdetail = new FinBusInvAllotDetail(); int indexDetailId = dr.GetOrdinal("DetailId"); finbusinvallotdetail.DetailId = Convert.ToInt32(dr[indexDetailId]); int indexAllotId = dr.GetOrdinal("AllotId"); if (dr["AllotId"] != DBNull.Value) { finbusinvallotdetail.AllotId = Convert.ToInt32(dr[indexAllotId]); } int indexBusinessInvoiceId = dr.GetOrdinal("BusinessInvoiceId"); if (dr["BusinessInvoiceId"] != DBNull.Value) { finbusinvallotdetail.BusinessInvoiceId = Convert.ToInt32(dr[indexBusinessInvoiceId]); } int indexFinanceInvoiceId = dr.GetOrdinal("FinanceInvoiceId"); if (dr["FinanceInvoiceId"] != DBNull.Value) { finbusinvallotdetail.FinanceInvoiceId = Convert.ToInt32(dr[indexFinanceInvoiceId]); } int indexAllotBala = dr.GetOrdinal("AllotBala"); if (dr["AllotBala"] != DBNull.Value) { finbusinvallotdetail.AllotBala = Convert.ToDecimal(dr[indexAllotBala]); } int indexDetailStatus = dr.GetOrdinal("DetailStatus"); if (dr["DetailStatus"] != DBNull.Value) { finbusinvallotdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]); } return finbusinvallotdetail; }
public ResultModel Load(UserModel user, int allotId, Common.StatusEnum status) { ResultModel result = new ResultModel(); try { string sql = string.Format("select * from dbo.Inv_FinBusInvAllotDetail where AllotId = {0} and DetailStatus = {1}", allotId, (int)status); DataTable dt = SqlHelper.ExecuteDataTable(ConnectString, sql, null, CommandType.Text); List<FinBusInvAllotDetail> finBusInvAllotDetails = new List<FinBusInvAllotDetail>(); foreach (DataRow dr in dt.Rows) { FinBusInvAllotDetail finbusinvallotdetail = new FinBusInvAllotDetail(); finbusinvallotdetail.DetailId = Convert.ToInt32(dr["DetailId"]); if (dr["AllotId"] != DBNull.Value) { finbusinvallotdetail.AllotId = Convert.ToInt32(dr["AllotId"]); } if (dr["BusinessInvoiceId"] != DBNull.Value) { finbusinvallotdetail.BusinessInvoiceId = Convert.ToInt32(dr["BusinessInvoiceId"]); } if (dr["FinanceInvoiceId"] != DBNull.Value) { finbusinvallotdetail.FinanceInvoiceId = Convert.ToInt32(dr["FinanceInvoiceId"]); } if (dr["AllotBala"] != DBNull.Value) { finbusinvallotdetail.AllotBala = Convert.ToDecimal(dr["AllotBala"]); } if (dr["DetailStatus"] != DBNull.Value) { finbusinvallotdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]); } finBusInvAllotDetails.Add(finbusinvallotdetail); } result.AffectCount = dt.Rows.Count; result.Message = "获取列表成功"; result.ResultStatus = 0; result.ReturnValue = finBusInvAllotDetails; } catch (Exception e) { result.ResultStatus = -1; result.Message = e.Message; } return result; }