DB.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web.UI.WebControls;
namespace khglcrm
{
    public class DB
    {
        public OleDbConnection con;
        public OleDbCommand cmd;

        public DB()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
            con = new OleDbConnection(ConfigurationManager.ConnectionStrings["Conkhglcrm"].ConnectionString);
            con.Open();
        }
        public void close()
        {
            con.Close();
        }

        public OleDbDataReader GetdataReader(string str)
        {
            cmd = new OleDbCommand(str, con);
            OleDbDataReader dr = cmd.ExecuteReader();
            return dr;

        }
        public OleDbDataReader dl(string str, string tt, string dd)
        {
            cmd = new OleDbCommand(str, con);
            cmd.Parameters.Add("@aname", OleDbType.VarChar, 50).Value = tt.ToString().Trim();
            cmd.Parameters.Add("@apwd", OleDbType.VarChar, 50).Value = dd.ToString().Trim();
            OleDbDataReader dr = cmd.ExecuteReader();
            return dr;

        }

        public int Gettj(string str)
        {
            cmd = new OleDbCommand(str, con);
            return cmd.ExecuteNonQuery();
        }

        public DataSet getdateset(string str)
        {
            OleDbDataAdapter sda = new OleDbDataAdapter(str, con);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            return ds;
        }
        public int zongji(string str)
        {
            cmd = new OleDbCommand(str, con);