private void LoadDataSource()
{
cbxDBAlias.DisplayMember = "Name";
ItemBind ib = new ItemBind("", "");
cbxDBAlias.Items.Add(ib);
ThridDBSourceModel dbSourceModel = new ThridDBSourceModel(_dbHelper);
DataTable dtDBSource = dbSourceModel.GetAllThridDBSource();
foreach (DataRow dr in dtDBSource.Rows)
{
ThridDBSourceData dbSource = new ThridDBSourceData();
dbSource.BindRowData(dr);
ItemBind ibSource = new ItemBind(dbSource.数据源别名, "");
ibSource.Tag = dbSource;
cbxDBAlias.Items.Add(ibSource);
}
}
private void LoadDataSource()
{
tsCbxDataSource.ComboBox.DisplayMember = "Name";
ItemBind ib = new ItemBind("", "");
tsCbxDataSource.Items.Add(ib);
if (_dbSourceModel == null)
{
_dbSourceModel = new ThridDBSourceModel(_dbHelper);
}
DataTable dtDBSource = _dbSourceModel.GetAllThridDBSource();
foreach (DataRow dr in dtDBSource.Rows)
{
ThridDBSourceData dbSource = new ThridDBSourceData();
dbSource.BindRowData(dr);
ItemBind ibSource = new ItemBind(dbSource.数据源别名, "");
ibSource.Tag = dbSource;
tsCbxDataSource.Items.Add(ibSource);
}
}
private void LoadServerInfo(ThridDBSourceData thridDbSource)
{
_isLoadServerInfo = true;
try
{
textAlias.Text = thridDbSource.数据源别名;
textAlias.Tag = thridDbSource.数据源ID;
if (thridDbSource.数据源信息 != null)
{
txtIp.Text = thridDbSource.数据源信息.务器IP;
txtPort.Text = thridDbSource.数据源信息.端口.ToString();
txtInstance.Text = thridDbSource.数据源信息.数据实例;
txtUserAccount.Text = thridDbSource.数据源信息.授权账号;
txtUserPwd.Text = ThridDBSourceModel.DecryPwd(thridDbSource.数据源信息.授权密码);
cbxServerType.Text = thridDbSource.数据源信息.务器类型;
txtAssembly.Text = thridDbSource.数据源信息.驱动文件;
rtbDescription.Text = thridDbSource.数据源信息.备注描述;
}
}
finally
{
_isLoadServerInfo = false;
}
}
private void WriteDBSourceInfo(ref ThridDBSourceData dbSource)
{
dbSource.数据源别名 = textAlias.Text;
dbSource.数据源信息.务器类型 = cbxServerType.Text;
dbSource.数据源信息.务器IP = txtIp.Text;
dbSource.数据源信息.端口 = int.Parse(txtPort.Text);
dbSource.数据源信息.数据实例 = txtInstance.Text;
dbSource.数据源信息.授权账号 = txtUserAccount.Text;
dbSource.数据源信息.授权密码 = ThridDBSourceModel.EncryPwd(txtUserPwd.Text);
dbSource.数据源信息.驱动文件 = txtAssembly.Text;
dbSource.数据源信息.备注描述 = rtbDescription.Text;
dbSource.数据源信息.CopyBasePro(dbSource);
}
public void Init(IDBQuery dbHelper, ILoginUser loginUser)
{
_dbHelper = dbHelper;
_loginUser = loginUser;
_dbSourceModel = new ThridDBSourceModel(_dbHelper);
}
