builderframeone.cs

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

                        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 CreatDeleteParam()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 删除一条数据");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public void Delete(" + CodeCommon.GetInParameter(base.Keys) + ")");
            plus.AppendSpaceLine(2, "{");
            plus.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
            if (base.dbobj.DbType != "OleDb")
            {
                plus.AppendSpaceLine(3, "strSql.Append(\"delete " + base.TableName + " \");");
            }
            else
            {
                plus.AppendSpaceLine(3, "strSql.Append(\"delete from " + base.TableName + " \");");
            }
            if (this.GetWhereExpression(base.Keys).Length > 0)
            {
                plus.AppendSpace(3, "strSql.Append(\" where " + this.GetWhereExpression(base.Keys) + "\");\r\n");
            }
            else
            {
                plus.AppendSpace(3, "//strSql.Append(\" where 条件);\r\n");
            }
            plus.AppendLine(this.GetPreParameter(base.Keys));
            plus.AppendSpaceLine(3, "" + base.DbHelperName + ".ExecuteSql(strSql.ToString(),parameters);");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatDeleteProc()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 删除一条数据");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public void Delete(" + CodeCommon.GetInParameter(base.Keys) + ")");
            plus.AppendSpaceLine(2, "{\r\n");
            plus.AppendSpaceLine(3, "int rowsAffected;");
            plus.AppendLine(this.GetPreParameter(base.Keys));
            plus.AppendSpaceLine(3, "" + base.DbHelperName + ".RunProcedure(\"UP_" + base.TableName + "_Delete\",parameters,out rowsAffected);");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatDeleteSQL()
        {
            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 Delete(" + CodeCommon.GetInParameter(base.Keys) + ")\r\n");
            builder.Append(base.Space(2) + "{\r\n");
            builder.Append(base.Space(3) + "StringBuilder strSql=new StringBuilder();\r\n");
            if (base._dbtype != "OleDb")
            {
                builder.Append(base.Space(3) + "strSql.Append(\"delete " + base.TableName + " \");\r\n");
            }
            else
            {
                builder.Append(base.Space(3) + "strSql.Append(\"delete 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) + "\t" + base.DbHelperName + ".ExecuteSql(strSql.ToString());\r\n");
            builder.Append(base.Space(2) + "}");
            return builder.ToString();
        }

        private string CreatExistsParam()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 是否存在该记录");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public bool Exists(" + CodeCommon.GetInParameter(base.Keys) + ")");
            plus.AppendSpaceLine(2, "{");
            plus.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
            plus.AppendSpaceLine(3, "strSql.Append(\"select count(1) from " + base.TableName + "\");");
            if (this.GetWhereExpression(base.Keys).Length > 0)
            {
                plus.AppendSpaceLine(3, "strSql.Append(\" where " + this.GetWhereExpression(base.Keys) + "\");\r\n");
            }
            else
            {
                plus.AppendSpaceLine(3, "//strSql.Append(\" where 条件);\r\n");
            }
            plus.AppendLine(this.GetPreParameter(base.Keys));
            plus.Append(CodeCommon.Space(3) + "return " + base.DbHelperName + ".Exists(strSql.ToString(),parameters);\r\n");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatExistsProc()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 是否存在该记录");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public bool Exists(" + CodeCommon.GetInParameter(base.Keys) + ")");
            plus.AppendSpaceLine(2, "{");
            plus.AppendSpaceLine(3, "int rowsAffected;");
            plus.AppendLine(this.GetPreParameter(base.Keys));
            plus.AppendSpaceLine(3, "int result= " + base.DbHelperName + ".RunProcedure(\"UP_" + base.TableName + "_Exists\",parameters,out rowsAffected);");
            plus.AppendSpaceLine(3, "if(result==1)");
            plus.AppendSpaceLine(3, "{");
            plus.AppendSpaceLine(4, "return true;");
            plus.AppendSpaceLine(3, "}");
            plus.AppendSpaceLine(3, "else");
            plus.AppendSpaceLine(3, "{");
            plus.AppendSpaceLine(4, "return false;");
            plus.AppendSpaceLine(3, "}");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatExistsSQL()
        {
            StringPlus plus = new StringPlus();
            if (base.Keys.Count > 0)
            {
                plus.AppendLine("");
                plus.AppendSpaceLine(2, "/// <summary>");
                plus.AppendSpaceLine(2, "/// 是否存在该记录");
                plus.AppendSpaceLine(2, "/// </summary>");
                plus.AppendSpaceLine(2, "public bool Exists(" + CodeCommon.GetInParameter(base.Keys) + ")");
                plus.AppendSpaceLine(2, "{");
                plus.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
                plus.AppendSpace(3, "strSql.Append(\"select count(1) from " + base.TableName);
                plus.AppendSpaceLine(0, " where " + CodeCommon.GetWhereExpression(base.Keys) + " );");
                plus.AppendSpaceLine(3, "return " + base.DbHelperName + ".Exists(strSql.ToString());");
                plus.AppendSpace(2, "}");
            }
            return plus.ToString();
        }

        private string CreatGetListByPageProc()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/*");
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 分页获取数据列表");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public DataSet GetList(int PageSize,int PageIndex,string strWhere)");
            plus.AppendSpaceLine(2, "{");
            plus.AppendSpaceLine(3, "" + base.DbParaHead + "Parameter[] parameters = {");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@tblName\", " + base.DbParaDbType + ".VarChar, 255),");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@fldName\", " + base.DbParaDbType + ".VarChar, 255),");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@PageSize\", " + base.DbParaDbType + "." + CodeCommon.CSToProcType(base._dbtype, "int") + "),");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@PageIndex\", " + base.DbParaDbType + "." + CodeCommon.CSToProcType(base._dbtype, "int") + "),");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@IsReCount\", " + base.DbParaDbType + "." + CodeCommon.CSToProcType(base._dbtype, "bit") + "),");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@OrderType\", " + base.DbParaDbType + "." + CodeCommon.CSToProcType(base._dbtype, "bit") + "),");
            plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@strWhere\", " + base.DbParaDbType + ".VarChar,1000),");
            plus.AppendSpaceLine(5, "};");
            plus.AppendSpaceLine(3, "parameters[0].Value = \"" + base.TableName + "\";");
            plus.AppendSpaceLine(3, "parameters[1].Value = \"" + base._key + "\";");
            plus.AppendSpaceLine(3, "parameters[2].Value = PageSize;");
            plus.AppendSpaceLine(3, "parameters[3].Value = PageIndex;");
            plus.AppendSpaceLine(3, "parameters[4].Value = 0;");
            plus.AppendSpaceLine(3, "parameters[5].Value = 0;");
            plus.AppendSpaceLine(3, "parameters[6].Value = strWhere;\t");
            plus.AppendSpaceLine(3, "return " + base.DbHelperName + ".RunProcedure(\"UP_GetRecordByPage\",parameters,\"ds\");");
            plus.AppendSpaceLine(2, "}*/");
            return plus.Value;
        }

        private string CreatGetListParam()
        {
            DataTable columnInfoDt = CodeCommon.GetColumnInfoDt(base.dbobj.GetColumnInfoList(base.DbName, base.TableName));
            StringPlus plus = new StringPlus();
            string fieldslist = base.GetFieldslist(columnInfoDt);
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 获得数据列表");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public DataSet GetList(string strWhere)");
            plus.AppendSpaceLine(2, "{");
            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, "{");
            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 CreatGetListProc()
        {
            StringPlus plus = new StringPlus();
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 获取数据列表");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public DataSet GetList()");
            plus.AppendSpaceLine(2, "{");
            plus.AppendSpaceLine(3, "return " + base.DbHelperName + ".RunProcedure(\"UP_" + base.TableName + "_GetList\",new SqlParameter[] { null },\"ds\");");
            plus.AppendSpaceLine(2, "}");
            return plus.Value;
        }

        private string CreatGetListSQL()
        {
            DataTable columnInfoDt = CodeCommon.GetColumnInfoDt(base.dbobj.GetColumnList(base.DbName, base.TableName));
            StringPlus plus = new StringPlus();
            string fieldslist = base.GetFieldslist(columnInfoDt);
            plus.AppendSpaceLine(2, "/// <summary>");
            plus.AppendSpaceLine(2, "/// 获得数据列表");
            plus.AppendSpaceLine(2, "/// </summary>");
            plus.AppendSpaceLine(2, "public DataSet GetList(string strWhere)");
            plus.AppendSpaceLine(2, "{");