builderframeone.cs

通过数据库结构自动 生成三层结构代码,相当不错的一款软件

        }

        private string CreatConstructorParam()
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("\r\n");
            builder.Append(base.Space(2) + "/// <summary>\r\n");
            builder.Append(base.Space(2) + "/// 得到一个对象实体\r\n");
            builder.Append(base.Space(2) + "/// </summary>\r\n");
            builder.Append(base.Space(2) + "public " + base.ModelName + "(" + CodeCommon.GetInParameter(base.Keys) + ")\r\n");
            builder.Append(base.Space(2) + "{\r\n");
            builder.Append(base.Space(3) + "StringBuilder strSql=new StringBuilder();\r\n");
            builder.Append(base.Space(3) + "strSql.Append(\"select ");
            builder.Append(base.Fieldstrlist + " \");\r\n");
            builder.Append(base.Space(3) + "strSql.Append(\" FROM " + base.TableName + " \");\r\n");
            if (this.GetWhereExpression(base.Keys).Length > 0)
            {
                builder.Append(base.Space(3) + "strSql.Append(\" where " + this.GetWhereExpression(base.Keys) + "\");\r\n");
            }
            else
            {
                builder.Append(base.Space(3) + "//strSql.Append(\" where 条件);\r\n");
            }
            builder.AppendLine(this.GetPreParameter(base.Keys));
            builder.Append(base.Space(3) + "DataSet ds=" + base.DbHelperName + ".Query(strSql.ToString(),parameters);\r\n");
            builder.Append(base.Space(3) + "if(ds.Tables[0].Rows.Count>0)\r\n");
            builder.Append(base.Space(3) + "{\r\n");
            foreach (ColumnInfo info in base.Fieldlist)
            {
                string columnName = info.ColumnName;
                switch (CodeCommon.DbTypeToCS(info.TypeName))
                {
                    case "int":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                    case "decimal":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                    case "DateTime":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                    case "string":
                    {
                        builder.Append(base.Space(4) + "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
                        continue;
                    }
                    case "bool":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))\r\n");
                        builder.Append(base.Space(5) + "{\r\n");
                        builder.Append(base.Space(6) + "" + columnName + "=true;\r\n");
                        builder.Append(base.Space(5) + "}\r\n");
                        builder.Append(base.Space(5) + "else\r\n");
                        builder.Append(base.Space(5) + "{\r\n");
                        builder.Append(base.Space(6) + "" + columnName + "=false;\r\n");
                        builder.Append(base.Space(5) + "}\r\n");
                        builder.Append(base.Space(4) + "}\r\n\r\n");
                        continue;
                    }
                    case "byte[]":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                }
                builder.Append(base.Space(4) + "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
            }
            builder.Append(base.Space(3) + "}\r\n");
            builder.Append(base.Space(2) + "}");
            return builder.ToString();
        }

        private string CreatConstructorProc()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 得到一个对象实体");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public " + base.ModelName + "(" + CodeCommon.GetInParameter(base.Keys) + ")");
            plus.AppendSpaceLine(2, "{");
            plus.AppendLine(this.GetPreParameter(base.Keys));
            plus.AppendSpaceLine(3, "DataSet ds= " + base.DbHelperName + ".RunProcedure(\"UP_" + base.TableName + "_GetModel\",parameters,\"ds\");");
            plus.AppendSpaceLine(3, "if(ds.Tables[0].Rows.Count>0)");
            plus.AppendSpaceLine(3, "{");
            foreach (ColumnInfo info in base.Fieldlist)
            {
                string columnName = info.ColumnName;
                switch (CodeCommon.DbTypeToCS(info.TypeName))
                {
                    case "int":
                    {
                        plus.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
                        plus.AppendSpaceLine(4, "{");
                        plus.AppendSpaceLine(5, "" + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
                        plus.AppendSpaceLine(4, "}");
                        continue;
                    }
                    case "decimal":
                    {
                        plus.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
                        plus.AppendSpaceLine(4, "{");
                        plus.AppendSpaceLine(5, "" + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
                        plus.AppendSpaceLine(4, "}");
                        continue;
                    }
                    case "DateTime":
                    {
                        plus.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
                        plus.AppendSpaceLine(4, "{\r\n");
                        plus.AppendSpaceLine(5, "" + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
                        plus.AppendSpaceLine(4, "}");
                        continue;
                    }
                    case "string":
                    {
                        plus.AppendSpaceLine(4, "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();");
                        continue;
                    }
                    case "bool":
                    {
                        plus.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        plus.Append(base.Space(4) + "{\r\n");
                        plus.Append(base.Space(5) + "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))\r\n");
                        plus.Append(base.Space(5) + "{\r\n");
                        plus.Append(base.Space(6) + "" + columnName + "=true;\r\n");
                        plus.Append(base.Space(5) + "}\r\n");
                        plus.Append(base.Space(5) + "else\r\n");
                        plus.Append(base.Space(5) + "{\r\n");
                        plus.Append(base.Space(6) + "" + columnName + "=false;\r\n");
                        plus.Append(base.Space(5) + "}\r\n");
                        plus.Append(base.Space(4) + "}\r\n\r\n");
                        continue;
                    }
                    case "byte[]":
                    {
                        plus.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        plus.Append(base.Space(4) + "{\r\n");
                        plus.Append(base.Space(5) + "" + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
                        plus.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                }
                plus.AppendSpaceLine(4, "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();");
            }
            plus.AppendSpaceLine(3, "}");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatConstructorSQL()
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("\r\n");
            builder.Append(base.Space(2) + "/// <summary>\r\n");
            builder.Append(base.Space(2) + "/// 得到一个对象实体\r\n");
            builder.Append(base.Space(2) + "/// </summary>\r\n");
            builder.Append(base.Space(2) + "public " + base.ModelName + "(" + CodeCommon.GetInParameter(base.Keys) + ")\r\n");
            builder.Append(base.Space(2) + "{\r\n");
            builder.Append(base.Space(3) + "StringBuilder strSql=new StringBuilder();\r\n");
            builder.Append(base.Space(3) + "strSql.Append(\"select  \");\r\n");
            builder.Append(base.Space(3) + "strSql.Append(\"" + base.Fieldstrlist + " \");\r\n");
            builder.Append(base.Space(3) + "strSql.Append(\" from " + base.TableName + " \");\r\n");
            if (CodeCommon.GetWhereExpression(base.Keys).Length > 0)
            {
                builder.Append(base.Space(3) + "strSql.Append(\" where " + CodeCommon.GetWhereExpression(base.Keys) + ");\r\n");
            }
            else
            {
                builder.Append(base.Space(3) + "//strSql.Append(\" where 条件);\r\n");
            }
            builder.Append(base.Space(3) + "DataSet ds=" + base.DbHelperName + ".Query(strSql.ToString());\r\n");
            builder.Append(base.Space(3) + "if(ds.Tables[0].Rows.Count>0)\r\n");
            builder.Append(base.Space(3) + "{\r\n");
            foreach (ColumnInfo info in base.Fieldlist)
            {
                string columnName = info.ColumnName;
                switch (CodeCommon.DbTypeToCS(info.TypeName))
                {
                    case "int":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                    case "decimal":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                    case "DateTime":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "" + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
                        builder.Append(base.Space(4) + "}\r\n");
                        continue;
                    }
                    case "string":
                    {
                        builder.Append(base.Space(4) + "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
                        continue;
                    }
                    case "bool":
                    {
                        builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
                        builder.Append(base.Space(4) + "{\r\n");
                        builder.Append(base.Space(5) + "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))\r\n");
                        builder.Append(base.Space(5) + "{\r\n");
                        builder.Append(base.Space(6) + "" + columnName + "=true;\r\n");
                        builder.Append(base.Space(5) + "}\r\n");
                        builder.Append(base.Space(5) + "else\r\n");
                        builder.Append(base.Space(5) + "{\r\n");
                        builder.Append(base.Space(6) + "" + columnName + "=false;\r\n");
                        builder.Append(base.Space(5) + "}\r\n");