/// <summary> /// 获取数据库的数据表 /// </summary> /// <returns></returns> public List <TableInfo> GetTables() { if (Global.GetInstance().DB != null) { if (Global.GetInstance().DB.DbType == SQLDbTypes.SQLServer) { return(SqlServerFunction.GetInstance().GetTables()); } if (Global.GetInstance().DB.DbType == SQLDbTypes.MySQL) { return(MySqlFunction.GetInstance().GetTables()); } } return(new List <TableInfo>()); }
/// <summary> /// 构造dao层框架 /// </summary> /// <param name="className"></param> /// <param name="tableInfo"></param> /// <returns></returns> private string GetJavaDalClass(string className, TableInfo tableInfo) { //构造总输出 var stringBuilder = new StringBuilder(); //引入常用包 stringBuilder.AppendLine("import java.util.*;"); stringBuilder.AppendLine("import java.sql.*;"); stringBuilder.AppendLine(""); //写类名 stringBuilder.AppendLine("/**"); stringBuilder.AppendLine(" * " + className + "数据访问层"); stringBuilder.AppendLine(" * @since " + DateTime.Now.ToString("yyyy-MM-dd")); stringBuilder.AppendLine(" * @author "); stringBuilder.AppendLine(" */"); stringBuilder.AppendLine("public class " + GetPropertyName(className) + "DAO {"); stringBuilder.AppendLine(""); //SQL stringBuilder.AppendLine(""); switch (Global.GetInstance().DB.DbType) { case SQLDbTypes.MySQL: stringBuilder.AppendLine(MySqlFunction.GetInstance().GetDalFields(tableInfo)); break; } //公开方法 stringBuilder.AppendLine(""); //添加方法 switch (Global.GetInstance().DB.DbType) { case SQLDbTypes.MySQL: { stringBuilder.AppendLine(MySqlFunction.GetInstance().GetInsertFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetBulkInsertFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetUpdateFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetDeleteFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetSelectFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetAllSelectFunc(className, tableInfo)); } break; } //私有方法 stringBuilder.AppendLine(""); //添加方法 switch (Global.GetInstance().DB.DbType) { case SQLDbTypes.MySQL: { stringBuilder.AppendLine(MySqlFunction.GetInstance().GetPrviateFuncs(className, tableInfo)); } break; } //构造结束 stringBuilder.AppendLine(""); stringBuilder.AppendLine("}"); return(stringBuilder.ToString()); }
private string GetCharpDalClass(string className, TableInfo tableInfo) { //构造总输出 var stringBuilder = new StringBuilder(); //写类名 stringBuilder.AppendLine("public class " + className); stringBuilder.AppendLine("{"); //写SQL语句部分 stringBuilder.AppendLine(""); stringBuilder.AppendLine("\t#region Fields"); stringBuilder.AppendLine(""); switch (Global.GetInstance().DB.DbType) { case SQLDbTypes.MySQL: stringBuilder.AppendLine(MySqlFunction.GetInstance().GetDalFields(tableInfo)); break; } //添加字段块标识结束 stringBuilder.AppendLine("\t#endregion Fields"); stringBuilder.AppendLine(""); //添加公共方法块开始 stringBuilder.AppendLine("\t#region Public Methods"); stringBuilder.AppendLine(""); //添加方法 switch (Global.GetInstance().DB.DbType) { case SQLDbTypes.MySQL: { stringBuilder.AppendLine(MySqlFunction.GetInstance().GetInsertFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetBulkInsertFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetUpdateFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetDeleteFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetSelectFunc(className, tableInfo)); stringBuilder.AppendLine(MySqlFunction.GetInstance().GetAllSelectFunc(className, tableInfo)); } break; } //添加公开方法块结束 stringBuilder.AppendLine("\t#endregion Public Methods"); //添加公共方法块开始 stringBuilder.AppendLine("\t#region Private Methods"); stringBuilder.AppendLine(""); //添加方法 switch (Global.GetInstance().DB.DbType) { case SQLDbTypes.MySQL: { stringBuilder.AppendLine(MySqlFunction.GetInstance().GetPrviateFuncs(className, tableInfo)); } break; } //添加公开方法块结束 stringBuilder.AppendLine("\t#endregion Private Methods"); //构造结束 stringBuilder.AppendLine(""); stringBuilder.AppendLine("}"); return(stringBuilder.ToString()); }