Example #1
0
        public string ToMysqlString(string cellgs)
        {
            StringBuilder sbuilder = new StringBuilder();

            if (Cellgs.Equals("ALL") || cellgs.Equals("ALL") || Cellgs.Equals(cellgs))
            {
                sbuilder.Append(" `" + CellName + "` ");
                switch (CellValueType.ToLower())
                {
                case "int":
                    sbuilder.Append("int ");
                    break;

                case "boolean":
                    sbuilder.Append(" TINYINT(1) ");
                    break;

                case "double":
                    sbuilder.Append(" double ");
                    break;

                case "float":
                    sbuilder.Append(" float ");
                    break;

                case "string":

                    if (CellLength < 500)
                    {
                        sbuilder.Append(" VARCHAR(" + CellLength + ") ");
                    }
                    else if (CellLength < 10000)
                    {
                        sbuilder.Append(" TEXT ");
                    }
                    else
                    {
                        sbuilder.Append(" LONGTEXT ");
                    }
                    break;

                case "long":
                    sbuilder.Append(" bigint ");
                    break;
                }
                if (IsPKey)
                {
                    sbuilder.Append(" NOT NULL primary key ");
                }
                sbuilder.Append(" COMMENT '" + CellNotes + "'");
            }
            return(sbuilder.ToString());
        }
Example #2
0
 public string ToXmlString(string cellgs, bool is_Not_Null)
 {
     if (Cellgs.Equals("ALL") || cellgs.Equals("ALL") || Cellgs.Equals(cellgs))
     {
         if (is_Not_Null)
         {
             if (string.IsNullOrWhiteSpace(CellValue) || "0".Equals(CellValue))
             {
                 return(null);
             }
         }
         return(" " + CellName + "=\"" + CellValue + "\"");
     }
     return("");
 }