insertstatement.cs

.net的数据持久层

using System;
using System.Text;

namespace Platform.Data {

	public class InsertStatement : StatementBase {

		public InsertStatement() :base() {
		}

		public InsertStatement(object obj) : base(obj) {
		}

		public InsertStatement(object obj,string _TName) : base(obj,_TName) 
		{
		}

		private string _InsertString;
		public string InsertString {
			get { return _InsertString; }
			set { this._InsertString = value;  }
		}
		public override void BuildSqlClause() {
			this.FieldString = this.BuildFieldString();
			this.InsertString = this.BuildInsertString();
			this.SqlClause = String.Format("INSERT INTO {0} ({1}) VALUES( {2} )",
				this.TableName, this.FieldString, this.InsertString);
		}

		private string BuildInsertString(){
			StringBuilder sb = new StringBuilder();
			foreach( FieldProp fp in this.Fields ){
				if( sb.Length > 0 ){
					sb.Append( ",");
				}
				sb.Append( String.Format( "{0}{1}", DataHelper.DataDriver.ParameterPrix, fp.FieldName ) );
				this.Parameters.Add( this.MakeDataParameter( fp ) );
			}
			return sb.ToString();
		}

		public override void FillDataParameter(object obj) {
			foreach(FieldProp fp in this.Fields){
				DataParameter dp = this.Parameters[ fp.FieldName ];
				if( fp.Size != 0 ){
					dp.Size = fp.Size;
				}
				dp.Value = fp.GetValue( obj );
			}
		}

		public override StatementBase Create() {
			return new InsertStatement();
		}
	}
}