Backup/AccessDal/LinksInfoOpe.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Model;

namespace AccessDal
{
    /// <summary>
    /// 链接数据库操作类
    /// </summary>
    public class LinksInfoOpe
    {
        /// <summary>
        /// 添加链接
        /// </summary>
        /// <returns></returns>
        public static int AddLinksInfo(int cid, string lname, string limgurl, string lurl, string addtime)
        {
            OleDbParameter[] p = 
            {
                new OleDbParameter("@cid",cid),
                new OleDbParameter("@lname",lname),
                new OleDbParameter("@limgurl",limgurl),
                new OleDbParameter("@lurl",lurl),
                new OleDbParameter("@addtime",addtime)
            };
            string sql = "insert into LinksInfo (CID,LName,LimgUrl,LUrl,AddTime) values(@cid,@lname,@limgurl,@lurl,@addtime)";
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text,sql,p);
        }

        /// <summary>
        /// 删除链接
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int DeleteLinksInfo(int id)
        {
            string sql = "delete from LinksInfo where ID="+id;
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text,sql);
        }
        /// <summary>
        /// 修改链接
        /// </summary>
        /// <returns></returns>
        public static int UpdateLinksInfo(int cid, string lname, string limgurl, string lurl, string addtime, int id)
        {
            OleDbParameter[] p = 
            {
                new OleDbParameter("@cid",cid),
                new OleDbParameter("@lname",lname),
                new OleDbParameter("@limgurl",limgurl),
                new OleDbParameter("@lurl",lurl),
                new OleDbParameter("@addtime",addtime),
                new OleDbParameter("@id",id)
            };
            string sql = "update LinksInfo set CID=@cid,LName=@lname,LimgUrl=@limgurl,LUrl=@lurl,AddTime=@addtime where ID=@id";
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text,sql,p);
        }