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