public bool Add(CategoryItems entity)
        {
            //拼接SQL语句
            string cmd = entity.GetInsertSql();
            //读取属性名
            Dictionary <string, object> properties = entity.GetAllPorpertiesNameAndValues();
            List <SqlParameter>         ps         = new List <SqlParameter>();

            foreach (KeyValuePair <string, object> item in properties)
            {
                string paramName = "@" + item.Key;
                string field     = "{" + item.Key + "}";
                if (cmd.Contains(field))
                {
                    cmd = cmd.Replace(field, paramName);
                    //获取参数的数据类型
                    SqlParameter p = new SqlParameter(paramName, item.Value == null?DBNull.Value:item.Value);
                    ps.Add(p);
                }
            }
            SqlCmdHelper helper = new SqlCmdHelper()
            {
                SqlConnString = SqlConnString
            };

            return(helper.ExcuteNoQuery(cmd, ps.ToArray()) > 0);
        }