setparameter.cs

一个由VB开发的。NET实体生成器` 提高.net代码质量及开发效率

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

namespace {namespace}.DataAS
{
    /// <summary>
    /// 检索参数
    /// </summary>
    public class SetParameter
    {
        protected string _ColumnName;
        protected object _ColumnValue;
        protected SetDataType _DataType;
        private bool IsNoInit;

        /// <summary>
        /// 构造 一般检索参数
        /// </summary>
        /// <param name="_ColumnName">字段名</param>
        /// <param name="_ColumnValue">字段值</param>
        /// <param name="_Operator">运算操作符</param>
        public SetParameter(string ColumnName, object ColumnValue, SetDataType DataType)
        {
            this._ColumnName = ColumnName;
            this._ColumnValue = ColumnValue;
            this._DataType = DataType;
            IsNoInit = false;
        }

        public SetParameter()
        {
            IsNoInit = true;
        }

        /// <summary>
        /// 获得字符串结果
        /// </summary>
        /// <returns></returns>
        public override string ToString()
        {
            if(IsNoInit == true)
            {
                return "";
            }
            else
            {
                string ValueString = "";
                string vergeSymbol = "";

                if (_DataType == SetDataType.String)
                {
                    vergeSymbol = "'";
                }
                else if (_DataType == SetDataType.Number)
                {
                    vergeSymbol = "";
                }

                ValueString += vergeSymbol + _ColumnValue.ToString() + vergeSymbol;
                return " " + _ColumnName + "=" + ValueString + " ";
            }
        }
    }
}