/// <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); }