/// <summary>
/// 初始化界面
/// </summary>
private void init()
{
connectionString = Config.WorkflowSource.ConnectionString;
var con = ConfigParse.GetConn <OracleConnection>(connectionString);
txtDataSource.Text = con.DataSource;
txtUserId.Text = Config.WorkflowSourceUser;
txtPassword.Text = Config.WorkflowSourcePassword;
}
private ConDbForm(ScriptForm parent)
{
this.parent = parent;
InitializeComponent();
OracleConnection con = ConfigParse.GetConn <OracleConnection>(Config.OracleSource.ConnectionString);
txtDataSource.Text = con.DataSource;
txtUserId.Text = Config.OracleSourceUser;
txtPassword.Text = Config.OracleSourcePassword;
}
/// <summary>
/// 初始化界面
/// </summary>
private void init()
{
connectionString = Config.Workflow.ConnectionString;
var con = ConfigParse.GetConn <SqlConnection>(connectionString);
txtDataSource.Text = con.DataSource;
txtDbName.Text = con.Database;
txtUserId.Text = Config.WorkflowUser;
txtPassword.Text = Config.WorkflowPassword;
}
/// <summary>
/// 初始化界面
/// </summary>
private void init()
{
connectionString1 = Config.WorkflowObject.ConnectionString;
connectionString2 = Config.WorkflowSource.ConnectionString;
var con1 = ConfigParse.GetConn <OracleConnection>(connectionString1);
var con2 = ConfigParse.GetConn <OracleConnection>(connectionString2);
txtDataSource1.Text = con1.DataSource;
txtUserId1.Text = Config.WorkflowObjectUser;
txtPassword1.Text = Config.WorkflowObjectPassword;
txtDataSource2.Text = con2.DataSource;
txtUserId2.Text = Config.WorkflowSourceUser;
txtPassword2.Text = Config.WorkflowSourcePassword;
}
private List <TreeNode> getDbNodes()
{
List <TreeNode> nodes = new List <TreeNode>();
const string sql = "SELECT TABLE_NAME AS NAME FROM USER_TABLES ORDER BY TABLE_NAME";
SqlHelper sqlHelper = new OracleHelper(ConfigParse.GetConnectionString(Conn));
var dt = sqlHelper.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
TreeNode node = new TreeNode();
node.Text = dataRow["NAME"].ToString();
nodes.Add(node);
}
}
return(nodes);
}
private void btnCreateScript_Click(object sender, EventArgs e)
{
var url = txtUrl.Text.Trim();
if (string.IsNullOrEmpty(url))
{
MessageBox.Show("请正确输入URL链接地址！");
return;
}
using (HttpClient client = new HttpClient())
{
var taskResult = client.PostAsync(url, null);
var result = taskResult.Result;
txtScript.Text = result.Content.ReadAsStringAsync().Result;
}
//记录ERP站点地址
ConfigParse.SaveConfigSections(cbErpSite.Text, cbErpSite.Text, "ERPSite");
//刷新ERP站点的选项
initSite();
}
/// <summary>
/// 保存设置源的数据库连接配置
/// </summary>
private void saveConfig()
{
var sourceName = cbSource.Text;
ConfigParse.SaveSqlServerConfigSections(sourceName, connectionString);
}
/// <summary>
/// 保存设置源的数据库连接配置
/// </summary>
private void saveConfig()
{
ConfigParse.SaveConfig("WorkflowSource", connectionString);
ConfigParse.SaveAppSettings("WorkflowSourceUser", txtUserId.Text.Trim().ToUpper());
ConfigParse.SaveAppSettings("WorkflowSourcePassword", txtPassword.Text.Trim());
}
/// <summary>
/// 保存设置对象的数据库连接配置
/// </summary>
private void saveConfig1()
{
ConfigParse.SaveConfig("WorkflowObject", connectionString1);
ConfigParse.SaveAppSettings("WorkflowObjectUser", txtUserId1.Text.Trim().ToUpper());
ConfigParse.SaveAppSettings("WorkflowObjectPassword", txtPassword1.Text.Trim());
}
/// <summary>
/// 保存设置源的数据库连接配置
/// </summary>
private void saveConfig()
{
ConfigParse.SaveConfig("Workflow", connectionString);
ConfigParse.SaveAppSettings("WorkflowUser", txtUserId.Text.Trim());
ConfigParse.SaveAppSettings("WorkflowPassword", txtPassword.Text.Trim());
}
