SenBiTeSolution.DAL/tbl_Configs.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using SenBiTeSolution.DBUtility;
using System.Data.OleDb;

namespace SenBiTeSolution.DAL
{
   public class tbl_Configs
    {
        //增加一条新闻
        public int AddConfigs(Model.tbl_Configs config)
        {
            string sqlString = "insert into T_Configs(con_name,con_value) values(@con_name,@con_value)";

            OleDbParameter[] parameters = new OleDbParameter[2];

            parameters[0] = new OleDbParameter("@con_name", OleDbType.VarChar, 50);
            parameters[0].Value = config.con_name;

            parameters[1] = new OleDbParameter("@con_value", OleDbType.VarChar, 3000);
            parameters[1].Value = config.con_value;

           

            return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);

        }

        //删除一条新闻
        public int DelConfigs(Model.tbl_Configs config)
        {
            string sqlString = "delete from T_Configs where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[1];

            parameters[0] = new OleDbParameter("@ID", OleDbType.Integer, 4);
            parameters[0].Value = config.ID;

            return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);
        }

        //根据新闻ID修改新闻
        public int UpdateConfigs(Model.tbl_Configs config)
        {
            string sqlString = "update T_Configs set con_name=@con_name,con_value=@con_value where ID=@ID";

            OleDbParameter[] parameters = new OleDbParameter[3];

            parameters[0] = new OleDbParameter("@con_name", OleDbType.VarChar, 50);
            parameters[0].Value = config.con_name;

            parameters[1] = new OleDbParameter("@con_value", OleDbType.VarChar, 3000);
            parameters[1].Value = config.con_value;


            parameters[2] = new OleDbParameter("@ID", OleDbType.Integer, 4);
            parameters[2].Value = config.ID;