public ResultModel GetDetailByContractId(UserModel user, int contractId) { ResultModel result = new ResultModel(); if (contractId < 1) { result.Message = "合约序号不能小于1"; return result; } List<SqlParameter> paras = new List<SqlParameter>(); SqlParameter para = new SqlParameter("@contractId", SqlDbType.Int, 4); para.Value = contractId; paras.Add(para); SqlDataReader dr = null; try { string cmdText = string.Format("select * from dbo.Con_ContractDetail where ContractId ={0}", contractId); dr = SqlHelper.ExecuteReader(this.ConnectString, CommandType.Text, cmdText, paras.ToArray()); ContractDetail contractdetail = new ContractDetail(); if (dr.Read()) { int indexContractDetailId = dr.GetOrdinal("ContractDetailId"); contractdetail.ContractDetailId = Convert.ToInt32(dr[indexContractDetailId]); int indexContractId = dr.GetOrdinal("ContractId"); if (dr["ContractId"] != DBNull.Value) { contractdetail.ContractId = Convert.ToInt32(dr[indexContractId]); } int indexDiscountBase = dr.GetOrdinal("DiscountBase"); if (dr["DiscountBase"] != DBNull.Value) { contractdetail.DiscountBase = Convert.ToInt32(dr[indexDiscountBase]); } int indexDiscountType = dr.GetOrdinal("DiscountType"); if (dr["DiscountType"] != DBNull.Value) { contractdetail.DiscountType = Convert.ToInt32(dr[indexDiscountType]); } int indexDiscountRate = dr.GetOrdinal("DiscountRate"); if (dr["DiscountRate"] != DBNull.Value) { contractdetail.DiscountRate = Convert.ToDecimal(dr[indexDiscountRate]); } int indexDelayType = dr.GetOrdinal("DelayType"); if (dr["DelayType"] != DBNull.Value) { contractdetail.DelayType = Convert.ToInt32(dr[indexDelayType]); } int indexDelayRate = dr.GetOrdinal("DelayRate"); if (dr["DelayRate"] != DBNull.Value) { contractdetail.DelayRate = Convert.ToDecimal(dr[indexDelayRate]); } int indexMoreOrLess = dr.GetOrdinal("MoreOrLess"); if (dr["MoreOrLess"] != DBNull.Value) { contractdetail.MoreOrLess = Convert.ToDecimal(dr[indexMoreOrLess]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { contractdetail.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { contractdetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { contractdetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { contractdetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } result.AffectCount = 1; result.Message = "读取成功"; result.ResultStatus = 0; result.ReturnValue = contractdetail; } else { result.Message = "读取失败或无数据"; result.AffectCount = 0; } } catch (Exception ex) { result.Message = ex.Message; } finally { if (dr != null) dr.Dispose(); } return result; }
public override IModel CreateModel(SqlDataReader dr) { ContractDetail contractdetail = new ContractDetail(); int indexContractDetailId = dr.GetOrdinal("ContractDetailId"); contractdetail.ContractDetailId = Convert.ToInt32(dr[indexContractDetailId]); int indexContractId = dr.GetOrdinal("ContractId"); if (dr["ContractId"] != DBNull.Value) { contractdetail.ContractId = Convert.ToInt32(dr[indexContractId]); } int indexDiscountBase = dr.GetOrdinal("DiscountBase"); if (dr["DiscountBase"] != DBNull.Value) { contractdetail.DiscountBase = Convert.ToInt32(dr[indexDiscountBase]); } int indexDiscountType = dr.GetOrdinal("DiscountType"); if (dr["DiscountType"] != DBNull.Value) { contractdetail.DiscountType = Convert.ToInt32(dr[indexDiscountType]); } int indexDiscountRate = dr.GetOrdinal("DiscountRate"); if (dr["DiscountRate"] != DBNull.Value) { contractdetail.DiscountRate = Convert.ToDecimal(dr[indexDiscountRate]); } int indexDelayType = dr.GetOrdinal("DelayType"); if (dr["DelayType"] != DBNull.Value) { contractdetail.DelayType = Convert.ToInt32(dr[indexDelayType]); } int indexDelayRate = dr.GetOrdinal("DelayRate"); if (dr["DelayRate"] != DBNull.Value) { contractdetail.DelayRate = Convert.ToDecimal(dr[indexDelayRate]); } int indexMoreOrLess = dr.GetOrdinal("MoreOrLess"); if (dr["MoreOrLess"] != DBNull.Value) { contractdetail.MoreOrLess = Convert.ToDecimal(dr[indexMoreOrLess]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { contractdetail.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { contractdetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { contractdetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { contractdetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return contractdetail; }