Exemplo n.º 1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public LinkModel GetModel(int LinkId)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@LinkId", SqlDbType.BigInt)
            };
            parameters[0].Value = LinkId;

            LinkModel model = new LinkModel();
            DataSet   ds    = adoHelper.ExecuteSPDataset("sp_Link_GetModel", parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["LinkId"].ToString() != "")
                {
                    model.LinkId = long.Parse(ds.Tables[0].Rows[0]["LinkId"].ToString());
                }
                model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
                model.Link  = ds.Tables[0].Rows[0]["Link"].ToString();
                model.Image = ds.Tables[0].Rows[0]["Image"].ToString();
                if (ds.Tables[0].Rows[0]["DisplayMode"].ToString() != "")
                {
                    model.DisplayMode = int.Parse(ds.Tables[0].Rows[0]["DisplayMode"].ToString());
                }
                if (ds.Tables[0].Rows[0]["Sort"].ToString() != "")
                {
                    model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
                }
                if (ds.Tables[0].Rows[0]["CategoryId"].ToString() != "")
                {
                    model.CategoryId = int.Parse(ds.Tables[0].Rows[0]["CategoryId"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public int Update(LinkModel model)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@LinkId",      SqlDbType.BigInt,    8),
                new SqlParameter("@Title",       SqlDbType.VarChar,  50),
                new SqlParameter("@Link",        SqlDbType.VarChar, 100),
                new SqlParameter("@Image",       SqlDbType.VarChar, 100),
                new SqlParameter("@DisplayMode", SqlDbType.Int,       4),
                new SqlParameter("@Sort",        SqlDbType.Int,       4),
                new SqlParameter("@CategoryId",  SqlDbType.Int, 4)
            };
            parameters[0].Value = model.LinkId;
            parameters[1].Value = model.Title;
            parameters[2].Value = model.Link;
            parameters[3].Value = model.Image;
            parameters[4].Value = model.DisplayMode;
            parameters[5].Value = model.Sort;
            parameters[6].Value = model.CategoryId;

            return(adoHelper.ExecuteSPNonQuery("sp_Link_Update", parameters));
        }
Exemplo n.º 3
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public int Update(LinkModel model)
 {
     return(dal.Update(model));
 }
Exemplo n.º 4
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(LinkModel model)
 {
     return(dal.Add(model));
 }