/// <summary> /// 数据转查询实体 /// </summary> public static UserQueryInfo DataToModel(SqlDataReader rdr) { UserQueryInfo query = new UserQueryInfo(); if (!rdr.IsDBNull(0)) query.UserQueryID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) query.UserQueryName = rdr.GetString(1); if (!rdr.IsDBNull(2)) query.UserQueryURL = rdr.GetString(2); if (!rdr.IsDBNull(3)) query.UserQueryValue = rdr.GetString(3); if (!rdr.IsDBNull(4)) query.UserQueryLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) query.UserID = rdr.GetInt32(5); if (!rdr.IsDBNull(6)) query.ModifyDate = rdr.GetDateTime(6); return query; }
/// <summary> /// 根据ID取查询,返回实体 /// </summary> public UserQueryInfo GetUserQueryById(int userId, int queryId) { UserQueryInfo query = new UserQueryInfo(); SqlParameter[] parms = { new SqlParameter(PARM_USER_ID, SqlDbType.Int), new SqlParameter(PARM_QUERY_ID, SqlDbType.Int) }; parms[0].Value = userId; parms[1].Value = queryId; using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, SQL_SELECT_USER_QUERY_BY_ID, parms)) { while (rdr.Read()) { query = DataToModel(rdr); } } return query; }
/// <summary> /// 查询实体转参数 /// </summary> public static SqlParameter[] ModelToParms(UserQueryInfo query) { SqlParameter[] parms = { new SqlParameter("@UserQueryID", SqlDbType.Int), new SqlParameter("@UserQueryName", SqlDbType.NVarChar, 20), new SqlParameter("@UserQueryURL", SqlDbType.NVarChar, 200), new SqlParameter("@UserQueryValue", SqlDbType.NVarChar, 200), new SqlParameter("@UserQueryLive", SqlDbType.TinyInt), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@ModifyDate", SqlDbType.DateTime) }; parms[0].Value = query.UserQueryID; parms[1].Value = query.UserQueryName; parms[2].Value = query.UserQueryURL; parms[3].Value = query.UserQueryValue; parms[4].Value = query.UserQueryLive; parms[5].Value = query.UserID; parms[6].Value = query.ModifyDate; return parms; }
/// <summary> /// 修改专题 /// </summary> public bool UpdateUserQuery(UserQueryInfo query) { return dal.UpdateUserQuery(query); }
/// <summary> /// 插入专题 /// </summary> public bool InsertUserQuery(UserQueryInfo query) { return dal.InsertUserQuery(query); }
/// <summary> /// 修改查询 /// </summary> public bool UpdateUserQuery(UserQueryInfo query) { SqlParameter[] parms = ModelToParms(query); int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.StoredProcedure, SQL_UPDATE_USER_QUERY, parms); return result > 0; }