/// <summary> /// 获取clausecontract_ref集合 /// </summary> /// <param name="user">当前操作用户</param> /// <returns></returns> public override ResultModel Load(UserModel user) { ResultModel result = new ResultModel(); try { DataTable dt = SqlHelper.ExecuteDataTable(SqlHelper.ConnectionStringNFMT, "ClauseContract_RefLoad", null, CommandType.StoredProcedure); List<ClauseContractRef> clauseContractRefs = new List<ClauseContractRef>(); foreach (DataRow dr in dt.Rows) { ClauseContractRef clauseContractRef = new ClauseContractRef(); clauseContractRef.RefId = Convert.ToInt32(dr["RefId"]); if (dr["MasterId"] != DBNull.Value) { clauseContractRef.MasterId = Convert.ToInt32(dr["MasterId"]); } if (dr["ClauseId"] != DBNull.Value) { clauseContractRef.ClauseId = Convert.ToInt32(dr["ClauseId"]); } if (dr["Sort"] != DBNull.Value) { clauseContractRef.Sort = Convert.ToInt32(dr["Sort"]); } if (dr["IsChose"] != DBNull.Value) { clauseContractRef.IsChose = Convert.ToBoolean(dr["IsChose"]); } if (dr["CreatorId"] != DBNull.Value) { clauseContractRef.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["CreateTime"] != DBNull.Value) { clauseContractRef.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyId"] != DBNull.Value) { clauseContractRef.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["LastModifyTime"] != DBNull.Value) { clauseContractRef.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } clauseContractRefs.Add(clauseContractRef); } result.AffectCount = dt.Rows.Count; result.Message = "获取列表成功"; result.ResultStatus = 0; result.ReturnValue = clauseContractRefs; } catch (Exception ex) { result.Message = ex.Message; } return result; }
/// <summary> /// 获取指定refId的clausecontract_ref对象 /// </summary> /// <param name="user">当前操作用户</param> /// <param name="refId">主键值</param> /// <returns></returns> public override ResultModel Get(UserModel user, int refId) { ResultModel result = new ResultModel(); if (refId < 1) { result.Message = "序号不能小于1"; return result; } List<SqlParameter> paras = new List<SqlParameter>(); SqlParameter para = new SqlParameter("@RefId", SqlDbType.Int, 4); para.Value = refId; paras.Add(para); SqlDataReader dr = null; try { dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringNFMT, CommandType.StoredProcedure, "ClauseContract_RefGet", paras.ToArray()); ClauseContractRef clauseContractRef = new ClauseContractRef(); if (dr.Read()) { int indexRefId = dr.GetOrdinal("RefId"); clauseContractRef.RefId = Convert.ToInt32(dr[indexRefId]); int indexMasterId = dr.GetOrdinal("MasterId"); if (dr["MasterId"] != DBNull.Value) { clauseContractRef.MasterId = Convert.ToInt32(dr[indexMasterId]); } int indexClauseId = dr.GetOrdinal("ClauseId"); if (dr["ClauseId"] != DBNull.Value) { clauseContractRef.ClauseId = Convert.ToInt32(dr[indexClauseId]); } int indexSort = dr.GetOrdinal("Sort"); if (dr["Sort"] != DBNull.Value) { clauseContractRef.Sort = Convert.ToInt32(dr[indexSort]); } int indexIsChose = dr.GetOrdinal("IsChose"); if (dr["IsChose"] != DBNull.Value) { clauseContractRef.IsChose = Convert.ToBoolean(dr[indexIsChose]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { clauseContractRef.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { clauseContractRef.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { clauseContractRef.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { clauseContractRef.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } result.AffectCount = 1; result.Message = "读取成功"; result.ResultStatus = 0; result.ReturnValue = clauseContractRef; } else { result.Message = "读取失败或无数据"; result.AffectCount = 0; } } catch (Exception ex) { result.Message = ex.Message; } finally { if (dr != null) dr.Dispose(); } return result; }