App_Code/Class_Function_Data.cs

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

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

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Class_Function_Data
/// 数据访问类
/// </summary>
public class Class_Function_Data
{
    //*************数据库处理*************
    public DataTable DBP(int DBTypeID, int ProccessTypeID, String ConnectionString, String DBSrc, String DBName, String UserName, String PWD, String SQLString)
    {
        DataTable Result = new DataTable();
        DataSet DataSet_Temp = new DataSet();
        string strDBCon = null;
        //判断DBTypeID数据类型
        if (DBTypeID == 1)//OleDB数据库
        {
            //判断ProccessTypeID数据处理类型
            if (ProccessTypeID == 1)//执行SQL语句
            {
                AccessDataSource ADS = new AccessDataSource();
                DataTable DT = new DataTable();
                DT.Columns.Add("Result", typeof(string));
                
                DataRow DR = DT.NewRow();
                ADS.DataFile = DBSrc;
                try
                {
                    if (SQLString.ToLower().Substring(0, 6) == "insert")
                    {
                        ADS.InsertCommand = SQLString;
                        ADS.Insert();
                        DR["Result"] ="0";
                    }
                    else if (SQLString.ToLower().Substring(0, 6) == "update")
                    {
                        ADS.UpdateCommand  = SQLString;
                        ADS.Update();
                        DR["Result"] = "0";
                    }
                    else if (SQLString.ToLower().Substring(0, 6) == "delete")
                    {
                        ADS.DeleteCommand = SQLString;
                        ADS.Delete();
                        DR["Result"] = "0";
                    }
                }
                catch(Exception ex)
                {
                    DR["Result"] = ex.Message.ToString();