public int CompareTo(object obj) { UserFavoriteLinkInfo b = obj as UserFavoriteLinkInfo; if (this.SysNo > b.SysNo) { return(1); } else { return(-1); } }
public int Insert(UserFavoriteLinkInfo oParam) { string sql = @"INSERT INTO Sys_User_FavoriteLink ( UserSysNo, LinkName, LinkAhref, CreateTime ) VALUES ( @UserSysNo, @LinkName, @LinkAhref, @CreateTime );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4); SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int,4); SqlParameter paramLinkName = new SqlParameter("@LinkName", SqlDbType.NVarChar,100); SqlParameter paramLinkAhref = new SqlParameter("@LinkAhref", SqlDbType.NVarChar,500); SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime); paramSysNo.Direction = ParameterDirection.Output; if ( oParam.UserSysNo != AppConst.IntNull) paramUserSysNo.Value = oParam.UserSysNo; else paramUserSysNo.Value = System.DBNull.Value; if ( oParam.LinkName != AppConst.StringNull) paramLinkName.Value = oParam.LinkName; else paramLinkName.Value = System.DBNull.Value; if ( oParam.LinkAhref != AppConst.StringNull) paramLinkAhref.Value = oParam.LinkAhref; else paramLinkAhref.Value = System.DBNull.Value; if ( oParam.CreateTime != AppConst.DateTimeNull) paramCreateTime.Value = oParam.CreateTime; else paramCreateTime.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramUserSysNo); cmd.Parameters.Add(paramLinkName); cmd.Parameters.Add(paramLinkAhref); cmd.Parameters.Add(paramCreateTime); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public SortedList GetFavoriteLinkList(int userSysNo) { string sql = "select top 10 * from Sys_User_FavoriteLink where userSysNo = " + userSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( !Util.HasMoreRow(ds)) return null; SortedList sl = new SortedList(10); foreach(DataRow dr in ds.Tables[0].Rows) { UserFavoriteLinkInfo oItem = new UserFavoriteLinkInfo(); map(oItem, dr); sl.Add(oItem,null); } return sl; }
private void map(UserFavoriteLinkInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.UserSysNo = Util.TrimIntNull(tempdr["UserSysNo"]); oParam.LinkName = Util.TrimNull(tempdr["LinkName"]); oParam.LinkAhref = Util.TrimNull(tempdr["LinkAhref"]); oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]); }
public int InsertUserFavoriteLink(UserFavoriteLinkInfo oParam) { return new UserFavoriteLinkDac().Insert(oParam); }