private void button2_Click(object sender, EventArgs e)
{
string serverName = txtServerName.Text;
string userid = this.txtUserID.Text;
string pass = this.txtPass.Text;
string connString = string.Format("Data Source={0};Initial Catalog=RSDataV2;User ID={1};Password={2}", serverName, userid, pass);
SqlConnection sqlConn = new SqlConnection(connString);
try
{
sqlConn.Open();
string str = ConfigurationManager.ConnectionStrings["conRsTool"].ConnectionString.Replace("(local)", txtServerName.Text).Replace("sa", txtUserID.Text).Replace("as1", txtPass.Text);;
string str2 = ConfigurationManager.ConnectionStrings["RSFinanceToolsEntities"].ConnectionString.Replace("127.0.0.1", txtServerName.Text).Replace("sa", txtUserID.Text).Replace("as1", txtPass.Text);;
Finance_Tools.ConnectionStringsSave("conRsTool", str);
Finance_Tools.ConnectionStringsSave("RSFinanceToolsEntities", str2);
hasSaved = true;
Finance_Tools.AppSettingSave("isSqlInitialize", "true");
this.Close();
}
catch (Exception)
{
MessageBox.Show("The test database connection failed! Please check the server name and database name is correct!");
hasSaved = false;
}
finally
{
sqlConn.Close();
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
SqlConnection conn = null;
SessionInfo.UserInfo.SunUserIP = this.txtSunServer.Text;
SessionInfo.UserInfo.SunUserID = this.txtSunID.Text;
SessionInfo.UserInfo.SunUserPass = this.txtSunPass.Text;
try
{
conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["conRsTool"].ConnectionString.ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("rsUsers_UserSunInfo_Upd", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SUNUserIP", SessionInfo.UserInfo.SunUserIP));
cmd.Parameters.Add(new SqlParameter("@SUNUserID", DEncrypt.Encrypt(SessionInfo.UserInfo.SunUserID)));
cmd.Parameters.Add(new SqlParameter("@SUNUserPass", DEncrypt.Encrypt(SessionInfo.UserInfo.SunUserPass)));
cmd.Parameters.Add(new SqlParameter("@id", SessionInfo.UserInfo.ID));
cmd.ExecuteNonQuery();
this.Close();
Finance_Tools.AppSettingSave("SuspenseAccount", this.txtSA.Text);
Finance_Tools.AppSettingSave("BusinessUnit", this.txtBU.Text);
SaveVisibleSetting(conn, cmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
ft.uPDATETemplateUpdateFlag(SessionInfo.UserInfo.ID, true);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
Control[] ctlsSF = this.panel4.Controls.Find("cbsunField", true);
Control[] ctlsFN = this.panel4.Controls.Find("cbfriendlyName", true);
Control[] ctlsO = this.panel4.Controls.Find("cbOutput", true);
Control[] ctlsI = this.panel4.Controls.Find("cbinput", true);
SqlConnection conn = null;
if (Tag == "Gen")
{
try
{
conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["conRsTool"].ConnectionString.ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("rsTemplateGenDescFields_Del", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TemplateID", SessionInfo.UserInfo.File_ftid));
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("rsTemplateGenDescFields_Ins", conn);
cmd2.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < ctlsSF.Length; i++)
{
string sunfield = ((TextBox)ctlsSF[i]).Text;
string friendname = ((TextBox)ctlsFN[i]).Text;
string output = ((ComboBox)ctlsO[i]).Text;
string xmlquery = ((TextBox)ctlsI[i]).Text;
cmd2.Parameters.Clear();
cmd2.Parameters.Add(new SqlParameter("@FieldGroup", ""));
cmd2.Parameters.Add(new SqlParameter("@SunField", sunfield));
cmd2.Parameters.Add(new SqlParameter("@UserFriendlyName", friendname));
cmd2.Parameters.Add(new SqlParameter("@Output", output));
cmd2.Parameters.Add(new SqlParameter("@Input", ""));
cmd2.Parameters.Add(new SqlParameter("@XML_Query", xmlquery));
cmd2.Parameters.Add(new SqlParameter("@TemplateID", SessionInfo.UserInfo.File_ftid));
cmd2.Parameters.Add(new SqlParameter("@version", i));
cmd2.ExecuteNonQuery();
}
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
else
{
try
{
conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["conRsTool"].ConnectionString.ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("rsGlobalFields_Del", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("rsGlobalFields_Ins", conn);
cmd2.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < ctlsSF.Length; i++)
{
string sunfield = ((TextBox)ctlsSF[i]).Text;
string friendname = ((TextBox)ctlsFN[i]).Text;
string output = ((ComboBox)ctlsO[i]).Text;
string xmlquery = ((TextBox)ctlsI[i]).Text;
cmd2.Parameters.Clear();
cmd2.Parameters.Add(new SqlParameter("@FieldGroup", ""));
cmd2.Parameters.Add(new SqlParameter("@SunField", sunfield));
cmd2.Parameters.Add(new SqlParameter("@UserFriendlyName", friendname));
cmd2.Parameters.Add(new SqlParameter("@Output", output));
cmd2.Parameters.Add(new SqlParameter("@Input", ""));
cmd2.Parameters.Add(new SqlParameter("@XML_Query", xmlquery));
cmd2.Parameters.Add(new SqlParameter("@version", i));
cmd2.ExecuteNonQuery();
}
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
Finance_Tools.AppSettingSave("isUseFriendlyName", "true");
this.Close();
}
