Exemplo n.º 1
0
    private void CreateLogTable(AppSql.SQL SqlClient, string TableName, DataColumn[] DataColumns)
    {
        string vStrSQL = "" + "CREATE TABLE IF NOT EXISTS [" + TableName + "]" + " ([UID] CHAR(36) PRIMARY KEY ASC NOT NULL," + " [Time] DATETIME NOT NULL," + " [Category] VARCHAR(20)," + " [Class] VARCHAR(50)," + " [Function] VARCHAR(50)," + " [Description] VARCHAR(4000)," + " [Sent] INTEGER";

        foreach (DataColumn vStaticColumn in DataColumns)
        {
            vStrSQL += ", [" + vStaticColumn.ColumnName + "] ";
            switch (vStaticColumn.DataType.Name.ToUpper())
            {
            case "STRING":
                vStrSQL += "VARCHAR(" + vStaticColumn.MaxLength.ToString() + ")";
                break;

            case "BYTE":
            case "INTEGER":
            case "INT16":
            case "INT32":
            case "INT64":
                vStrSQL += "INTEGER";
                break;

            case "DATE":
            case "DATETIME":
                vStrSQL += "DATETIME";
                break;

            case "SINGLE,DOUBLE,DECIMAL":
                vStrSQL += "DECIMAL(18,2)";
                break;

            default:
                vStrSQL += "VARCHAR(4000)";
                break;
            }
        }
        vStrSQL += ");";
        _Sql.Exec(vStrSQL);
    }
Exemplo n.º 2
0
    private System.Collections.Generic.List <System.Data.Common.DbParameter> GetInsertParameters(AppSql.SQL SqlClient, DataColumn[] DataColumns)
    {
        List <DbParameter> vParList = new List <DbParameter>();

        vParList.Add(SqlClient.NewParameter("UID", DbType.String));
        vParList.Add(SqlClient.NewParameter("Time", DbType.DateTime));
        vParList.Add(SqlClient.NewParameter("Category", DbType.String));
        vParList.Add(SqlClient.NewParameter("Class", DbType.String));
        vParList.Add(SqlClient.NewParameter("Function", DbType.String));
        vParList.Add(SqlClient.NewParameter("Description", DbType.String));
        vParList.Add(SqlClient.NewParameter("Sent", DbType.Int32));

        if (DataColumns != null)
        {
            foreach (DataColumn vStaticColumn in DataColumns)
            {
                switch (vStaticColumn.DataType.Name.ToUpper())
                {
                case "STRING":
                    vParList.Add(SqlClient.NewParameter(vStaticColumn.ColumnName, DbType.String));
                    break;

                case "BYTE":
                case "INTEGER":
                case "INT16":
                case "INT32":
                case "INT64":
                    vParList.Add(SqlClient.NewParameter(vStaticColumn.ColumnName, DbType.Int64));
                    break;

                case "DATE":
                case "DATETIME":
                    vParList.Add(SqlClient.NewParameter(vStaticColumn.ColumnName, DbType.DateTime));
                    break;

                case "SINGLE,DOUBLE,DECIMAL":
                    vParList.Add(SqlClient.NewParameter(vStaticColumn.ColumnName, DbType.Decimal));
                    break;

                default:
                    vParList.Add(SqlClient.NewParameter(vStaticColumn.ColumnName, DbType.String));
                    break;
                }
            }
        }
        return(vParList);
    }