duiyingbiao.cs

来自「分布式图书管理系统」· CS 代码 · 共 107 行

using System;
using System.Data.SqlClient;
using System.Data;

namespace lib.classes
{
	/// <summary>
	/// duiyingbiao 的摘要说明。
	/// </summary>
	public class duiyingbiao
	{
		public duiyingbiao()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 通过字符串返回sql数据类型，不完整，为本次工程编译
		/// </summary>
		/// <param name="name">字符串</param>
		/// <returns></returns>
		public SqlDbType SqlDbTypeByStr(string name)
		{
			SqlDbType backType;//返回值
			if(name!=null)
			{
				switch(name)
				{
					case ""://为空
						backType=SqlDbType.Variant;
						break;
					case "Char"://char类型
						backType=SqlDbType.Char;
						break;
					case "NVarChar"://NVarChar
						backType=SqlDbType.NVarChar;
						break;
					case "VarChar"://VarChar
						backType=SqlDbType.VarChar;
						break;
					case "Binary"://Binary
						backType=SqlDbType.Binary;
						break;
					case "Int"://Int
						backType=SqlDbType.Int;
						break;
					case "DateTime"://DateTime
						backType=SqlDbType.DateTime;
						break;
					case "Bit"://Bit
						backType=SqlDbType.Bit;
						break;
					case "Image"://Image
						backType=SqlDbType.Image;
						break;
					case "SmallInt"://SmallInt
						backType=SqlDbType.SmallInt;
						break;
					default://之外
						backType=SqlDbType.Variant;
						break;
				}
			}
			else
				backType=SqlDbType.Variant;
			return backType;
		}


		/// <summary>
		/// 通过字符串返回系统数据类型，不完整，为本次工程编译
		/// </summary>
		/// <param name="name">字符串</param>
		/// <returns></returns>
		public DbType DbTypeByStr(string name)
		{
			DbType backType;//返回值
			if(name!=null)
			{
				switch(name)
				{
					case ""://为空时
						backType=DbType.Object;
						break;
					case "String"://String
						backType=DbType.String;
						break;
					default://之外
						backType=DbType.Object;
						break;
				}
			}
			else
				backType=DbType.Object;
			return backType;
		}

		public bool TypeNullTrueorFalse(string boolstr)
		{
			bool back=false;
			if(boolstr=="true")back=true;
			return back;
		}
	}
}