Exemplo n.º 1
0
        /// <summary>
        /// 友情链接的添加
        /// </summary>
        /// <param name="links">tbLinks对象</param>
        /// <returns>int </returns>
        public int Links_Add(tbLinks links)
        {
            SqlParameter[] pars = new SqlParameter[]{
            new SqlParameter("@SiteName",links.SiteName),
            new SqlParameter("@SiteUrl",links.SiteUrl),
            new SqlParameter("@SiteImg",links.SiteImg),
            new SqlParameter("@isshowimg",links.isshowimg),
            new SqlParameter("@isDel",links.isDel)

              };
             return  dbhelper.ExcuteCommandReturnInt("Links_Add", CommandType.StoredProcedure, pars);
        }
Exemplo n.º 2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            tbLinks links = new tbLinks()
            {
                SiteName = txtSiteName.Text.Trim(),
                SiteImg = filename,
                SiteUrl = txtURL.Text.Trim(),
                isshowimg = bool.Parse(ddlShowimg.SelectedValue.ToString()),
                isDel = bool.Parse(ddlShow.SelectedValue.ToString())

            };

               int count= linksbll.Links_Add(links);
               if (count != 0)
               {
               Response.Redirect("List.aspx");
               }
        }
Exemplo n.º 3
0
        /// <summary>
        /// 根据编号获取友情链接对象的详细属性
        /// </summary>
        /// <param name="id">编号</param>
        /// <returns>tbLinks对象</returns>
        public tbLinks Links_getModel(string id)
        {
            SqlParameter[] pars = new SqlParameter[]{
            new SqlParameter("@SiteId",int.Parse(id))
            };

               SqlDataReader reader=dbhelper.SelectSqlReturnDataReader("Links_getModel", CommandType.StoredProcedure, pars);
               tbLinks links = new tbLinks();
               if (reader != null &&reader.Read()==true)
               {
               links.SiteId = int.Parse(reader["SiteId"].ToString());
               links.SiteName = reader["SiteName"].ToString();
               links.SiteImg = reader["SiteImg"].ToString();
               links.SiteUrl = reader["SiteUrl"].ToString();
               links.isshowimg =bool.Parse(reader["isshowimg"].ToString());
               links.isDel = bool.Parse(reader["isDel"].ToString());
               }
               return links;
        }