反射实体类拼接SQL语句

实体类基类：

 using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Reflection;
 using System.Text;
 using System.Threading.Tasks; namespace Common
 {
     /// <summary>
     /// 实体类基类
     /// </summary>
     [Serializable]
     public abstract class EntityBase
     {
         /// <summary>
         /// 获取主键
         /// </summary>
         /// <returns></returns>
         public abstract string GetPrimaryKey();
         /// <summary>
         /// 获取INSERT语句
         /// </summary>
         /// <returns></returns>
         public string GetInsertSql()
         {
             try
             {
                 Type t = this.GetType();
                 string tableName = t.Name,pKey=this.GetPrimaryKey(),fields=string.Empty,values=string.Empty,temp=null;
                 foreach (PropertyInfo pi in t.GetProperties())
                 {
                     if (!pi.CanWrite) continue;
                     if (pi.Name.Equals(pKey))
                     {
                         continue;
                     }
                     temp = GetByTypeStr(pi);
                     fields += pi.Name + ",";
                     values += temp + ",";
                 }
                 return string.Format("Insert into {0}({1}) Values({2})", tableName, fields.TrimEnd(','), values.TrimEnd(','));
             }
             catch
             {
                 throw;
             }
         }
         /// <summary>
         /// 获取UPDATE语句
         /// </summary>
         /// <returns></returns>
         public string GetUpdateSql()
         {
             try
             {
                 Type t = this.GetType();
                 PropertyInfo[] pInfos = t.GetProperties();
                 string tableName = t.Name, pKey = this.GetPrimaryKey(), str_fields=string.Empty;
                 int keyIndex = -;
                 for (int i = ; i < pInfos.Length; i++)
                 {
                     if (pInfos[i].Name.Equals(this.GetPrimaryKey()))
                     {
                         keyIndex = i;
                         continue;
                     }
                     str_fields += pInfos[i].Name + " = " + GetByTypeStr(pInfos[i]) + ",";
                 }
                 return string.Format("Update {0} Set {1} Where {2} = {3}", tableName, str_fields.TrimEnd(','),this.GetPrimaryKey(), GetByTypeStr(pInfos[keyIndex]));
             }
             catch
             {
                 throw;
             }
         }
         /// <summary>
         /// 根据数据类型反射字段值
         /// </summary>
         /// <param name="pInfo">公共属性</param>
         /// <returns></returns>
         private string GetByTypeStr(PropertyInfo pInfo)
         {
             try
             {
                 string result_str = string.Empty;
                 Type t = pInfo.PropertyType;
                 object obj = pInfo.GetValue(this, null);
                 bool valueNull = StringUtil.isNullOrBlank(obj);
                 if (t == typeof(string))
                 {
                     result_str = valueNull ? "null" : "'" + obj.ToString().Replace("--","") + "'";
                 }
                 else if (t == typeof(System.Decimal) || t == typeof(System.Int16) || t == typeof(System.Int32) || t == typeof(System.Int64))
                 {
                     result_str = t.Name == "Nullable`1"&& valueNull ? "null" : obj.ToString();
                     //if ()
                     //{                     //}
                     //else
                     //{
                     //    result_str = valueNull ? "0" : obj.ToString();
                     //}
                 }
                 else if(t==typeof(DateTime)||t.Name== "Nullable`1")
                 {
                     if (valueNull||DateTime.MinValue.Equals(obj)|| t.Name == "Nullable`1")
                     {
                         result_str = "null";
                     }
                     else
                     {
                         result_str = "'"+obj.ToString().Replace("年", "-").Replace("月", "-").Replace("日", "")+"'";
                     }
                 }
                 return result_str;
             }
             catch
             {
                 throw;
             }
         }
     }
 }

实体类：

 using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
 using Common; namespace Model
 {
     public class MainModel:EntityBase
     {
         public decimal id { get; set; }
         public string title { get; set; }
         public string contents { get; set; }
         public string type { get; set; }
         public DateTime? date { get; set; }
         public string people { get; set; }
         public string picurl { get; set; }
         /// <summary>
         /// 设置主键
         /// </summary>
         /// <returns></returns>
         public override string GetPrimaryKey()
         {
             return "id";
         }
     }
 }

调用：

             Model.MainModel model = new Model.MainModel();
             model.title = context.Request.Form["txtTitle"];
             model.people = context.Request.Form["txtName"];
             model.contents = context.Request.Form["txtContent"];
             string resSql = model.GetInsertSql();