/// <summary>
/// 更新特定的一筆資料
/// </summary>
/// <param name="MenuTitle"></param>
/// <param name="SQLStatement"></param>
public void Edit(string Title, string ContentText, string UserID, string Password)
{
Fill();
DataRow[] drStore = null;
if (SqlTabData is SQLStoreDataSet.SQLTableDataTable)
{
drStore = (SqlTabData as SQLStoreDataSet.SQLTableDataTable).Select(string.Format("SQLCommandName='{0}'", Title));
drStore[0]["SQL"] = ContentText;
}
else if (SqlTabData is SQLStoreDataSet.SqlConnectionTableDataTable)
{
SQLStoreDataSet.SqlConnectionTableDataTable tabCnn = SqlTabData as SQLStoreDataSet.SqlConnectionTableDataTable;
SetIsDefaultByDataSourceName(tabCnn, Title);
drStore = tabCnn.Select(string.Format("ConnName='{0}'", Title));
drStore[0]["InitialCatalogName"] = ContentText;
drStore[0]["UserID"] = UserID;
drStore[0]["Password"] = Password;
}
if (drStore == null)
{
return;
}
Write();
}
/// <summary>
/// 將 DataSourceName 設定為預設的連線.
/// </summary>
/// <param name="tab"></param>
/// <param name="DataSourceName"></param>
private void SetIsDefaultByDataSourceName(
SQLStoreDataSet.SqlConnectionTableDataTable tab,
string DataSourceName)
{
foreach (DataRow row in tab.Rows)
{
row["IsDefault"] = false;
}
DataRow[] drCnn = tab.Select(string.Format("DataSourceName='{0}'", DataSourceName));
foreach (DataRow rowSelect in drCnn)
{
rowSelect["IsDefault"] = true;
}
}
private void GetData()
{
SQLStoreDataSet.SqlConnectionTableDataTable tabConn = ConnStore.GetAllData();
cbServer.DisplayMemberPath = "DataSourceName";
cbServer.SelectedValuePath = "DataSourceName";
cbServer.ItemsSource = tabConn;
//帶入上一次的 Default 值.
var result = tabConn.Rows.OfType <DataRow>().Where(r => (bool)r["IsDefault"]).FirstOrDefault();
if (result != null)
{
cbServer.Text = result["DataSourceName"].ToString();
txtPassword.Password = result["Password"].ToString();
txtUserID.Text = result["UserId"].ToString();
}
}
private void GetData()
{
SQLStoreDataSet.SqlConnectionTableDataTable tabConn = ConnStore.GetAllData();
cbServer.DisplayMember = "DataSourceName";
cbServer.ValueMember = "DataSourceName";
cbServer.DataSource = tabConn;
//帶入上一次的 Default 值.
var result = tabConn.Rows.OfType <DataRow>().Where(r => (bool)r["IsDefault"]).FirstOrDefault();
if (result != null)
{
cbServer.Text = result["DataSourceName"].ToString();
txtPassword.Text = result["Password"].ToString();
txtUserID.Text = result["UserId"].ToString();
cbInitialCatalog.Text = result["InitialCatalogName"].ToString();
chkSetDefault.Checked = (bool)result["IsDefault"];
chkUseLocalDB.Checked = result["UseLocalDB"] != DBNull.Value ? (bool)result["UseLocalDB"] : false;
}
}
/// <summary>
/// 取得一筆資料 (DataRow)
/// </summary>
/// <param name="Title">要查詢的條件 (如果是：SqlDataTable 就是SQLCommandName，如果是SqlConnectionTable 就使用DataSourceName)</param>
/// <returns></returns>
public DataRow GetOne(string Title)
{
DataRow result = null;
if (SqlTabData is SQLStoreDataSet.SqlConnectionTableDataTable) //如果是：SqlConnectionTableDataTable 就是DataSourceName
{
SQLStoreDataSet.SqlConnectionTableDataTable c = SqlTabData as SQLStoreDataSet.SqlConnectionTableDataTable;
DataRow[] dr = c.Select(string.Format("DataSourceName='{0}'", Title));
if (dr.Length > 0)
{
result = dr[0];
}
}
else if (SqlTabData is SQLStoreDataSet.SQLTableDataTable) //如果是SQLTableDataTable 就使用SQLCommandName
{
SQLStoreDataSet.SQLTableDataTable dt = SqlTabData as SQLStoreDataSet.SQLTableDataTable;
DataRow[] dr = dt.Select(string.Format("SQLCommandName='{0}'", Title));
if (dr.Length > 0)
{
result = dr[0];
}
}
return(result);
}
