Example #1
0
        public int CompareTo(object obj)
        {
            UserFavoriteLinkInfo b = obj as UserFavoriteLinkInfo;

            if (this.SysNo > b.SysNo)
            {
                return(1);
            }
            else
            {
                return(-1);
            }
        }
Example #2
0
        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);
        }
Example #3
0
        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;
        }
Example #4
0
 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"]);
 }
Example #5
0
 public int InsertUserFavoriteLink(UserFavoriteLinkInfo oParam)
 {
     return new UserFavoriteLinkDac().Insert(oParam);
 }