反射特性.docVIP

反射特性 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Reflection; using Hotel.Modal.Attributes; using Hotel.DAL; using System.Data; namespace Hotel.BLL { public enum SQLHeadMod { /// summary /// 添加 /// /summary Insert, /// summary /// 删除 /// /summary Delete, /// summary /// 修改 /// /summary Update } public class ORMHepler { /// summary /// 增。删。改的方法 /// /summary /// typeparam name=T对象/typeparam /// param name=Entity对象信息/param /// param name=ps查询条件/param /// returns/returns public static int SearchInfo(Object Entity,SQLHeadMod sqltype,string IsIndentityId) { int count =0; string idcount =null; string Identity = null ; Type type = Entity.GetType();//获取类的原型信息 //1.获取表名 string TableName = GetTableName(type); //获得Sql语句的成分 “select s.*,g.* from Subject as s inner join Grade as g where .......” StringBuilder lieming = new StringBuilder();//列明 StringBuilder canshu = new StringBuilder(); //参数 ListSqlParameter canshuzhi = new ListSqlParameter();//参数值 foreach(PropertyInfo proitem in type.GetProperties()) { if (Identity == null) { idcount = Id(proitem); Identity = idcount; } //判断该字段是否是自动编号且该字段存在于表 if(!IsIndentityNo(proitem) IsColum(proitem) ) { string name = GetColumName(proitem); lieming.Append(name + = + @ + name + ,); canshu.Append(@ + name + ,); canshuzhi.Add(new SqlParameter(@+ name, proitem.GetValue(Entity, null))); } }