Common/MySql.cs

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

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

using System;
using System.Collections.Generic;
using System.Reflection;
using System.Text;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Data;
using System.Text.RegularExpressions;

namespace Common
{

    public class MySql
    {
        public static string Table
        { get; set; }
        private static OleDbParameter[] paramete = new OleDbParameter[] { };
        private static SqlParameter[] parametes = new SqlParameter[] { };
        private static string tmpStra = "";
        private static string tmpStrb = "";
        private static int i = 0;
        public static void CreateAdd(string InPut, object value, OleDbType type)
        {
            tmpStra += "[" + InPut + "],";
            tmpStrb += "@" + InPut + ",";
            Array.Resize(ref paramete, paramete.Length + 1);
            paramete[i] = (new OleDbParameter("@" + InPut, type));
            paramete[i].Value = value;
            i = i + 1;

        }
        public static void CreateAdd(string InPut, object value, SqlDbType type)
        {
            tmpStra += "[" + InPut + "],";
            tmpStrb += "@" + InPut + ",";
            Array.Resize(ref parametes, parametes.Length + 1);
            parametes[i] = (new SqlParameter("@" + InPut, type));
            parametes[i].Value = value;
            i = i + 1;

        }
        public static void CreateAdd(string InPut, object value, OleDbType type, int size)
        {
            tmpStra += "[" + InPut + "],";
            tmpStrb += "@" + InPut + ",";
            Array.Resize(ref paramete, paramete.Length + 1);
            paramete[i] = (new OleDbParameter("@" + InPut, type, size));
            paramete[i].Value = value;
            i = i + 1;

        }
        public static void CreateAdd(string InPut, object value, SqlDbType type, int size)
        {
            tmpStra += "[" + InPut + "],";
            tmpStrb += "@" + InPut + ",";
            Array.Resize(ref parametes, parametes.Length + 1);
            parametes[i] = (new SqlParameter("@" + InPut, type, size));
            parametes[i].Value = value;
            i = i + 1;