builderframeone.cs

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

            plus.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
            plus.AppendSpace(3, "strSql.Append(\"select ");
            plus.AppendLine(fieldslist + " \");");
            plus.AppendSpaceLine(3, "strSql.Append(\" FROM " + base.TableName + " \");");
            plus.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")");
            plus.AppendSpaceLine(3, "{\r\n");
            plus.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);");
            plus.AppendSpaceLine(3, "}");
            plus.AppendSpaceLine(3, "return " + base.DbHelperName + ".Query(strSql.ToString());");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatGetMaxIDParam()
        {
            StringPlus plus = new StringPlus();
            if (base.Keys.Count > 0)
            {
                string columnName = "";
                foreach (ColumnInfo info in base.Keys)
                {
                    if (CodeCommon.DbTypeToCS(info.TypeName) == "int")
                    {
                        columnName = info.ColumnName;
                        if (info.IsPK)
                        {
                            plus.AppendLine("");
                            plus.AppendSpaceLine(2, "/// <summary>");
                            plus.AppendSpaceLine(2, "/// 得到最大ID");
                            plus.AppendSpaceLine(2, "/// </summary>");
                            plus.AppendSpaceLine(2, "public int GetMaxId()");
                            plus.AppendSpaceLine(2, "{\r\n");
                            plus.AppendSpaceLine(2, "return " + base.DbHelperName + ".GetMaxID(\"" + columnName + "\", \"" + base.TableName + "\"); ");
                            plus.AppendSpaceLine(2, "}");
                            break;
                        }
                    }
                }
            }
            return plus.ToString();
        }

        private string CreatGetMaxIDProc()
        {
            StringPlus plus = new StringPlus();
            if (base.Keys.Count > 0)
            {
                string columnName = "";
                foreach (ColumnInfo info in base.Keys)
                {
                    if (CodeCommon.DbTypeToCS(info.TypeName) == "int")
                    {
                        columnName = info.ColumnName;
                        if (info.IsPK)
                        {
                            plus.AppendLine("");
                            plus.AppendSpaceLine(2, "/// <summary>");
                            plus.AppendSpaceLine(2, "/// 得到最大ID");
                            plus.AppendSpaceLine(2, "/// </summary>");
                            plus.AppendSpaceLine(2, "public int GetMaxId()");
                            plus.AppendSpaceLine(2, "{\r\n");
                            plus.AppendSpaceLine(2, "return " + base.DbHelperName + ".GetMaxID(\"" + columnName + "\", \"" + base.TableName + "\"); ");
                            plus.AppendSpaceLine(2, "}");
                            break;
                        }
                    }
                }
            }
            return plus.ToString();
        }

        private string CreatGetMaxIDSQL()
        {
            StringPlus plus = new StringPlus();
            if (base.Keys.Count > 0)
            {
                string columnName = "";
                foreach (ColumnInfo info in base.Keys)
                {
                    if (CodeCommon.DbTypeToCS(info.TypeName) == "int")
                    {
                        columnName = info.ColumnName;
                        if (info.IsPK)
                        {
                            plus.AppendLine("");
                            plus.AppendSpaceLine(2, "/// <summary>");
                            plus.AppendSpaceLine(2, "/// 得到最大ID");
                            plus.AppendSpaceLine(2, "/// </summary>");
                            plus.AppendSpaceLine(2, "public int GetMaxId()");
                            plus.AppendSpaceLine(2, "{\r\n");
                            plus.AppendSpaceLine(2, "return " + base.DbHelperName + ".GetMaxID(\"" + columnName + "\", \"" + base.TableName + "\"); ");
                            plus.AppendSpaceLine(2, "}");
                            break;
                        }
                    }
                }
            }
            return plus.ToString();
        }

        private string CreatGetModelParam()
        {
            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 void GetModel(" + 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 CreatGetModelProc()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 得到一个对象实体");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public void GetModel(" + 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");