/// <summary>
/// 生成TemplateDT对象。
/// </summary>
/// <param name="tableId"></param>
/// <returns></returns>
public static TemplateDT CreateTemplateDT(int tableId)
{
DataRowView tableView = DataMarket.GetTableInfo(tableId);
TableExpandDT table = new TableExpandDT(tableView);
return(new TemplateDT(table));
}
public void OnShowCode(string key)
{
m_ShowKey = key;
if (this.tableId < 1)
{
return;
}
if (m_ShowKey == "tableinfo")
{
DataRowView tableView = DataMarket.GetTableInfo(this.tableId);
TableExpandDT table = new TableExpandDT(tableView);
if (table.TableType.Trim().ToLower() == "v" || table.TableType.Trim().ToLower() == "p")
{
DBInfo();
return;
}
}
CodeObject obj = Template.s_CodeObjects[key];
if (obj != null)
{
this.SetInputText(obj.GetCode(this.tableId));
}
}
private void GetCode()
{
DataRowView tableView = DataMarket.GetTableInfo(this.tableId);
if (tableView == null)
{
return;
}
TableExpandDT table = new TableExpandDT(tableView);
tableName = table.TableName;
string sql = "select top 100 * from [{0}] {1}";
List <PKDT> pks = table.PKs;
string order = table.GetOrderStr();
sql = string.Format(sql, table.TableName, order);
//CodeObject obj = Template.s_CodeObjects["tableinfo"];
this.txtInputArea.Text = sql;
this.dgList.DataSource = null;
// this.txtDisplayArea.Text += this.txtInputArea.Text;
//this.txtInputArea.
ControlUtils.SetSQLColor(this.txtInputArea);
}
public void ReadTableDT(TableExpandDT dt, DataRow dr)
{
try
{
dt.TableName = Convert.ToString(dr["tableName"]);
dt.Id = Convert.ToInt32(dr["id"]);
dt.TableType = Convert.ToString(dr["tableType"]);
dt.Script = Convert.ToString(dr["script"]);
dt.CreateDate = Convert.ToString(dr["createDate"]);
}
catch //(System.Exception ex)
{
}
}
public void ReadTableDT(TableExpandDT dt, DataRow dr)
{
dt.TableName = Convert.ToString(dr["tableName"]);
dt.Id = Convert.ToInt32(dr["id"]);
dt.TableType = Convert.ToString(dr["tableType"]);
dt.Script = Convert.ToString(dr["script"]);
if (dt.Script != null)
{
string script = dt.Script;
int index = script.IndexOf("; InnoDB");
if (index > 0 && index < script.Length)
{
dt.Script = script.Substring(0, index);
}
}
}
public void SetTableID(int id)
{
this.tableId = id;
if (this.tableId > 0)
{
// 设置数据库表列显示信息
DataRowView tableView = DataMarket.GetTableInfo(this.tableId);
if (tableView == null)
{
return;
}
TableExpandDT table = new TableExpandDT(tableView);
this.dgvColumns.AutoGenerateColumns = false;
this.dgvColumns.DataSource = table.Columns;
}
else
{
this.dgvColumns.DataSource = null;
}
}
public TemplateDT(TableExpandDT detail)
{
baseDetail = detail;
}
/// <summary>
/// 生成TemplateDT对象。
/// </summary>
/// <param name="drv"></param>
/// <returns></returns>
public static TemplateDT CreateTemplateDT(DataRowView drv)
{
TableExpandDT table = new TableExpandDT(drv);
return(new TemplateDT(table));
}
public static void ReadTableDT(TableExpandDT dt, DataRow dr)
{
DB.ReadTableDT(dt, dr);
}
