利用反射將Model轉化為sql

標籤：tsql   blog   foreach   color   col   span   type   UI   star   

 public string GetInsertSqlByModel(Object o)        {            StringBuilder sbStart = new StringBuilder();            StringBuilder sbFields = new StringBuilder();            StringBuilder sbValues = new StringBuilder();            Type t = o.GetType();            string modelName = t.Name;            foreach (PropertyInfo p in t.GetProperties())            {                sbFields.Append(p.Name + ",");                sbValues.AppendFormat("‘{0}‘,",p.GetValue(o));            }            sbStart.AppendFormat("insert into {0}({1}) values({2})",modelName,sbFields.ToString().TrimEnd(‘,‘), sbValues.ToString().TrimEnd(‘,‘));            return sbStart.ToString();        }

 

如果不需要添加為null或者為空白的欄位，則可以使用如下代碼 

      public string GetInsertSqlByModel(Object o)        {            StringBuilder sbStart = new StringBuilder();            StringBuilder sbFields = new StringBuilder();            StringBuilder sbValues = new StringBuilder();            Type t = o.GetType();            string modelName = t.Name;            foreach (PropertyInfo p in t.GetProperties())            {                if (p.GetValue(o) == null||string.IsNullOrEmpty(p.GetValue(o).ToString()))                {                    continue;                }                sbFields.Append(p.Name + ",");                sbValues.AppendFormat("‘{0}‘,",p.GetValue(o));            }            sbStart.AppendFormat("insert into {0}({1}) values({2})",modelName,sbFields.ToString().TrimEnd(‘,‘), sbValues.ToString().TrimEnd(‘,‘));            return sbStart.ToString();        }    }

 

利用反射將Model轉化為sql