ODB-Sql-Insert

private static Dictionary<string,string> _insertSql=new Dictionary<string,string>();
        public static string SQL_INSERT
        {
            get
            {
                if (!_insertSql.ContainsKey(CurrentType.Name))
                {
                    StringBuilder sqlHander = new StringBuilder();
                    StringBuilder sqlBody = new StringBuilder();
                    //初始SQL的前后两部分
                    sqlHander.AppendLine(" INSERT INTO [dbo].[" + CurrentType.Name + "] (");
                    sqlBody.AppendLine(" VALUES (");
                    //开始组建组
                    bool isFirst = true;
                    foreach (PropertyInfo info in Attributes)
                    {
                        //组建SQL
                        if (isFirst) { isFirst = false; } else { sqlHander.Append(","); sqlBody.Append(","); }
                        sqlHander.Append(info.Name);
                        sqlBody.Append("@" + info.Name);
                    }
                    sqlHander.AppendLine(")");
                    sqlBody.AppendLine(")");
                    _insertSql[CurrentType.Name] = sqlHander.ToString() + sqlBody.ToString();
                }
                return _insertSql[CurrentType.Name];
            }
        }