public string GetDeleteTable(KernelLib.Elements.TableEntity tb)
{
string DeletePhysicsTBSql = "Drop TABLE " + tb.TableName;
string createEntityTBSql = "DELETE FROM S_TABLES WHERE ID = " + tb.ID;
return DeletePhysicsTBSql + "&" + createEntityTBSql;
}
public string GetDeleteDB(KernelLib.Elements.DatabaseEntity db)
{
string DeletePhysicsDBSql = "Drop Database " + db.DatabaseName;
string createEntityDBSql = "DELETE FROM S_DATABASES WHERE ID = " + db.ID;
return DeletePhysicsDBSql + "&" + createEntityDBSql;
}
public string GetDeleteColumn(KernelLib.Elements.ColumnEntity col)
{
string createPhysicsColumnSql = "ALTER TABLE " + col.ParentTB.TableName + " DROP " + col.ColumnName;
string createEntityColumnSql = "DELETE FROM S_COLUMNS WHERE ID = " + col.ID;
return createPhysicsColumnSql + "&" + createEntityColumnSql;
}
public string GetCreateTable(KernelLib.Elements.TableEntity tb)
{
string createPhysicsTableSql = "Create Table " + tb.TableName + " ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY )";
string createEntityTableSql = "INSERT INTO S_TABLES(TableName, TableHeaderName, DatabaseID, IsCreate) VALUES('@TableName@', '@TableHeaderName@', '@DatabaseID@', '@IsCreate@'); SELECT MAX(ID) FROM S_TABLES";
createEntityTableSql = createEntityTableSql.Replace("@TableName@", tb.TableName);
createEntityTableSql = createEntityTableSql.Replace("@TableHeaderName@", tb.TableHeaderName);
createEntityTableSql = createEntityTableSql.Replace("@DatabaseID@", tb.ParentDB.ID);
createEntityTableSql = createEntityTableSql.Replace("@IsCreate@", tb.IsCreate);
return createPhysicsTableSql + "&" + createEntityTableSql;
}
public string GetLoadScript(KernelLib.SystemEntity.Entity entity, KernelLib.SystemEntity.ProjectEntity project)
{
StringBuilder script = new StringBuilder();
//查询脚本头
script.Append("SELECT ");
//查询字段脚本
script.Append(this.GetQueryColumnsScript(entity));
//查询表-------------暂时单表，马上升级为多表的查询
script.Append(" FROM ");
script.Append(this.GetTableName(entity.Items[0].Tb_ID, entity));
return script.ToString();
}
public string GetCreateColumn(KernelLib.Elements.ColumnEntity col)
{
string createPhysicsColumnSql = "ALTER TABLE "+ col.ParentTB.TableName +" ADD "+ col.ColumnName +" "+ ((DatabaseOptLib.DataClassType)(Convert.ToInt32(col.DataTypeID))).ToString() + "("+ col.Length +")";
string createEntityColumnSql = "INSERT INTO S_COLUMNS(ColumnName, ColumnHeaderName, DataTypeID, Length, TableID) VALUES('@ColumnName@', '@ColumnHeaderName@', '@DataTypeID@', '@Length@', '@TableID@')";
createEntityColumnSql = createEntityColumnSql.Replace("@ColumnName@", col.ColumnName);
createEntityColumnSql = createEntityColumnSql.Replace("@ColumnHeaderName@", col.ColumnHeaderName);
createEntityColumnSql = createEntityColumnSql.Replace("@DataTypeID@", col.DataTypeID);
createEntityColumnSql = createEntityColumnSql.Replace("@Length@", col.Length);
createEntityColumnSql = createEntityColumnSql.Replace("@TableID@", col.ParentTB.ID);
return createPhysicsColumnSql + "&" + createEntityColumnSql;
}
public string GetUpdateDB(KernelLib.Elements.DatabaseEntity db)
{
string createPhysicsDBSql = "";
string createEntityDBSql = "UPDATE S_DATABASES SET DatabaseHeaderName = '@DatabaseHeaderName@', Server = '@Server@', UID = '@UID@', Password = '******', DatabaseSystemTypeID = '@DatabaseSystemTypeID@' WHERE ID = @ID@";
createEntityDBSql = createEntityDBSql.Replace("@DatabaseHeaderName@", db.DatabaseHeaderName);
createEntityDBSql = createEntityDBSql.Replace("@Server@", db.Server);
createEntityDBSql = createEntityDBSql.Replace("@UID@", db.UID);
createEntityDBSql = createEntityDBSql.Replace("@Password@", db.Password);
createEntityDBSql = createEntityDBSql.Replace("@DatabaseSystemTypeID@", db.DatabaseSystemTypeID);
createEntityDBSql = createEntityDBSql.Replace("@ID@", db.ID);
return createPhysicsDBSql + "&" + createEntityDBSql;
}
private string GetTableName(string table_id, KernelLib.SystemEntity.Entity entity)
{
foreach (KernelLib.DatabaseEntity.TableEntity table in entity.Tables)
{
if (table.ID == table_id)
{
return table.Name;
}
}
//提交异常，没有返回对应的数据表格
ExceptionLib.System.DataFrameException exception = new ExceptionLib.System.DataFrameException();
//返回异常
exception.DontFindTable();
//附带代码，不然编译不通过
return null;
}
private string GetQueryColumnsScript(KernelLib.SystemEntity.Entity entity)
{
StringBuilder script = new StringBuilder();
//组织查询字段脚本
foreach (KernelLib.SystemEntity.Item item in entity.Items)
{
if (script.Length > 0)
script.Append(", ");
script.Append(this.GetTableName(item.Tb_ID, entity));
script.Append(".");
script.Append(item.Name);
}
return script.ToString();
}
public string GetUpdateColumn(KernelLib.Elements.ColumnEntity col, KernelLib.Elements.ColumnEntity newCol)
{
string createPhysicsColumnSql;
createPhysicsColumnSql = "ALTER TABLE " + newCol.ParentTB.TableName + " CHANGE " + col.ColumnName + " " + " " + newCol.ColumnName + " " + ((DatabaseOptLib.DataClassType)(Convert.ToInt32(newCol.DataTypeID))).ToString() + "(" + newCol.Length + ")"; ;
string createEntityColumnSql = "UPDATE S_COLUMNS SET ColumnName = '@ColumnName@', ColumnHeaderName = '@ColumnHeaderName@', DataTypeID = '@DataTypeID@', Length = '@Length@' WHERE ID = @ID@";
createEntityColumnSql = createEntityColumnSql.Replace("@ColumnName@", newCol.ColumnName);
createEntityColumnSql = createEntityColumnSql.Replace("@ColumnHeaderName@", newCol.ColumnHeaderName);
createEntityColumnSql = createEntityColumnSql.Replace("@DataTypeID@", newCol.DataTypeID);
createEntityColumnSql = createEntityColumnSql.Replace("@Length@", newCol.Length);
createEntityColumnSql = createEntityColumnSql.Replace("@ID@", col.ID);
return createPhysicsColumnSql + "&" + createEntityColumnSql;
}
public string GetCreateDB(KernelLib.Elements.DatabaseEntity db)
{
string createPhysicsDBSql = "Create Database "+ db.DatabaseName;
string createEntityDBSql = "INSERT INTO S_DATABASES(DatabaseName, DatabaseHeaderName, Server, UID, Password, IsCreate, DatabaseSystemTypeID) VALUES('@DatabaseName@', '@DatabaseHeaderName@', '@Server@', '@UID@', '@Password@', '@IsCreate@', '@DatabaseSystemTypeID@');SELECT MAX(ID) FROM S_DATABASES";
createEntityDBSql = createEntityDBSql.Replace("@DatabaseName@", db.DatabaseName);
createEntityDBSql = createEntityDBSql.Replace("@DatabaseHeaderName@", db.DatabaseHeaderName);
createEntityDBSql = createEntityDBSql.Replace("@Server@", db.Server);
createEntityDBSql = createEntityDBSql.Replace("@UID@", db.UID);
createEntityDBSql = createEntityDBSql.Replace("@Password@", db.Password);
createEntityDBSql = createEntityDBSql.Replace("@IsCreate@", db.IsCreate);
createEntityDBSql = createEntityDBSql.Replace("@DatabaseSystemTypeID@", db.DatabaseSystemTypeID);
return createPhysicsDBSql + "&" + createEntityDBSql;
}
public string GetUpdateTable(KernelLib.Elements.TableEntity tb, KernelLib.Elements.TableEntity newTab)
{
string createPhysicsTBSql;
if (tb.IsCreate == "1")
createPhysicsTBSql = "ALTER TABLE " + tb.TableName + " RENAME TO " + newTab.TableName;
else
createPhysicsTBSql = "Create Table " + newTab.TableName + " ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY )";
string createEntityTBSql = "UPDATE S_TABLES SET TableName = '@TableName@', TableHeaderName = '@TableHeaderName@', IsCreate = '@IsCreate@' WHERE ID = @ID@";
createEntityTBSql = createEntityTBSql.Replace("@TableName@", newTab.TableName);
createEntityTBSql = createEntityTBSql.Replace("@TableHeaderName@", newTab.TableHeaderName);
createEntityTBSql = createEntityTBSql.Replace("@IsCreate@", newTab.IsCreate);
createEntityTBSql = createEntityTBSql.Replace("@ID@", tb.ID);
return createPhysicsTBSql + "&" + createEntityTBSql;
}
public iScript CreateClient(KernelLib.SystemEntity.ProjectEntity project)
{
iScript script = null;
try
{
string data_type = project.DbEntity.Data_Type;
string dll_path = _sClassPath + ((DatabaseLib.DataType)(Int32.Parse(data_type))).ToString();
//获取对应的数据库类型
Type ClientType = Type.GetType(dll_path, true);
//创建对应的数据库操作实例并返回给接口使外层代码通过接口能找到数据库操作实现代码
script = (iScript)Activator.CreateInstance(ClientType);
}
catch (Exception ex)
{
//获取操作异常的错误信息
this.Message = ex.Message;
this.Result = false;
}
//返回操作实例代码
return script;
}
public DataTable LoadData(KernelLib.SystemEntity.ModuleEntity module, KernelLib.SystemEntity.ProjectEntity project)
{
DataFrameLib.ScriptFactory scriptFactory = new DataFrameLib.ScriptFactory();
DatabaseLib.DatabaseFactory dataFactory = new DatabaseLib.DatabaseFactory();
//获取数据访问操作端
DatabaseLib.IDatabase dataClient = dataFactory.CreateClient(BaseLib.SystemType.Web);
//获取脚本生成对象
DataFrameLib.iScript script = scriptFactory.CreateClient(project);
//生成执行脚本
string strScript = script.GetLoadScript(module.Entity, project);
dataClient.SqlText = strScript;
DataSet ds = dataClient.Query();
this.Message = dataClient.Message;
this.Result = dataClient.Result;
if (this.Result)
return ds.Tables[0];
else
return null;
}
public string GetUpdateScript(KernelLib.SystemEntity.Entity entity, KernelLib.SystemEntity.ProjectEntity project)
{
throw new NotImplementedException();
}
