Пример #1
0
 public void CreateParameters(ParamStruct[] param)
 {
     if (param != null)
     {
         int intParamLength = param.Length;
         idbParameters = new IDbDataParameter[intParamLength];
         idbParameters = DBManagerFactory.GetParameters(this.ProviderType, intParamLength);
         for (int i = 0; i <= intParamLength - 1; i++)
         {
             ParamStruct      ps = param[i];
             IDbDataParameter pm = DBManagerFactory.GetParameter(this.ProviderType);
             pm.ParameterName = ps.ParameterName;
             pm.Value         = ps.Value;
             pm.Direction     = ps.Direction;
             pm.DbType        = ps.DbType;
             pm.SourceColumn  = ps.SourceColumn;
             idbParameters[i] = pm;
         }
     }
 }
Пример #2
0
        public ParamStruct SetDBType(ParamStruct pmi, string FieldType)
        {
            switch (FieldType)
            {
            case "bigint":
                pmi.DbType = DbType.UInt64;
                break;

            case "binary":
                pmi.DbType = DbType.Binary;
                break;

            case "char":
                pmi.DbType = DbType.String;
                break;

            case "datetime":
                pmi.DbType = DbType.DateTime;
                break;

            case "decimal":
                pmi.DbType = DbType.Decimal;
                break;

            case "float":
                pmi.DbType = DbType.Double;
                break;

            case "int":
                pmi.DbType = DbType.Int32;
                break;

            case "nchar":
                pmi.DbType = DbType.String;
                break;

            case "ntext":
                pmi.DbType = DbType.String;
                break;

            case "nvarchar":
                pmi.DbType = DbType.String;
                break;

            case "real":
                pmi.DbType = DbType.Double;
                break;

            case "smalldatetime":
                pmi.DbType = DbType.DateTime;
                break;

            case "smallint":
                pmi.DbType = DbType.Int32;
                break;

            case "text":
                pmi.DbType = DbType.String;
                break;

            case "tinyint":
                pmi.DbType = DbType.Int16;
                break;

            case "System.varchar":
                pmi.DbType = DbType.String;
                break;

            default:
                pmi.DbType = DbType.String;
                break;
            }

            return(pmi);
        }