예제 #1
0
        /// <summary>
        /// 判断表字段集合中是否存在某字段
        /// </summary>
        /// <param name="index"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        public bool containsInList(TableCharacter index, List <TableCharacter> list)
        {
            bool contains = false;

            foreach (var temp in list)
            {
                if (temp.Field == index.Field)
                {
                    contains = true;
                    break;
                }
            }
            return(contains);
        }
예제 #2
0
        /// <summary>
        /// 获取表的字段和属性值
        /// </summary>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public List <TableCharacter> GetTableCharacters(string tableName)
        {
            List <TableCharacter> lstTableChar = new List <TableCharacter>();
            string    sql = string.Format("desc {0}", tableName);
            DataTable dt  = MySqlHelp.ExecuteSql(MySqlHelp.ConnectionStr, sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    TableCharacter temp = new TableCharacter();
                    temp.Field = dr["Field"].ToString();
                    temp.Type  = dr["Type"].ToString();
                    lstTableChar.Add(temp);
                }
            }
            return(lstTableChar);
        }