コード例 #1
0
        public static string InputConvert2(EntityConfig entity)
        {
            var code = new StringBuilder();

            code.AppendFormat(@"
        static void ReadFormValue(I{0} entity, FormConvert convert)
        {{", entity.Name);
            foreach (PropertyConfig field in entity.PublishProperty.Where(p => !p.IsPrimaryKey))
            {
                switch (field.CsType.ToLower())
                {
                case "short":
                case "int16":
                case "int":
                case "int32":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullInteger(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToInteger(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "bigint":
                case "long":
                case "int64":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullLong(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToLong(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "decimal":
                case "numeric":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullDecimal(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToDecimal(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "real":
                case "double":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullDouble(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToDouble(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "float":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullSingle(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToSingle(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "datetime":
                case "datetime2":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullDateTime(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToDateTime(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "bool":
                case "boolean":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullBoolean(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToBoolean(""{0}"");"
                                          , field.Name);
                    }
                    break;

                case "guid":
                case "uniqueidentifier":
                    if (field.Nullable)
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToNullGuid(""{0}"");"
                                          , field.Name);
                    }
                    else
                    {
                        code.AppendFormat(@"
            entity.{0} = convert.ToGuid(""{0}"");"
                                          , field.Name);
                    }
                    break;

                //case "byte":
                //case "char":
                //case "nchar":
                //case "varchar":
                //case "nvarchar":
                //case "string":
                //case "text":
                default:
                    code.AppendFormat(@"
            entity.{0} = convert.ToString(""{0}"",{1});"
                                      , field.Name
                                      , field.Nullable ? "true" : "false");
                    break;
                }
            }
            code.Append(@"
        }");
            return(code.ToString());
        }
コード例 #2
0
        /// <summary>
        ///     读取表与实体关联表,初始化表结构
        /// </summary>
        private static void ImportTable(HSSFWorkbook workbook, EntityConfig entity)
        {
            var labelCell = GetCellStyle(workbook, HorizontalAlignment.Left, VerticalAlignment.Center, true, CreateFontStyle(workbook, "宋体", 9, true));
            var valueCell = GetCellStyle(workbook, HorizontalAlignment.Left, VerticalAlignment.Center, true, CreateFontStyle(workbook, "宋体"));

            if (workbook.GetSheet(entity.ReadTableName) != null)
            {
                return;
            }

            var sheet = workbook.CreateSheet(entity.ReadTableName);
            int i     = 0;

            sheet.SetColumnWidth(i++, 4000);
            sheet.SetColumnWidth(i++, 4000);
            sheet.SetColumnWidth(i++, 2000);
            sheet.SetColumnWidth(i++, 2000);
            sheet.SetColumnWidth(i++, 2000);
            sheet.SetColumnWidth(i++, 2000);
            sheet.SetColumnWidth(i++, 8000);
            sheet.SetColumnWidth(i++, 2000);
            sheet.SetColumnWidth(i++, 2000);
            sheet.SetColumnWidth(i, 4000);

            var row = sheet.CreateRow(0);

            row.HeightInPoints = 20;//行高
            row.CreateCell(0).SetCell("TABLE:", labelCell);
            row.CreateCell(1).SetCellValue(entity.ReadTableName);
            SetCellRangeAddress(sheet, valueCell, 0, 0, 1, 3);

            row.CreateCell(4).SetCell("变动时间:", labelCell);
            SetCellRangeAddress(sheet, labelCell, 0, 0, 4, 5);
            row.CreateCell(6).SetCell(DateTime.Today.ToLongDateString(), valueCell);
            SetCellRangeAddress(sheet, valueCell, 0, 0, 6, 9);

            row = sheet.CreateRow(1);
            row.HeightInPoints = 20;//行高
            row.CreateCell(0).SetCell("中文名:", labelCell);
            row.CreateCell(1).SetCell(entity.Caption, valueCell);
            SetCellRangeAddress(sheet, valueCell, 1, 1, 1, 3);
            row.CreateCell(4).SetCell("变动类型:", labelCell);
            SetCellRangeAddress(sheet, labelCell, 1, 1, 4, 5);
            row.CreateCell(6).SetCell("新建", valueCell);
            SetCellRangeAddress(sheet, valueCell, 1, 1, 6, 9);

            row = sheet.CreateRow(3);
            row.HeightInPoints = 20;//行高
            i = 0;
            row.CreateCell(i++).SetCell("字段", labelCell);
            row.CreateCell(i++).SetCell("字段类型", labelCell);
            row.CreateCell(i++).SetCell("长度", labelCell);
            row.CreateCell(i++).SetCell("可为空", labelCell);
            row.CreateCell(i++).SetCell("主键", labelCell);
            row.CreateCell(i++).SetCell("默认值", labelCell);
            row.CreateCell(i++).SetCell("备注", labelCell);
            row.CreateCell(i++).SetCell("外键", labelCell);
            row.CreateCell(i++).SetCell("索引", labelCell);
            row.CreateCell(i).SetCell("更新时间", labelCell);
            var fields = entity.PublishProperty.ToArray();

            for (int line = 0; line < fields.Length; line++)
            {
                var field = fields[line];
                row = sheet.CreateRow(line + 4);
                row.HeightInPoints = 20;//行高
                i = 0;
                row.CreateCell(i++).SetCell(field.ColumnName, valueCell);
                row.CreateCell(i++).SetCell(field.DbType.ToUpper(), valueCell);
                row.CreateCell(i++).SetCell(field.CsType == "decimal" ? "(18,4)" : (field.Datalen > 0 ? field.Datalen.ToString() : "-"), valueCell);
                row.CreateCell(i++).SetCell(field.DbNullable ? "是" : "否", valueCell);
                row.CreateCell(i++).SetCell(field.IsPrimaryKey ? "是" : "否", valueCell);
                row.CreateCell(i++).SetCell(field.Nullable ? field.Initialization : "0", valueCell);
                row.CreateCell(i++).SetCell(field.Caption + ":" + field.Description, valueCell);
                row.CreateCell(i++).SetCell("未指定", valueCell);
                row.CreateCell(i++).SetCell(field.CreateIndex ? "是" : "否", valueCell);
                row.CreateCell(i).SetCell("", valueCell);
            }
        }