using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Data;
|
using System.Configuration;
|
using System.Data.Common;
|
|
|
namespace HH.WMS.DAL
|
{
|
public class ComDbType
|
{
|
/// <summary>
|
/// CHAR 字符类型
|
/// </summary>
|
public static DbType CHAR
|
{
|
get
|
{
|
return GetDataType("CHAR");
|
}
|
}
|
|
|
/// <summary>
|
/// FLOAT
|
/// </summary>
|
public static DbType FLOAT
|
{
|
get
|
{
|
return GetDataType("FLOAT");
|
}
|
}
|
|
/// <summary>
|
/// 字符类型
|
/// </summary>
|
public static DbType DOUBLE
|
{
|
get
|
{
|
return GetDataType("DOUBLE");
|
}
|
}
|
|
/// <summary>
|
/// DECIMAL
|
/// </summary>
|
public static DbType DECIMAL
|
{
|
get
|
{
|
return GetDataType("DECIMAL");
|
}
|
}
|
|
|
/// <summary>
|
/// INT
|
/// </summary>
|
public static DbType INT
|
{
|
get
|
{
|
return GetDataType("INT");
|
}
|
}
|
|
/// <summary>
|
/// INT32
|
/// </summary>
|
public static DbType INT32
|
{
|
get
|
{
|
return GetDataType("INT32");
|
}
|
}
|
|
/// <summary>
|
/// VARCHAR
|
/// </summary>
|
public static DbType STRING
|
{
|
get
|
{
|
return GetDataType("VARCHAR");
|
}
|
}
|
|
/// <summary>
|
/// DATE
|
/// </summary>
|
public static DbType DATE
|
{
|
get
|
{
|
return GetDataType("DATE");
|
}
|
}
|
|
|
/// <summary>
|
/// CURSOR 仅oracle使用
|
/// </summary>
|
public static DbType CURSOR
|
{
|
get
|
{
|
return GetDataType("CURSOR");
|
}
|
}
|
|
|
/// <summary>
|
/// 得到数据类型
|
/// </summary>
|
/// <param name="Type">字段类型</param>
|
private static DbType GetDataType(string Type)
|
{
|
switch (Type.ToLower())
|
{
|
case "char":
|
return DbType.String;
|
case "nchar":
|
return DbType.String;
|
case "float":
|
return DbType.Single;
|
case "double":
|
return DbType.Double;
|
case "decimal":
|
return DbType.Decimal;
|
case "int":
|
return DbType.Int32;
|
case "int16":
|
return DbType.Int16;
|
case "int32":
|
return DbType.Int32;
|
case "int64":
|
return DbType.Int64;
|
case "varchar":
|
return DbType.String;
|
case "nvarchar":
|
return DbType.String;
|
case "date":
|
return DbType.DateTime;
|
case "number":
|
return DbType.Decimal;
|
default:
|
return DbType.String;
|
|
}
|
|
}
|
}
|
}
|
