public ConnectionStringSettings OnConnectionStringRetrieve(IAppSettings appSettings, IConnectionStrings connectionStrings,
ConnectionStringSettings originalValue)
{
return null;
}
public MessageControl(string User)
{
UserId = User;
connectionStringSettings = ConfigurationManager.ConnectionStrings["MainDatabase"];
cnn = new SqlConnection(connectionStringSettings.ConnectionString);
}
public EkDb()
{
//----- Grab the connection strings from web.config
m_cssEkDb = WebConfigurationManager.ConnectionStrings["Ektron.DbConnection"];
//----- Figure out which type of database to deal with.
switch (m_cssEkDb.ProviderName)
{
case PROVIDER_SQL:
{
m_sDbType = NAME_SQL;
break;
}
case PROVIDER_ORACLE:
{
m_sDbType = NAME_ORACLE;
break;
}
default:
{
m_sDbType = "Provider in web.config is undefined";
break;
}
}
m_sConnString = m_cssEkDb.ConnectionString;
//----- Parse the connection string to provide easy access to it's components.
ParseDbConnectionString();
//----- Try to connect and set connection status.
ConnectToDB();
}
public void OnConnectionStringRetrieve_WhenValueContainsReplacementTokensAndKeyDoesntExist_ReturnsValueAsWritten()
{
var connString = new ConnectionStringSettings("name", "{tenant}");
var val = _interceptor.OnConnectionStringRetrieve(_appSettings, _connectionStringsExtended, connString);
Assert.That(val.ConnectionString, Is.EqualTo("{tenant}"));
}
public void OnConnectionStringRetrieve_WhenValueContainsReplacementTokensOfOtherConfigKey_ReturnsValueAfterReplacement()
{
_appSettings.Add("tenant", "tenant-here");
var connString = new ConnectionStringSettings("name", "{tenant}");
var val = _interceptor.OnConnectionStringRetrieve(_appSettings, _connectionStringsExtended, connString);
Assert.That(val.ConnectionString, Is.EqualTo("tenant-here"));
}
public GetValuesOD()
{
//
// TODO: Add constructor logic here
//
variableDs = ODvariables.GetVariableDataSet();
unitsDs = ODUnits.getUnitsDataset();
oDconnectionString = ConfigurationManager.ConnectionStrings["ODDB"];
}
public void AddConnectionString(string name, string providerName, string connectionString)
{
var s = new ConnectionStringSettings
{
ConnectionString = connectionString,
Name = name,
ProviderName = providerName,
IsGlobal = false
};
_strings.Add(s);
}
private static void RunProcessor(ConnectionStringSettings tycheDBCN, ISemanticProcessor processor)
{
if (processor != null)
{
var tycheRepo = new Repository(tycheDBCN.ConnectionString);
processor.TycheRepository = tycheRepo;
processor.Start();
processor.Stop();
}
}
protected DbBaseService(ConnectionStringSettings connectionString, string tenantColumn)
{
db = new DbExecuter(connectionString);
TenantColumn = tenantColumn;
}
public void Add(ConnectionStringSettings settings)
{
Raw.Add(settings);
}
/// <summary>
/// Configures the properties of each supported database flavor. You need to extend this method if you want to
/// add your own database flavor.
/// </summary>
/// <param name="config"></param>
/// <param name="connectionStrings"></param>
/// <returns></returns>
private DatabaseFlavour SetupFlavourProperties(DatabaseSection config, ConnectionStringsSection connectionStrings)
{
DatabaseFlavour flavour = config.Flavour;
if (flavour == DatabaseFlavour.AutoDetect)
{
ConnectionStringSettings css = connectionStrings.ConnectionStrings[config.ConnectionStringName];
if (css == null)
{
throw new ConfigurationErrorsException("Could not find the connection string named '" + config.ConnectionStringName + "' that was defined in the n2/database configuration section. If you installed using NuGet try installing 'N2 CMS SQLite config' or configuring this connection string manually.");
}
flavour = DetectFlavor(css);
}
// HACK: used to support seamless text/nvarchar(max) support across databases
if (flavour == DatabaseFlavour.MySql)
{
stringLength = 16777215;
}
switch (flavour)
{
case DatabaseFlavour.SqlServer2000:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSql2000Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlServer2005:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSql2005Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlServer:
case DatabaseFlavour.SqlServer2008:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSql2008Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlCe3:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlServerCeDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSqlCeDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqlCe:
case DatabaseFlavour.SqlCe4:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SqlServerCeDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MsSqlCe40Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.MySql:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.MySqlDataDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.MySQL5Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.SqLite:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.SQLite20Driver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.SQLiteDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Firebird:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.FirebirdDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.FirebirdDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Generic:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OleDbDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.GenericDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Jet:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = "NHibernate.JetDriver.JetDriver, NHibernate.JetDriver";
Properties[NHibernate.Cfg.Environment.Dialect] = "NHibernate.JetDriver.JetDialect, NHibernate.JetDriver";
break;
case DatabaseFlavour.DB2:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OdbcDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.DB2Dialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Oracle9i:
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OracleClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.Oracle9iDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.Oracle:
case DatabaseFlavour.Oracle10g:
// if you have OracleOdpDriver installed
// use the following line instead of the the later one (NOTICE both apply to the same property)
// Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OracleDataClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.ConnectionDriver] = typeof(NHibernate.Driver.OracleClientDriver).AssemblyQualifiedName;
Properties[NHibernate.Cfg.Environment.Dialect] = typeof(NHibernate.Dialect.Oracle10gDialect).AssemblyQualifiedName;
break;
case DatabaseFlavour.MongoDB:
return(DatabaseFlavour.MongoDB);
case DatabaseFlavour.Xml:
return(DatabaseFlavour.Xml);
default:
throw new ConfigurationErrorsException("Couldn't determine database flavour. Please check the 'flavour' attribute of the n2/database configuration section.");
}
return(flavour);
}
///// TODO add queue and pool limit
#region Public Methods and Operators
/// <summary>
/// Returns a <see cref="TextFormatTypesQueryEngine"/> instance for the specified
/// <paramref name="connectionStringSettings"/>
/// </summary>
/// <param name="connectionStringSettings">
/// The connection string settings.
/// </param>
/// <returns>
/// The <see cref="TextFormatTypesQueryEngine"/>.
/// </returns>
public static TextFormatTypesQueryEngine GetTextFormatQuery(ConnectionStringSettings connectionStringSettings)
{
return(_connectionStringMap.GetOrAdd(connectionStringSettings, settings => new TextFormatTypesQueryEngine(settings)));
}
public void Add(ConnectionStringSettings settings) {}
public ConnectionStringSettings OnConnectionStringRetrieve(IAppSettings appSettings, IConnectionStrings connectionStrings, ConnectionStringSettings originalValue)
{
var modifiedConnectionString = OnSettingRetrieve(appSettings, string.Empty, originalValue.ConnectionString);
originalValue.ConnectionString = modifiedConnectionString;
return originalValue;
}
private void DeleteUpLoadFile(string DelType, TextBox ImgText, System.Web.UI.WebControls.Image ImgView, HyperLink FileLink, string DelFieldValue, string AspxFeildId, int NoneWidth, int NoneHeight)
{
string csCaseID = LBSWC000.Text + "";
string csDTLID = LBDTL001.Text + "";
string strSQLClearFieldValue = "";
//從資料庫取得資料
//ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
//using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
ConnectionStringSettings settingGeoUser = ConfigurationManager.ConnectionStrings["SWCConnStr"];
SqlConnection ConnERR = new SqlConnection();
ConnERR.ConnectionString = settingGeoUser.ConnectionString;
ConnERR.Open();
strSQLClearFieldValue = " update SWCDTL04 set ";
strSQLClearFieldValue = strSQLClearFieldValue + DelFieldValue + "='' ";
strSQLClearFieldValue = strSQLClearFieldValue + " where SWC000 = '" + csCaseID + "' ";
strSQLClearFieldValue = strSQLClearFieldValue + " and DTLD001 = '" + csDTLID + "' ";
SqlCommand objCmdRV = new SqlCommand(strSQLClearFieldValue, ConnERR);
objCmdRV.ExecuteNonQuery();
objCmdRV.Dispose();
ConnERR.Close();
//刪實體檔
string TempFolderPath = ConfigurationManager.AppSettings["SwcFileTemp"];
string SwcCaseFolderPath = ConfigurationManager.AppSettings["SwcFilePath"];
string DelFileName = ImgText.Text;
string TempFileFullPath = TempFolderPath + csCaseID + "\\" + ImgText.Text;
string FileFullPath = SwcCaseFolderPath + csCaseID + "\\" + ImgText.Text;
try
{
if (File.Exists(TempFileFullPath))
{
File.Delete(TempFileFullPath);
}
}
catch
{
}
try
{
if (File.Exists(FileFullPath))
{
File.Delete(FileFullPath);
}
}
catch
{
}
switch (DelType)
{
case "PIC":
ImgView.Attributes.Clear();
ImgView.ImageUrl = "";
ImgView.Width = NoneWidth;
ImgView.Height = NoneHeight;
break;
case "DOC":
FileLink.Text = "";
FileLink.NavigateUrl = "";
FileLink.Visible = false;
break;
}
//畫面顯示、值的處理
ImgText.Text = "";
Session[AspxFeildId] = "";
}
private void GetConnection(ConnectionStringSettings css)
{
if(dbFactory == null)
{
dbFactory = DbProviderFactories.GetFactory(css.ProviderName);
}
this.connection = dbFactory.CreateConnection();
this.connection.ConnectionString = css.ConnectionString;
}
/// <summary>
/// 保存连接字符串,配置节点：MySQL
/// </summary>
/// <param name="ConnStr"></param>
public static bool SaveConnString(string ConnStr)
{
try
{
bool isModified = false;
if (ConfigurationManager.ConnectionStrings["MySQL"] != null)
isModified = true;
ConnStr = SimpleEncStr(ConnStr);
ConnectionStringSettings mySettings = new ConnectionStringSettings("MySQL", ConnStr);
//Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
Configuration config = WebConfigurationManager.OpenWebConfiguration("~");
if (isModified)
config.ConnectionStrings.ConnectionStrings.Remove("MySQL");
config.ConnectionStrings.ConnectionStrings.Add(mySettings);
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("ConnectionStrings");
FConnString = ReadConnString();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 添加数据库连接字符串节点，如果已经存在此节点，则会修改该节点的值
/// </summary>
/// <param name="key"></param>
/// <param name="connectionString"></param>
public void AddConnectionString(string key, string connectionString)
{
ConnectionStringsSection connectionSetting = (ConnectionStringsSection)config.GetSection("connectionStrings");
if (connectionSetting.ConnectionStrings[key] == null)//如果不存在此节点，则添加
{
ConnectionStringSettings connectionStringSettings = new ConnectionStringSettings(key, connectionString);
connectionSetting.ConnectionStrings.Add(connectionStringSettings);
}
else//如果存在此节点，则修改
{
ModifyConnectionString(key, connectionString);
}
}
private ConnectionStringSettings Intercept(ConnectionStringSettings rawSetting)
{
rawSetting = _interceptors.Aggregate(rawSetting,
(current, interceptor) => interceptor.OnConnectionStringRetrieve(_appSettings, this, current));
return rawSetting;
}
public void Remove(ConnectionStringSettings settings)
{
Raw.Remove(settings);
}
public List <Employee> getEmployeeList()
{
if (!EventLog.SourceExists("EmployeesTransactions"))
{
EventLog.CreateEventSource("EmployeesTransactions", "MyNewLog");
}
EventLog myLog = new EventLog();
myLog.Source = "EmployeesTransactions";
Debug.Listeners.Add(new ConsoleTraceListener());
Debug.Indent();
Debug.WriteLine("Start Get Employee Info ");
Debug.Unindent();
ConnectionStringSettings cnSettings = ConfigurationManager.ConnectionStrings["transaction_system"];
using (SqlConnection cn = new SqlConnection())
{
Debug.Assert(cn != null, "Conection cannot be null");
cn.ConnectionString = cnSettings.ConnectionString;
cn.Open();
Debug.Indent();
Debug.WriteLine("Connection Stablish succesfull");
Debug.Unindent();
SqlDataReader rdr = null;
var option = new TransactionOptions();
Debug.Assert(option != null, "Transaction cannot be null");
option.IsolationLevel = IsolationLevel.ReadCommitted;
option.Timeout = TimeSpan.FromMinutes(5);
using (var scope = new TransactionScope(TransactionScopeOption.Required, option))
{
Debug.WriteLine("Transaction Scope started");
try
{
using (SqlCommand cmd = new SqlCommand("get_employee_info", cn))
{
Debug.Indent();
Debug.WriteLine("Execute Store Procedure");
Debug.Unindent();
cmd.CommandType = CommandType.StoredProcedure;
rdr = cmd.ExecuteReader();
Debug.Indent();
Debug.WriteLine("Procedure executed succesfull");
Debug.Unindent();
while (rdr.Read())
{
Employee emp = new Employee();
Debug.Indent();
Debug.WriteLine("Reading Results");
Debug.Unindent();
emp.employee_id = rdr["employee_id"].ToString();
emp.employee_name = rdr["employee_name"].ToString();
emp.employee_first_surname = rdr["employee_first_surname"].ToString();
emp.employee_second_surname = rdr["employee_second_surname"].ToString();
emp.employee_email = rdr["employee_email"].ToString();
emp.employee_username = rdr["employee_username"].ToString();
emp.employee_salary = rdr["employee_salary"].ToString();
employeeInfo.Add(emp);
}
rdr.Close();
Debug.Indent();
Debug.WriteLine("reader Closed");
Debug.Unindent();
}
scope.Complete();
Debug.Indent();
Debug.WriteLine("Transaction Completed");
Debug.Unindent();
return(employeeInfo);
}
catch (Exception e)
{
myLog.WriteEntry("Could not connect", EventLogEntryType.Error, 1001, 1);
scope.Dispose();
MessageBox.Show(e.Message);
}
}
}
Debug.WriteLine("Get Info function done");
return(employeeInfo);
}
public ConnectionStringSettings OnConnectionStringRetrieve(IAppSettings appSettings, IConnectionStrings connectionStrings,
ConnectionStringSettings originalValue)
{
return new ConnectionStringSettings(originalValue.Name, _returnThis, originalValue.ProviderName);
}
protected void SaveCase_Click(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string ssUserID = Session["ID"] + "";
string sSWC000 = rCaseId;
string sDTLD000 = LBDTL001.Text + "";
string sDTLD002 = TXTDTL002.Text + "";
string sDTLD003 = TXTDTL003.Text + "";
string sDTLD004 = TXTDTL004.Text + "";
string sDTLD005 = CHKDTL005.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD006 = DDLDTL006.SelectedValue + "";
string sDTLD007 = TXTDTL007.Text + "";
string sDTLD008 = TXTDTL008.Text + "";
string sDTLD009 = CHKDTL009.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD010 = DDLDTL010.SelectedValue + "";
string sDTLD011 = TXTDTL011.Text + "";
string sDTLD012 = TXTDTL012.Text + "";
string sDTLD013 = CHKDTL013.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD014 = DDLDTL014.SelectedValue + "";
string sDTLD015 = TXTDTL015.Text + "";
string sDTLD016 = TXTDTL016.Text + "";
string sDTLD017 = CHKDTL017.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD018 = DDLDTL018.SelectedValue + "";
string sDTLD019 = TXTDTL019.Text + "";
string sDTLD020 = TXTDTL020.Text + "";
string sDTLD021 = CHKDTL021.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD022 = DDLDTL022.SelectedValue + "";
string sDTLD023 = TXTDTL023.Text + "";
string sDTLD024 = TXTDTL024.Text + "";
string sDTLD025 = CHKDTL025.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD026 = DDLDTL026.SelectedValue + "";
string sDTLD027 = TXTDTL027.Text + "";
string sDTLD028 = TXTDTL028.Text + "";
string sDTLD029 = CHKDTL029.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD030 = DDLDTL030.SelectedValue + "";
string sDTLD031 = TXTDTL031.Text + "";
string sDTLD032 = TXTDTL032.Text + "";
string sDTLD033 = CHKDTL033.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD034 = DDLDTL034.SelectedValue + "";
string sDTLD035 = TXTDTL035.Text + "";
string sDTLD036 = TXTDTL036.Text + "";
string sDTLD037 = CHKDTL037.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD038 = DDLDTL038.SelectedValue + "";
string sDTLD039 = TXTDTL039.Text + "";
string sDTLD040 = TXTDTL040.Text + "";
string sDTLD041 = CHKDTL041.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD042 = DDLDTL042.SelectedValue + "";
string sDTLD043 = TXTDTL043.Text + "";
string sDTLD044 = TXTDTL044.Text + "";
string sDTLD045 = CHKDTL045.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD046 = DDLDTL046.Text + "";
string sDTLD047 = TXTDTL047.Text + "";
string sDTLD048 = TXTDTL048.Text + "";
string sDTLD049 = CHKDTL049.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD050 = DDLDTL050.SelectedValue + "";
string sDTLD051 = TXTDTL051.Text + "";
string sDTLD052 = TXTDTL052.Text + "";
string sDTLD053 = CHKDTL053.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD054 = DDLDTL054.SelectedValue + "";
string sDTLD055 = TXTDTL055.Text + "";
string sDTLD056 = TXTDTL056.Text + "";
string sDTLD057 = CHKDTL057.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD058 = DDLDTL058.SelectedValue + "";
string sDTLD059 = TXTDTL059.Text + "";
string sDTLD060 = TXTDTL060.Text + "";
string sDTLD061 = CHKDTL061.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD062 = DDLDTL062.SelectedValue + "";
string sDTLD063 = TXTDTL063.Text + "";
string sDTLD064 = TXTDTL064.Text + "";
string sDTLD065 = CHKDTL065.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD066 = DDLDTL066.SelectedValue + "";
string sDTLD067 = TXTDTL067.Text + "";
string sDTLD068 = TXTDTL068.Text + "";
string sDTLD069 = CHKDTL069.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD070 = DDLDTL070.SelectedValue + "";
string sDTLD071 = TXTDTL071.Text + "";
string sDTLD072 = TXTDTL072.Text + "";
string sDTLD073 = CHKDTL073.Checked.ToString().Replace("False", "").Replace("True", "1");
string sDTLD074 = DDLDTL074.SelectedValue + "";
string sDTLD075 = TXTDTL075.Text + "";
string sDTLD076 = TXTDTL076.Text + "";
string sDTLD077 = TXTDTL077.Text + "";
string sDTLD078 = TXTDTL078.Text + "";
string sDTLD079 = TXTDTL079.Text + "";
string sDTLD080 = TXTDTL080.Text + "";
string sDTLD081 = TXTDTL081.Text + "";
string sDTLD082 = TXTDTL082.Text + "";
string sDTLD083 = TXTDTL083.Text + "";
GBClass001 SBApp = new GBClass001();
string sEXESQLSTR = "";
string sEXESQLUPD = "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCDTL04 ";
strSQLRV = strSQLRV + " where DTLD000 = '" + sDTLD000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
if (!readeSwc.HasRows)
{
sEXESQLSTR = sEXESQLSTR + " INSERT INTO SWCDTL04 (SWC000,DTLD000) VALUES ('" + sSWC000 + "','" + sDTLD000 + "');";
}
readeSwc.Close();
objCmdSwc.Dispose();
sEXESQLSTR = sEXESQLSTR + " Update SWCDTL04 Set ";
sEXESQLSTR = sEXESQLSTR + " DTLD002 ='" + sDTLD002 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD003 ='" + sDTLD003 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD004 ='" + sDTLD004 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD005 ='" + sDTLD005 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD006 ='" + sDTLD006 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD007 ='" + sDTLD007 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD008 ='" + sDTLD008 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD009 ='" + sDTLD009 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD010 ='" + sDTLD010 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD011 ='" + sDTLD011 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD012 ='" + sDTLD012 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD013 ='" + sDTLD013 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD014 ='" + sDTLD014 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD015 ='" + sDTLD015 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD016 ='" + sDTLD016 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD017 ='" + sDTLD017 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD018 ='" + sDTLD018 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD019 ='" + sDTLD019 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD020 ='" + sDTLD020 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD021 ='" + sDTLD021 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD022 ='" + sDTLD022 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD023 ='" + sDTLD023 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD024 ='" + sDTLD024 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD025 ='" + sDTLD025 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD026 ='" + sDTLD026 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD027 ='" + sDTLD027 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD028 ='" + sDTLD028 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD029 ='" + sDTLD029 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD030 ='" + sDTLD030 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD031 ='" + sDTLD031 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD032 ='" + sDTLD032 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD033 ='" + sDTLD033 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD034 ='" + sDTLD034 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD035 ='" + sDTLD035 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD036 ='" + sDTLD036 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD037 ='" + sDTLD037 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD038 ='" + sDTLD038 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD039 ='" + sDTLD039 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD040 ='" + sDTLD040 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD041 ='" + sDTLD041 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD042 ='" + sDTLD042 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD043 ='" + sDTLD043 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD044 ='" + sDTLD044 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD045 ='" + sDTLD045 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD046 ='" + sDTLD046 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD047 ='" + sDTLD047 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD048 ='" + sDTLD048 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD049 ='" + sDTLD049 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD050 ='" + sDTLD050 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD051 ='" + sDTLD051 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD052 ='" + sDTLD052 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD053 ='" + sDTLD053 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD054 ='" + sDTLD054 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD055 ='" + sDTLD055 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD056 ='" + sDTLD056 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD057 ='" + sDTLD057 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD058 ='" + sDTLD058 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD059 ='" + sDTLD059 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD060 ='" + sDTLD060 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD061 ='" + sDTLD061 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD062 ='" + sDTLD062 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD063 ='" + sDTLD063 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD064 ='" + sDTLD064 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD065 ='" + sDTLD065 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD066 ='" + sDTLD066 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD067 ='" + sDTLD067 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD068 ='" + sDTLD068 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD069 ='" + sDTLD069 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD070 ='" + sDTLD070 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD071 ='" + sDTLD071 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD072 ='" + sDTLD072 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD073 ='" + sDTLD073 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD074 ='" + sDTLD074 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD075 ='" + sDTLD075 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD076 ='" + sDTLD076 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD077 ='" + sDTLD077 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD078 ='" + sDTLD078 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD079 ='" + sDTLD079 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD080 ='" + sDTLD080 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD081 ='" + sDTLD081 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD082 ='" + sDTLD082 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLD083 ='" + sDTLD083 + "', ";
sEXESQLSTR = sEXESQLSTR + " saveuser = '******', ";
sEXESQLSTR = sEXESQLSTR + " savedate = getdate() ";
sEXESQLSTR = sEXESQLSTR + " Where SWC000 = '" + sSWC000 + "'";
sEXESQLSTR = sEXESQLSTR + " and DTLD000 = '" + sDTLD000 + "'";
sEXESQLUPD = sEXESQLUPD + " Update RelationSwc set ";
sEXESQLUPD = sEXESQLUPD + " Upd02 = 'Y', ";
sEXESQLUPD = sEXESQLUPD + " Savdate02 = getdate() ";
sEXESQLUPD = sEXESQLUPD + " Where Key01 = '" + sSWC000 + "'";
SqlCommand objCmdUpd = new SqlCommand(sEXESQLSTR + sEXESQLUPD, SwcConn);
objCmdUpd.ExecuteNonQuery();
objCmdUpd.Dispose();
//上傳檔案…
UpLoadTempFileMoveChk(sSWC000);
string vCaseID = Request.QueryString["SWCNO"] + "";
Response.Redirect("SWC002.aspx?CaseId=" + vCaseID);
}
}
/// <summary>
/// Initializes the provider with the property values specified in the ASP.NET application configuration file
/// </summary>
/// <param name="name">The name of the provider instance to initialize.</param>
/// <param name="config">Object that contains the names and values of configuration options for the provider.
/// </param>
public override void Initialize(string name, NameValueCollection config)
{
//Initialize values from web.config.
if (config == null)
throw new ArgumentException("config");
if (name == null || name.Length == 0)
throw new ArgumentException("name");
if (String.IsNullOrEmpty(config["description"])) {
config.Remove("description");
config["description"] = "Silversite Session State Store Provider";
}
base.Initialize(name, config);
string applicationName = HostingEnvironment.ApplicationVirtualPath;
if (!String.IsNullOrEmpty(config["applicationName"]))
applicationName = config["applicationName"];
// Get <sessionState> configuration element.
Configuration webConfig = WebConfigurationManager.OpenWebConfiguration(HostingEnvironment.ApplicationVirtualPath);
sessionStateConfig = (SessionStateSection)webConfig.SectionGroups["system.web"].Sections["sessionState"];
// Initialize connection.
var conStrName = config["connectionStringName"];
if (string.IsNullOrEmpty(conStrName)) db = Data.Database.Default;
else {
connectionStringSettings = ConfigurationManager.ConnectionStrings[config["connectionStringName"]];
db = Data.Database.Custom(connectionStringSettings.ProviderName, connectionStringSettings.ConnectionString);
}
writeExceptionsToEventLog = false;
if (config["writeExceptionsToEventLog"] != null) {
writeExceptionsToEventLog = (config["writeExceptionsToEventLog"].ToUpper() == "TRUE");
}
// Make sure we have the correct schema.
app = new Application(applicationName, base.Description);
// Get the application id.
try {
using (MySqlConnection conn = new MySqlConnection(connectionString)) {
conn.Open();
app.EnsureId(conn);
CheckStorageEngine(conn);
cleanupInterval = GetCleanupInterval(conn);
}
} catch (MySqlException e) {
HandleMySqlException(e, "Initialize");
}
// Setup the cleanup timer
if (cleanupInterval <= 0)
cleanupInterval = 1;
cleanupTimer = new Timer(new TimerCallback(CleanupOldSessions), null, 0,
cleanupInterval * 1000 * 60);
}
public DatabaseHandlerFactory(string connectionStringName)
{
connectionStringSettings = ConfigurationManager.ConnectionStrings[connectionStringName];
}
public override void Initialize(string name, NameValueCollection config)
{
if (config == null)
{
throw new ArgumentNullException("config");
}
if (string.IsNullOrEmpty(name))
{
name = "DefaultSessionStateProvider";
}
base.Initialize(name, config);
this.ConnectionString = ModelHelper.GetConnectionString(config["connectionStringName"]);
config.Remove("connectionStringName");
try
{
SessionStateSection section = (SessionStateSection)ConfigurationManager.GetSection("system.web/sessionState");
this.CompressionEnabled = section.CompressionEnabled;
}
catch (SecurityException)
{
}
if (config.Count > 0)
{
string key = config.GetKey(0);
if (!string.IsNullOrEmpty(key))
{
throw new ProviderException(string.Format(CultureInfo.CurrentCulture, ProviderResources.Provider_unrecognized_attribute, new object[] { key }));
}
}
}
//----- Cleanup objects and close connections upon deletion of EkDb object from the user.
public void Dispose()
{
if (m_sqlConn != null)
{
m_sqlConn.Close();
m_sqlConn.Dispose();
}
//if (m_oracleConn != null)
//{
// m_oracleConn.Close();
// m_oracleConn.Dispose();
//}
m_cssEkDb = null;
}
public SessionImplObject GetLayout(SessionQuery query, ConnectionStringSettings connectionStringSetting)
{
try
{
/*
* ISdmxObjects structure = GetKeyFamily();
* IDataflowObject df = structure.Dataflows.First();
* IDataStructureObject kf = structure.DataStructures.First();
*/
ISdmxObjects structure = query.Structure;
IDataflowObject df = query.Dataflow;
IDataStructureObject kf = query.KeyFamily;
if (kf == null || df == null)
{
throw new InvalidOperationException("DataStructure is not set");
}
//if (this.SessionObj.DafaultLayout == null)
this.SessionObj.DafaultLayout = new Dictionary <string, LayoutObj>();
//if (connectionStringSetting.ConnectionString!=null && connectionStringSetting.ConnectionString.ToLower() != "file")
if (connectionStringSetting.ConnectionString != null)
{
// Get automatic timeserie layout
System.Data.SqlClient.SqlConnection Sqlconn = new System.Data.SqlClient.SqlConnection(connectionStringSetting.ConnectionString);
Sqlconn.Open();
string sqlquery = string.Format("Select * from Template where [tmplKey]='{0}'",
new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(
LayObj.Dataflow.id + "+" + LayObj.Dataflow.agency + "+" + LayObj.Dataflow.version + "+" + LayObj.Configuration.EndPoint).Replace("'", "''"));
using (System.Data.SqlClient.SqlCommand comm = new System.Data.SqlClient.SqlCommand(sqlquery, Sqlconn))
{
var reader = comm.ExecuteReader();
if (reader.Read())
{
string layout = reader.GetString(reader.GetOrdinal("Layout"));
this.SessionObj.DafaultLayout[Utils.MakeKey(df)] =
(LayoutObj) new JavaScriptSerializer().Deserialize(layout, typeof(LayoutObj));
this.SessionObj.DafaultLayout[Utils.MakeKey(df)].block_axis_x = reader.GetBoolean(reader.GetOrdinal("BlockXAxe"));
this.SessionObj.DafaultLayout[Utils.MakeKey(df)].block_axis_y = reader.GetBoolean(reader.GetOrdinal("BlockYAxe"));
this.SessionObj.DafaultLayout[Utils.MakeKey(df)].block_axis_z = reader.GetBoolean(reader.GetOrdinal("BlockZAxe"));
}
}
Sqlconn.Close();
}
DefaultLayoutResponseObject defaultLayoutResponseObject = new DefaultLayoutResponseObject();
defaultLayoutResponseObject.DefaultLayout = (this.SessionObj.DafaultLayout.ContainsKey(Utils.MakeKey(df))) ? this.SessionObj.DafaultLayout[Utils.MakeKey(df)] : null;
//if (defaultLayoutResponseObject.DefaultLayout == null){ return GetLayout(); }
this.SessionObj.SavedDefaultLayout = new JavaScriptSerializer().Serialize(defaultLayoutResponseObject);
return(this.SessionObj);
}
catch (InvalidOperationException ex)
{
Logger.Warn(Resources.ErrorMaxJsonLength);
Logger.Warn(ex.Message, ex);
throw new Exception(ErrorOccured);
}
catch (ArgumentException ex)
{
Logger.Warn(Resources.ErrorRecursionLimit);
Logger.Warn(ex.Message, ex);
throw new Exception(ErrorOccured);
}
catch (Exception ex)
{
Logger.Warn(ex.Message, ex);
throw new Exception(ErrorOccured);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationConnection"];
Connection = new MySqlConnection(ConnectionString.ConnectionString);
ShowActivities();
}
/// <summary>
/// Lors d'une substitution dans une classe dérivée, exécute la tâche.
/// </summary>
/// <returns>
/// true si la tâche s'est exécutée correctement ; sinon, false.
/// </returns>
/// <exception cref="System.Exception"></exception>
public override bool Execute()
{
Log.LogMessage("Loading {0}", ConfigFile);
var fileMap = new ExeConfigurationFileMap()
{
ExeConfigFilename = ConfigFile
};
var config = ConfigurationManager.OpenMappedExeConfiguration(fileMap, System.Configuration.ConfigurationUserLevel.None);
using (AppConfig.Change(ConfigFile))
{
#region get cnx string
ConnectionStringSettings cnx = null;
foreach (ConnectionStringSettings item in config.ConnectionStrings.ConnectionStrings)
{
if (item.Name == ConnectionStringName)
{
cnx = item;
break;
}
}
if (cnx == null)
{
throw new Exception(string.Format("missing connection string name {0}", ConnectionStringName));
}
#endregion get cnx string
//string owner = ConfigurationManager.AppSettings["OWNER"];
//string package = ConfigurationManager.AppSettings["PACKAGE"];
//string proc = ConfigurationManager.AppSettings["PROCEDURE"];
//string table = ConfigurationManager.AppSettings["TABLE"];
DatabaseFiltersSection confDatabaseFilters = null;
try
{
AppDomain.CurrentDomain.AssemblyResolve += CurrentDomain_AssemblyResolve;
confDatabaseFilters = ConfigurationManager.GetSection("databaseFiltersSection") as DatabaseFiltersSection;
AppDomain.CurrentDomain.AssemblyResolve -= CurrentDomain_AssemblyResolve;
}
catch
{
//section cannot be found
}
if (confDatabaseFilters != null)
{
var ownerLists = new List <String>();
for (var i = 0; i < confDatabaseFilters.Owners.Count; i++)
{
if (!String.IsNullOrWhiteSpace(confDatabaseFilters.Owners[i].value))
{
ownerLists.Add(confDatabaseFilters.Owners[i].value);
}
}
var packageLists = new List <String>();
for (var i = 0; i < confDatabaseFilters.Packages.Count; i++)
{
if (!String.IsNullOrWhiteSpace(confDatabaseFilters.Packages[i].value))
{
packageLists.Add(confDatabaseFilters.Packages[i].value);
}
}
var procLists = new List <String>();
for (var i = 0; i < confDatabaseFilters.Procedures.Count; i++)
{
if (!String.IsNullOrWhiteSpace(confDatabaseFilters.Procedures[i].value))
{
procLists.Add(confDatabaseFilters.Procedures[i].value);
}
}
var tableLists = new List <String>();
for (var i = 0; i < confDatabaseFilters.Tables.Count; i++)
{
if (!String.IsNullOrWhiteSpace(confDatabaseFilters.Tables[i].value))
{
tableLists.Add(confDatabaseFilters.Tables[i].value);
}
}
Database.OwnerNames = ownerLists.Count <= 0 ? null : ownerLists;
/// Selection d'un seul Package
/// Selection d'un seul objet
Database.ProcedureNames = procLists.Count <= 0 ? null : procLists;
///DbQueryBase.TableName = "PARCEL";
Database.TableNames = tableLists.Count <= 0 ? null : tableLists;
}
Func <string, bool> act =
shema =>
{
return(true);
};
string file = DatabaseSchemaConfig_FileNameFullPath;
AppDomain.CurrentDomain.AssemblyResolve += CurrentDomain_AssemblyResolve;
Log.LogMessage("running with connection string name '{0}' -> '{1}'", cnx.Name, DatabaseSchemaIncludeSpecification_FileNameFullPath);
try
{
Database.GenerateFile("source", cnx.ConnectionString, file, act);
}
finally
{
AppDomain.CurrentDomain.AssemblyResolve -= CurrentDomain_AssemblyResolve;
}
Log.LogMessage("Writing {0}", @DatabaseSchemaIncludeSpecification_FileNameFullPath);
var packages = Pssa.Tools.Databases.Generators.Helpers.IncludeFileParser.GetIncludes(@DatabaseSchemaIncludeSpecification_FileNameFullPath);
}
return(true);
}
/// <summary>
/// Contructor for the DatabaseConnectionTestDetails class.
/// </summary>
/// <param name="connectionStringSettings">
/// The connectionString settings for a single database connection.
/// </param>
public DatabaseConnectionTestDetails(ConnectionStringSettings connectionStringSettings)
{
this.connectionStringSettings = connectionStringSettings;
}
public void Remove(ConnectionStringSettings settings) {}
public DbSubscriptionService(ConnectionStringSettings connectionString)
: base(connectionString, "tenant")
{
}
public int IndexOf(ConnectionStringSettings settings)
{
return Raw.IndexOf(settings);
}
private static String Conexion()
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["miconexion2"];
return(settings.ConnectionString);
}
/// <summary>
/// Initializes a new instance of the <see cref="InMemoryTokenManager"/> class.
/// </summary>
/// <param name="consumerKey">The consumer key.</param>
/// <param name="consumerSecret">The consumer secret.</param>
public DbTokenManager(string consumerKey, string consumerSecret, string dbId, ConnectionStringSettings connectionString)
{
_dbId = dbId;
if (String.IsNullOrEmpty(consumerKey))
{
throw new ArgumentNullException("consumerKey");
}
this.ConsumerKey = consumerKey;
this.ConsumerSecret = consumerSecret;
if (!DbRegistry.IsDatabaseRegistered(dbId))
{
DbRegistry.RegisterDatabase(dbId, connectionString);
}
}
private void SendMailNotice(string gSWC000, string gReview)
{
GBClass001 SBApp = new GBClass001();
string[] arrayChkUserMsg = SBApp.GetUserMailData();
string ChkUserId = arrayChkUserMsg[0] + "";
string ChkUserName = arrayChkUserMsg[1] + "";
string ChkJobTitle = arrayChkUserMsg[2] + "";
string ChkMail = arrayChkUserMsg[3] + "";
string ChkMBGROUP = arrayChkUserMsg[4] + "";
//TextBox1.Text = strUserName;
string[] arrayUserId = ChkUserId.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayUserName = ChkUserName.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayJobTitle = ChkJobTitle.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayUserMail = ChkMail.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayMBGROUP = ChkMBGROUP.Split(new string[] { ";;" }, StringSplitOptions.None);
//送出提醒名單：義務人、監造技師、檢查公會
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select SWC.SWC002,SWC.SWC005, SWC.SWC012, SWC.SWC013,SWC.SWC013TEL, SWC.SWC024, SWC.SWC045ID,U.ETName,U.ETEmail,SWC.SWC108 from SWCCASE SWC ";
strSQLRV = strSQLRV + " LEFT JOIN ETUsers U on SWC.SWC045ID = U.ETID ";
strSQLRV = strSQLRV + " where SWC.SWC000 = '" + gSWC000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC012 = readeSwc["SWC012"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013TEL = readeSwc["SWC013TEL"] + "";
string tSWC024 = readeSwc["SWC024"] + "";
string tSWC045ID = readeSwc["SWC045ID"] + "";
string tETName = readeSwc["ETName"] + "";
string tETEmail = readeSwc["ETEmail"] + "";
string tSWC108 = readeSwc["SWC108"] + "";
//寄件名單
string SentMailGroup = "";
for (int i = 1; i < arrayUserId.Length; i++)
{
string aUserId = arrayUserId[i];
string aUserName = arrayUserName[i];
string aJobTitle = arrayJobTitle[i];
string aUserMail = arrayUserMail[i];
string aMBGROUP = arrayMBGROUP[i];
if (aUserName.Trim() == tSWC024.Trim())
{
SentMailGroup = SentMailGroup + ";;" + aUserMail;
string[] arraySentMail01 = new string[] { aUserMail };
string ssMailSub01 = "您好，" + "水土保持計畫【" + tSWC002 + "】申請設施調整報備已" + gReview;
string ssMailBody01 = "您好，【" + tSWC005 + "】申請設施調整報備已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
ssMailBody01 = ssMailBody01 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody01 = ssMailBody01 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo01 = SBApp.Mail_Send(arraySentMail01, ssMailSub01, ssMailBody01);
}
}
//string[] arraySentMail01 = SentMailGroup.Split(new string[] { ";;" }, StringSplitOptions.None);
//string ssMailSub01 = "您好，" + "水土保持計畫【" + tSWC002 + "】申請設施調整報備已" + gReview;
//string ssMailBody01 = "您好，【" + tSWC005 + "】申請設施調整報備已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
//ssMailBody01 = ssMailBody01 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
//ssMailBody01 = ssMailBody01 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
//bool MailTo01 = SBApp.Mail_Send(arraySentMail01, ssMailSub01, ssMailBody01);
string[] arraySentMail02a = new string[] { tETEmail };
string[] arraySentMail02b = new string[] { tSWC108 };
string ssMailSub02 = "您好，" + "水土保持計畫【" + tSWC002 + "】申請設施調整報備已" + gReview;
string ssMailBody02 = "您好，【" + tSWC005 + "】申請設施調整報備已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
ssMailBody02 = ssMailBody02 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody02 = ssMailBody02 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo02a = SBApp.Mail_Send(arraySentMail02a, ssMailSub02, ssMailBody02);
bool MailTo02b = SBApp.Mail_Send(arraySentMail02b, ssMailSub02, ssMailBody02);
}
readeSwc.Close();
objCmdSwc.Dispose();
}
}
private void GenOnlineApply(string v)
{
GBClass001 SBApp = new GBClass001();
string ssUserType = Session["UserType"] + "";
string v2 = LBSWC002.Text + "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
//表2
using (SqlConnection OLAConn = new SqlConnection(connectionString.ConnectionString))
{
OLAConn.Open();
string Sql201Str = "";
Sql201Str = Sql201Str + " select ONA01001 as DATA01 ,left(convert(char, ONA01002, 120),10) as DATA02,left(convert(char, ONA01003, 120),10) as DATA03,ONA01004 as DATA04,DATALOCK as DATA05,replace(replace(isnull(DATALOCK,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply01 ";
Sql201Str = Sql201Str + " Where SWC002 = '" + v2 + "' ";
Sql201Str = Sql201Str + " order by ONA01001 ";
string Sql202Str = "";
Sql202Str = Sql202Str + " select ONA02001 as DATA01 ,left(convert(char, ONA02002, 120),10) as DATA02,left(convert(char, ONA02003, 120),10) as DATA03,ONA02004 as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply02 ";
Sql202Str = Sql202Str + " Where SWC000 = '" + v + "' ";
Sql202Str = Sql202Str + " order by ONA02001 ";
string Sql203Str = "";
Sql203Str = Sql203Str + " select ONA03001 as DATA01 ,left(convert(char, ONA03002, 120),10) as DATA02,left(convert(char, ONA03003, 120),10) as DATA03,'第'+ONA03004+'次展延' as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply03 ";
Sql203Str = Sql203Str + " Where SWC000 = '" + v + "' ";
Sql203Str = Sql203Str + " order by ONA03001 ";
string Sql204Str = "";
Sql204Str = Sql204Str + " select ONA04001 as DATA01 ,left(convert(char, ONA04003, 120),10) as DATA02,left(convert(char, ONA04004, 120),10) as DATA03,'' as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply04 ";
Sql204Str = Sql204Str + " Where SWC000 = '" + v + "' ";
Sql204Str = Sql204Str + " order by ONA04001 ";
string Sql205Str = "";
Sql205Str = Sql205Str + " select ONA05001 as DATA01 ,ONA05002 as DATA02,ONA05003 as DATA03,ONA05004 as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply05 ";
Sql205Str = Sql205Str + " Where SWC000 = '" + v + "' ";
Sql205Str = Sql205Str + " order by ONA05001 ";
string Sql206Str = "";
Sql206Str = Sql206Str + " select ONA06001 as DATA01 ,left(convert(char, ONA06002, 120),10) as DATA02,ET.ETName as DATA03,ONA06004 as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply06 ONA6 ";
Sql206Str = Sql206Str + " LEFT JOIN ETUsers ET ON ONA6.ONA06015=et.etid ";
Sql206Str = Sql206Str + " Where SWC000 = '" + v + "' ";
Sql206Str = Sql206Str + " order by ONA06001 ";
string Sql207Str = "";
Sql207Str = Sql207Str + " select ONA07001 as DATA01 ,left(convert(char, ONA07002, 120),10) as DATA02,left(convert(char, ONA07003, 120),10) as DATA03,left(convert(char, ONA07004, 120),10) as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply07 ";
Sql207Str = Sql207Str + " Where SWC000 = '" + v + "' ";
Sql207Str = Sql207Str + " order by ONA07001 ";
string Sql208Str = "";
Sql208Str = Sql208Str + " select ONA08001 as DATA01 ,left(convert(char, ONA08002, 120),10) as DATA02,left(convert(char, ONA08003, 120),10) as DATA03,left(convert(char, ONA08004, 120),10) as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply08 ";
Sql208Str = Sql208Str + " Where SWC000 = '" + v + "' ";
Sql208Str = Sql208Str + " order by ONA08001 ";
string Sql209Str = "";
Sql209Str = Sql209Str + " select ONA09001 as DATA01 ,left(convert(char, ONA09002, 120),10) as DATA02,ET.ETName as DATA03,ONA09004 as DATA04,DATALOCK as DATA05,replace(replace(isnull(ReviewResults,''),1,'核准'),'0','駁回') AS DATA06 from OnlineApply09 ONA9 ";
Sql209Str = Sql209Str + " LEFT JOIN ETUsers ET ON ONA9.saveuser=et.etid ";
Sql209Str = Sql209Str + " Where SWC000 = '" + v + "' ";
Sql209Str = Sql209Str + " order by ONA09001 ";
string[] arraySqlExeStr = new string[] { Sql201Str, Sql202Str, Sql203Str, Sql204Str, Sql205Str, Sql206Str, Sql207Str, Sql208Str, Sql209Str };
GridView[] arrayONLAGV = new GridView[] { SWCOLA201, SWCOLA202, SWCOLA203, SWCOLA204, SWCOLA205, SWCOLA206, SWCOLA207, SWCOLA208, SWCOLA209 };
for (int i = 0; i < arraySqlExeStr.Length; i++)
{
string aSqlStr = arraySqlExeStr[i] + "";
GridView SWCONLA = arrayONLAGV[i];
if (aSqlStr.Trim() == "")
{
}
else
{
SqlDataReader readerItem;
SqlCommand objCmdItem = new SqlCommand(aSqlStr, OLAConn);
readerItem = objCmdItem.ExecuteReader();
while (readerItem.Read())
{
string dONA001 = readerItem["DATA01"] + "";
string dONA002 = readerItem["DATA02"] + "";
string dONA003 = readerItem["DATA03"] + "";
string dONA004 = readerItem["DATA04"] + "";
string dONA005 = readerItem["DATA05"] + "";
string dONA006 = readerItem["DATA06"] + "";
if (ssUserType == "01" || ssUserType == "02" || dONA005 == "Y")
{
DataTable OBJ_OLAGV = (DataTable)ViewState["OLAGV" + i.ToString().PadLeft(2, '0')];
if (OBJ_OLAGV == null)
{
DataTable OLAGV = new DataTable();
OLAGV.Columns.Add(new DataColumn("OLA001", typeof(string)));
OLAGV.Columns.Add(new DataColumn("OLA002", typeof(string)));
OLAGV.Columns.Add(new DataColumn("OLA003", typeof(string)));
OLAGV.Columns.Add(new DataColumn("OLA004", typeof(string)));
OLAGV.Columns.Add(new DataColumn("OLA005", typeof(string)));
OLAGV.Columns.Add(new DataColumn("OLA006", typeof(string)));
ViewState["OLAGV" + i.ToString().PadLeft(2, '0')] = OLAGV;
OBJ_OLAGV = OLAGV;
}
DataRow dr = OBJ_OLAGV.NewRow();
dr["OLA001"] = dONA001;
dr["OLA002"] = dONA002;
dr["OLA003"] = dONA003;
dr["OLA004"] = dONA004;
dr["OLA005"] = dONA005;
dr["OLA006"] = dONA006;
OBJ_OLAGV.Rows.Add(dr);
ViewState["OLAGV" + i.ToString().PadLeft(2, '0')] = OBJ_OLAGV;
SWCONLA.DataSource = OBJ_OLAGV;
SWCONLA.DataBind();
}
}
readerItem.Close();
objCmdItem.Dispose();
}
}
}
}
private void SetSwcCase(string v)
{
string ssUserType = Session["UserType"] + "";
string SWC002 = "";
GBClass001 SBApp = new GBClass001();
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
SBApp.SWCRecord("SWC003", v, strSQLRV);
while (readeSwc.Read())
{
string qSWC000 = readeSwc["SWC000"] + "";
string qSWC002 = readeSwc["SWC002"] + "";
string qSWC004 = readeSwc["SWC004"] + "";
string qSWC005 = readeSwc["SWC005"] + "";
string qSWC007 = readeSwc["SWC007"] + "";
string qSWC013 = readeSwc["SWC013"] + "";
string qSWC013ID = readeSwc["SWC013ID"] + "";
string qSWC013TEL = readeSwc["SWC013TEL"] + "";
string qSWC014 = readeSwc["SWC014"] + "";
string qSWC015 = readeSwc["SWC015"] + "";
string qSWC016 = readeSwc["SWC016"] + "";
string qSWC017 = readeSwc["SWC017"] + "";
string qSWC018 = readeSwc["SWC018"] + "";
string qSWC021 = readeSwc["SWC021"] + "";
string qSWC021ID = readeSwc["SWC021ID"] + "";
string qSWC022 = readeSwc["SWC022"] + "";
string qSWC022ID = readeSwc["SWC022ID"] + "";
string qSWC023 = readeSwc["SWC023"] + "";
string qSWC024 = readeSwc["SWC024"] + "";
string qSWC024ID = readeSwc["SWC024ID"] + "";
string qSWC025 = readeSwc["SWC025"] + "";
string qSWC027 = readeSwc["SWC027"] + "";
string qSWC028 = readeSwc["SWC028"] + "";
string qSWC029 = readeSwc["SWC029"] + "";
string qSWC029CAD = readeSwc["SWC029CAD"] + "";
string qSWC030 = readeSwc["SWC030"] + "";
string qSWC031 = readeSwc["SWC031"] + "";
string qSWC032 = readeSwc["SWC032"] + "";
string qSWC033 = readeSwc["SWC033"] + "";
string qSWC034 = readeSwc["SWC034"] + "";
string qSWC035 = readeSwc["SWC035"] + "";
string qSWC036 = readeSwc["SWC036"] + "";
string qSWC038 = readeSwc["SWC038"] + "";
string qSWC039 = readeSwc["SWC039"] + "";
string qSWC040 = readeSwc["SWC040"] + "";
string qSWC041 = readeSwc["SWC041"] + "";
string qSWC043 = readeSwc["SWC043"] + "";
string qSWC044 = readeSwc["SWC044"] + "";
string qSWC045 = readeSwc["SWC045"] + "";
string qSWC045ID = readeSwc["SWC045ID"] + "";
string qSWC047 = readeSwc["SWC047"] + "";
string qSWC048 = readeSwc["SWC048"] + "";
string qSWC049 = readeSwc["SWC049"] + "";
string qSWC050 = readeSwc["SWC050"] + "";
string qSWC051 = readeSwc["SWC051"] + "";
string qSWC052 = readeSwc["SWC052"] + "";
string qSWC053 = readeSwc["SWC053"] + "";
string qSWC056 = readeSwc["SWC056"] + "";
string qSWC058 = readeSwc["SWC058"] + "";
string qSWC059 = readeSwc["SWC059"] + "";
string qSWC061 = readeSwc["SWC061"] + "";
string qSWC062 = readeSwc["SWC062"] + "";
string qSWC063 = readeSwc["SWC063"] + "";
string qSWC064 = readeSwc["SWC064"] + "";
string qSWC065 = readeSwc["SWC065"] + "";
string qSWC066 = readeSwc["SWC066"] + "";
string qSWC067 = readeSwc["SWC067"] + "";
string qSWC068 = readeSwc["SWC068"] + "";
string qSWC069 = readeSwc["SWC069"] + "";
string qSWC070 = readeSwc["SWC070"] + "";
string qSWC071 = readeSwc["SWC071"] + "";
string qSWC072 = readeSwc["SWC072"] + "";
string qSWC073 = readeSwc["SWC073"] + "";
string qSWC074 = readeSwc["SWC074"] + "";
string qSWC075 = readeSwc["SWC075"] + "";
string qSWC080 = readeSwc["SWC080"] + "";
string qSWC082 = readeSwc["SWC082"] + "";
string qSWC083 = readeSwc["SWC083"] + "";
string qSWC084 = readeSwc["SWC084"] + "";
string qSWC087 = readeSwc["SWC087"] + "";
string qSWC088 = readeSwc["SWC088"] + "";
string qSWC089 = readeSwc["SWC089"] + "";
string qSWC092 = readeSwc["SWC092"] + "";
string qSWC093 = readeSwc["SWC093"] + "";
string qSWC094 = readeSwc["SWC094"] + "";
string qSWC095 = readeSwc["SWC095"] + "";
string qSWC101 = readeSwc["SWC101"] + "";
string qSWC101CAD = readeSwc["SWC101CAD"] + "";
string qSWC103 = readeSwc["SWC103"] + "";
string qSWC104 = readeSwc["SWC104"] + "";
string qSWC105 = readeSwc["SWC105"] + "";
string qSWC106 = readeSwc["SWC106"] + "";
string qSWC107 = readeSwc["SWC107"] + "";
string qSWC107ID = readeSwc["SWC107ID"] + "";
string qSWC108 = readeSwc["SWC108"] + "";
string qSWC109 = readeSwc["SWC109"] + "";
string qSWC110 = readeSwc["SWC110"] + "";
qSWC031 = SBApp.DateView(qSWC031, "00");
qSWC032 = SBApp.DateView(qSWC032, "00");
qSWC033 = SBApp.DateView(qSWC033, "00");
qSWC034 = SBApp.DateView(qSWC034, "00");
qSWC038 = SBApp.DateView(qSWC038, "00");
qSWC043 = SBApp.DateView(qSWC043, "00");
qSWC051 = SBApp.DateView(qSWC051, "00");
qSWC052 = SBApp.DateView(qSWC052, "00");
qSWC082 = SBApp.DateView(qSWC082, "00");
qSWC110 = SBApp.DateView(qSWC110, "00");
//丟資料
LBSWC000.Text = qSWC000;
LBSWC002.Text = qSWC002;
LBSWC004.Text = qSWC004;
LBSWC005.Text = qSWC005;
}
}
//GVSWCCHG
using (SqlConnection ItemConn = new SqlConnection(connectionString.ConnectionString))
{
ItemConn.Open();
string strSQLRV = "select * from SWCCASE";
strSQLRV = strSQLRV + " Where LEFT(SWC002,12) = '" + LBSWC002.Text.Substring(0, 12) + "' ";
strSQLRV = strSQLRV + " and SWC002 <> '" + LBSWC002.Text + "' ";
strSQLRV = strSQLRV + " order by SWC002 ";
SqlDataReader readerItem;
SqlCommand objCmdItem = new SqlCommand(strSQLRV, ItemConn);
readerItem = objCmdItem.ExecuteReader();
while (readerItem.Read())
{
string dSWC000 = readerItem["SWC000"] + "";
string dSWC002 = readerItem["SWC002"] + "";
DataTable tbSWCCHK = (DataTable)ViewState["SWCCHK"];
if (tbSWCCHK == null)
{
DataTable GVTBSWCDHK = new DataTable();
GVTBSWCDHK.Columns.Add(new DataColumn("SWC002", typeof(string)));
GVTBSWCDHK.Columns.Add(new DataColumn("SWC002Link", typeof(string)));
ViewState["SWCCHK"] = GVTBSWCDHK;
tbSWCCHK = (DataTable)ViewState["SWCCHK"];
}
DataRow GVTBSWCDHKRow = tbSWCCHK.NewRow();
GVTBSWCDHKRow["SWC002"] = dSWC002;
GVTBSWCDHKRow["SWC002Link"] = "SWC004.aspx?SWCNO=" + dSWC000;
tbSWCCHK.Rows.Add(GVTBSWCDHKRow);
//Store the DataTable in ViewState
ViewState["SWCCHK"] = tbSWCCHK;
GVSWCCHG.DataSource = tbSWCCHK;
GVSWCCHG.DataBind();
}
readerItem.Close();
}
//2018-新增子表單
GenOnlineApply(v);
}
/// <summary>
/// Returns one connection string info.
/// </summary>
/// <param name="connStr">Connection string name</param>
private string GetConnStr(ConnectionStringSettings connStr)
{
string setting = "<add name=\"" + connStr.Name + "\" connectionString=\"" + connStr.ConnectionString + "\" />";
return HTMLHelper.HTMLEncode(setting);
}
public BaseUow(ConnectionStringSettings connectionStrings)
{
_connectionStrings = connectionStrings;
}
public FinancialAccountRepository(ConnectionStringSettings connectionString)
{
this.connectionString = connectionString;
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
System.Threading.Thread splashThread = new System.Threading.Thread(new System.Threading.ThreadStart(() =>
{
splashScreen = new FormSplashFOCA(ProgramVersion);
Application.Run(splashScreen);
Application.ExitThread();
}));
splashThread.SetApartmentState(System.Threading.ApartmentState.STA);
splashThread.Start();
Application.DoEvents();
//Load the FOCA
Running = true;
SqlConnectionStringBuilder connectionStringBuilder = null;
bool csUpdated = false;
try
{
ConnectionStringSettings csFromConfig = ConfigurationManager.ConnectionStrings[nameof(FocaContextDb)];
//If there is no connection string configured, try with SQLEXPRESS instance
if (csFromConfig == null || String.IsNullOrEmpty(csFromConfig.ConnectionString))
{
connectionStringBuilder = new SqlConnectionStringBuilder(SQLExpressConnectionString);
csUpdated = true;
}
else
{
connectionStringBuilder = new SqlConnectionStringBuilder(csFromConfig.ConnectionString);
if (String.IsNullOrWhiteSpace(connectionStringBuilder.InitialCatalog))
{
connectionStringBuilder.InitialCatalog = FocaDatabaseName;
}
}
}
catch (ArgumentException)
{
csUpdated = true;
connectionStringBuilder = new SqlConnectionStringBuilder(SQLExpressConnectionString);
}
while (!FocaContextDb.IsDatabaseAvailable(connectionStringBuilder.ToString()))
{
splashScreen.Invoke((MethodInvoker)(() => MessageBox.Show(splashScreen, "FOCA needs a SQL database. Please setup your connection and try again.", "Database not found", MessageBoxButtons.OK, MessageBoxIcon.Error)));
// Display the connection dialog
using (DataConnectionDialog dlg = new DataConnectionDialog(connectionStringBuilder))
{
DialogResult connectionResult = DialogResult.Cancel;
splashScreen.Invoke((MethodInvoker)(() => connectionResult = dlg.ShowDialog(splashScreen)));
if (DialogResult.OK != connectionResult)
{
Environment.Exit(0);
}
}
csUpdated = true;
}
if (csUpdated)
{
UpdateConnectionString(connectionStringBuilder.ToString());
}
data = new Data();
FormMainInstance = new FormMain();
FormMainInstance.TopMost = true;
FormMainInstance.Shown += FormMainInstance_Shown;
FormOptionsInstance = new FormOptions();
InitializeServicePointManager();
Application.Run(FormMainInstance);
}
protected DbBaseService(ConnectionStringSettings connectionString, string tenantColumn)
{
dbid = connectionString.Name;
TenantColumn = tenantColumn;
}
/// <summary>
/// Create the configuration section
/// </summary>
/// <param name="parent"></param>
/// <param name="configContext"></param>
/// <param name="section"></param>
/// <returns></returns>
public object Create(object parent, object configContext, System.Xml.XmlNode section)
{
XmlNode connectionManagerConfig = section.SelectSingleNode("./*[local-name() = 'connectionManager']"),
validationConfig = section.SelectSingleNode("./*[local-name() = 'validation']"),
matchConfig = section.SelectSingleNode("./*[local-name() = 'nameMatching']");
if (connectionManagerConfig == null)
{
throw new ConfigurationErrorsException("connectionManager must be specified", section);
}
// Setup default validation section
this.Validation = new ValidationSection()
{
AllowDuplicateRecords = false,
DefaultMatchAlgorithms = 0,
DefaultMatchStrength = Core.ComponentModel.MatchStrength.Exact
};
// Connection manager settings
string connectionString = String.Empty, roConnectionString = connectionString;
DbProviderFactory provider = null;
// Validation config
if (validationConfig != null)
{
// Validation Configuration
if (validationConfig.Attributes["allowDuplicates"] != null)
{
this.Validation.AllowDuplicateRecords = Boolean.Parse(validationConfig.Attributes["allowDuplicates"].Value);
}
if (validationConfig.Attributes["personMustExist"] != null)
{
this.Validation.PersonsMustExist = Boolean.Parse(validationConfig.Attributes["personMustExist"].Value);
}
if (validationConfig.Attributes["validateProvidersAgainstPR"] != null)
{
this.Validation.ValidateHealthcareParticipants = Boolean.Parse(validationConfig.Attributes["validateProvidersAgainstPR"].Value);
}
if (validationConfig.Attributes["minPersonNameMatch"] != null)
{
this.Validation.PersonNameMatch = (float)Double.Parse(validationConfig.Attributes["minPersonNameMatch"].Value);
}
}
// Match config
if (matchConfig != null)
{
if (matchConfig.Attributes["defaultMatchStr"] != null)
{
this.Validation.DefaultMatchStrength = (MatchStrength)Enum.Parse(typeof(MatchStrength), matchConfig.Attributes["defaultMatchStr"].Value);
}
if (matchConfig.Attributes["seekExactMatchFirst"] != null)
{
this.Validation.ExactMatchFirst = bool.Parse(matchConfig.Attributes["seekExactMatchFirst"].Value);
}
foreach (var nd in matchConfig.ChildNodes)
{
if (nd is XmlElement && (nd as XmlElement).Name == "algorithm" && (nd as XmlElement).Attributes["name"] != null)
{
Validation.DefaultMatchAlgorithms |= (MatchAlgorithm)Enum.Parse(typeof(MatchAlgorithm), (nd as XmlElement).Attributes["name"].Value);
}
}
if (Validation.DefaultMatchAlgorithms == 0)
{
Validation.DefaultMatchAlgorithms = MatchAlgorithm.Default;
}
Trace.TraceInformation("Match algorithms {0} and strength of {1}", Validation.DefaultMatchAlgorithms, Validation.DefaultMatchStrength);
}
// Connection manager configuration
if (connectionManagerConfig.Attributes["connection"] != null)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[connectionManagerConfig.Attributes["connection"].Value];
if (settings == null)
{
throw new ConfigurationErrorsException(String.Format("Cannot find the connection string '{0}'", connectionManagerConfig.Attributes["connection"].Value), connectionManagerConfig);
}
// Create the dbProvider and cstring
connectionString = settings.ConnectionString;
// get the type
provider = DbProviderFactories.GetFactory(settings.ProviderName);
if (provider == null)
{
throw new ConfigurationErrorsException(String.Format("Can't find provider type '{0}'", settings.ProviderName), connectionManagerConfig);
}
}
else
{
Trace.TraceError("Cannot determine the connection string settings");
throw new ConfigurationErrorsException("Cannot determine the connection string to use", connectionManagerConfig);
}
// Connection manager configuration
if (connectionManagerConfig.Attributes["readOnlyConnection"] != null)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[connectionManagerConfig.Attributes["readOnlyConnection"].Value];
if (settings == null)
{
throw new ConfigurationErrorsException(String.Format("Cannot find the connection string '{0}'", connectionManagerConfig.Attributes["readOnlyConnection"].Value), connectionManagerConfig);
}
// Create the dbProvider and cstring
roConnectionString = settings.ConnectionString;
}
if (connectionManagerConfig.Attributes["overrideProcessingID"] != null)
{
this.OverridePersistenceMode = connectionManagerConfig.Attributes["overrideProcessingID"].Value == "P" ? DataPersistenceMode.Production : DataPersistenceMode.Debugging;
}
// Create the manager
this.ConnectionManager = new ConnectionManager(
connectionString, provider
);
if (!String.IsNullOrEmpty(roConnectionString))
{
this.ReadonlyConnectionManager = new ConnectionManager(
roConnectionString, provider);
}
else
{
this.ReadonlyConnectionManager = this.ConnectionManager;
}
return(this);
}
public MigrationsWrapper(Assembly migrationsAssembly, ConnectionStringSettings connectionString)
{
this.migrationsAssembly = migrationsAssembly;
this.connectionString = connectionString;
}
private void Data2Page(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string nIDA = GetDTLAID(v);
LBDTL001.Text = nIDA;
}
else
{
string strSQLRV2 = " select * from SWCDTL04 ";
strSQLRV2 = strSQLRV2 + " where DTLD000 = '" + v2 + "' ";
SqlDataReader readeDTL;
SqlCommand objCmdDTL = new SqlCommand(strSQLRV2, SwcConn);
readeDTL = objCmdDTL.ExecuteReader();
while (readeDTL.Read())
{
string tDTLD001 = readeDTL["DTLD001"] + "";
string tDTLD002 = readeDTL["DTLD002"] + "";
string tDTLD003 = readeDTL["DTLD003"] + "";
string tDTLD004 = readeDTL["DTLD004"] + "";
string tDTLD005 = readeDTL["DTLD005"] + "";
string tDTLD006 = readeDTL["DTLD006"] + "";
string tDTLD007 = readeDTL["DTLD007"] + "";
string tDTLD008 = readeDTL["DTLD008"] + "";
string tDTLD009 = readeDTL["DTLD009"] + "";
string tDTLD010 = readeDTL["DTLD010"] + "";
string tDTLD011 = readeDTL["DTLD011"] + "";
string tDTLD012 = readeDTL["DTLD012"] + "";
string tDTLD013 = readeDTL["DTLD013"] + "";
string tDTLD014 = readeDTL["DTLD014"] + "";
string tDTLD015 = readeDTL["DTLD015"] + "";
string tDTLD016 = readeDTL["DTLD016"] + "";
string tDTLD017 = readeDTL["DTLD017"] + "";
string tDTLD018 = readeDTL["DTLD018"] + "";
string tDTLD019 = readeDTL["DTLD019"] + "";
string tDTLD020 = readeDTL["DTLD020"] + "";
string tDTLD021 = readeDTL["DTLD021"] + "";
string tDTLD022 = readeDTL["DTLD022"] + "";
string tDTLD023 = readeDTL["DTLD023"] + "";
string tDTLD024 = readeDTL["DTLD024"] + "";
string tDTLD025 = readeDTL["DTLD025"] + "";
string tDTLD026 = readeDTL["DTLD026"] + "";
string tDTLD027 = readeDTL["DTLD027"] + "";
string tDTLD028 = readeDTL["DTLD028"] + "";
string tDTLD029 = readeDTL["DTLD029"] + "";
string tDTLD030 = readeDTL["DTLD030"] + "";
string tDTLD031 = readeDTL["DTLD031"] + "";
string tDTLD032 = readeDTL["DTLD032"] + "";
string tDTLD033 = readeDTL["DTLD033"] + "";
string tDTLD034 = readeDTL["DTLD034"] + "";
string tDTLD035 = readeDTL["DTLD035"] + "";
string tDTLD036 = readeDTL["DTLD036"] + "";
string tDTLD037 = readeDTL["DTLD037"] + "";
string tDTLD038 = readeDTL["DTLD038"] + "";
string tDTLD039 = readeDTL["DTLD039"] + "";
string tDTLD040 = readeDTL["DTLD040"] + "";
string tDTLD041 = readeDTL["DTLD041"] + "";
string tDTLD042 = readeDTL["DTLD042"] + "";
string tDTLD043 = readeDTL["DTLD043"] + "";
string tDTLD044 = readeDTL["DTLD044"] + "";
string tDTLD045 = readeDTL["DTLD045"] + "";
string tDTLD046 = readeDTL["DTLD046"] + "";
string tDTLD047 = readeDTL["DTLD047"] + "";
string tDTLD048 = readeDTL["DTLD048"] + "";
string tDTLD049 = readeDTL["DTLD049"] + "";
string tDTLD050 = readeDTL["DTLD050"] + "";
string tDTLD051 = readeDTL["DTLD051"] + "";
string tDTLD052 = readeDTL["DTLD052"] + "";
string tDTLD053 = readeDTL["DTLD053"] + "";
string tDTLD054 = readeDTL["DTLD054"] + "";
string tDTLD055 = readeDTL["DTLD055"] + "";
string tDTLD056 = readeDTL["DTLD056"] + "";
string tDTLD057 = readeDTL["DTLD057"] + "";
string tDTLD058 = readeDTL["DTLD058"] + "";
string tDTLD059 = readeDTL["DTLD059"] + "";
string tDTLD060 = readeDTL["DTLD060"] + "";
string tDTLD061 = readeDTL["DTLD061"] + "";
string tDTLD062 = readeDTL["DTLD062"] + "";
string tDTLD063 = readeDTL["DTLD063"] + "";
string tDTLD064 = readeDTL["DTLD064"] + "";
string tDTLD065 = readeDTL["DTLD065"] + "";
string tDTLD066 = readeDTL["DTLD066"] + "";
string tDTLD067 = readeDTL["DTLD067"] + "";
string tDTLD068 = readeDTL["DTLD068"] + "";
string tDTLD069 = readeDTL["DTLD069"] + "";
string tDTLD070 = readeDTL["DTLD070"] + "";
string tDTLD071 = readeDTL["DTLD071"] + "";
string tDTLD072 = readeDTL["DTLD072"] + "";
string tDTLD073 = readeDTL["DTLD073"] + "";
string tDTLD074 = readeDTL["DTLD074"] + "";
string tDTLD075 = readeDTL["DTLD075"] + "";
string tDTLD076 = readeDTL["DTLD076"] + "";
string tDTLD077 = readeDTL["DTLD077"] + "";
string tDTLD078 = readeDTL["DTLD078"] + "";
string tDTLD079 = readeDTL["DTLD079"] + "";
string tDTLD080 = readeDTL["DTLD080"] + "";
string tDTLD081 = readeDTL["DTLD081"] + "";
string tDTLD082 = readeDTL["DTLD082"] + "";
string tDTLD083 = readeDTL["DTLD083"] + "";
LBSWC000.Text = v;
LBDTL001.Text = tDTLD001;
TXTDTL002.Text = SBApp.DateView(tDTLD002, "00");
TXTDTL003.Text = tDTLD003;
TXTDTL004.Text = tDTLD004;
if (tDTLD005 == "1")
{
CHKDTL005.Checked = true;
}
DDLDTL006.SelectedValue = tDTLD006;
TXTDTL007.Text = tDTLD007;
TXTDTL008.Text = tDTLD008;
if (tDTLD009 == "1")
{
CHKDTL009.Checked = true;
}
DDLDTL010.SelectedValue = tDTLD010;
TXTDTL011.Text = tDTLD011;
TXTDTL012.Text = tDTLD012;
if (tDTLD013 == "1")
{
CHKDTL013.Checked = true;
}
DDLDTL014.SelectedValue = tDTLD014;
TXTDTL015.Text = tDTLD015;
TXTDTL016.Text = tDTLD016;
if (tDTLD017 == "1")
{
CHKDTL017.Checked = true;
}
DDLDTL018.SelectedValue = tDTLD018;
TXTDTL019.Text = tDTLD019;
TXTDTL020.Text = tDTLD020;
if (tDTLD021 == "1")
{
CHKDTL021.Checked = true;
}
DDLDTL022.SelectedValue = tDTLD022;
TXTDTL023.Text = tDTLD023;
TXTDTL024.Text = tDTLD024;
if (tDTLD025 == "1")
{
CHKDTL025.Checked = true;
}
DDLDTL026.SelectedValue = tDTLD026;
TXTDTL027.Text = tDTLD027;
TXTDTL028.Text = tDTLD028;
if (tDTLD029 == "1")
{
CHKDTL029.Checked = true;
}
DDLDTL030.SelectedValue = tDTLD030;
TXTDTL031.Text = tDTLD031;
TXTDTL032.Text = tDTLD032;
if (tDTLD033 == "1")
{
CHKDTL033.Checked = true;
}
DDLDTL034.SelectedValue = tDTLD034;
TXTDTL035.Text = tDTLD035;
TXTDTL036.Text = tDTLD036;
if (tDTLD037 == "1")
{
CHKDTL037.Checked = true;
}
DDLDTL038.SelectedValue = tDTLD038;
TXTDTL039.Text = tDTLD039;
TXTDTL040.Text = tDTLD040;
if (tDTLD041 == "1")
{
CHKDTL041.Checked = true;
}
DDLDTL042.SelectedValue = tDTLD042;
TXTDTL043.Text = tDTLD043;
TXTDTL044.Text = tDTLD044;
if (tDTLD045 == "1")
{
CHKDTL045.Checked = true;
}
DDLDTL046.SelectedValue = tDTLD046;
TXTDTL047.Text = tDTLD047;
TXTDTL048.Text = tDTLD048;
if (tDTLD049 == "1")
{
CHKDTL049.Checked = true;
}
DDLDTL050.SelectedValue = tDTLD050;
TXTDTL051.Text = tDTLD051;
TXTDTL052.Text = tDTLD052;
if (tDTLD053 == "1")
{
CHKDTL053.Checked = true;
}
DDLDTL054.SelectedValue = tDTLD054;
TXTDTL055.Text = tDTLD055;
TXTDTL056.Text = tDTLD056;
if (tDTLD057 == "1")
{
CHKDTL057.Checked = true;
}
DDLDTL058.SelectedValue = tDTLD058;
TXTDTL059.Text = tDTLD059;
TXTDTL060.Text = tDTLD060;
if (tDTLD061 == "1")
{
CHKDTL061.Checked = true;
}
DDLDTL062.SelectedValue = tDTLD062;
TXTDTL063.Text = tDTLD063;
TXTDTL064.Text = tDTLD064;
if (tDTLD065 == "1")
{
CHKDTL065.Checked = true;
}
DDLDTL066.SelectedValue = tDTLD066;
TXTDTL067.Text = tDTLD067;
TXTDTL068.Text = tDTLD068;
if (tDTLD069 == "1")
{
CHKDTL069.Checked = true;
}
DDLDTL070.SelectedValue = tDTLD070;
TXTDTL071.Text = tDTLD071;
TXTDTL072.Text = tDTLD072;
if (tDTLD073 == "1")
{
CHKDTL073.Checked = true;
}
DDLDTL074.SelectedValue = tDTLD074;
TXTDTL075.Text = tDTLD075;
TXTDTL076.Text = tDTLD076;
TXTDTL077.Text = tDTLD077;
TXTDTL078.Text = SBApp.DateView(tDTLD078, "00");
TXTDTL079.Text = tDTLD079.Replace("\r\n", "<br/>").Replace("\n\r", "<br/>");
TXTDTL080.Text = tDTLD080;
TXTDTL081.Text = tDTLD081;
TXTDTL082.Text = tDTLD082;
TXTDTL083.Text = tDTLD083;
//圖片類處理
string[] arrayFileName = new string[] { tDTLD080, tDTLD082 };
System.Web.UI.WebControls.Image[] arrayImgAppobj = new System.Web.UI.WebControls.Image[] { TXTDTL080_img, TXTDTL082_img };
for (int i = 0; i < arrayFileName.Length; i++)
{
string strFileName = arrayFileName[i];
System.Web.UI.WebControls.Image ImgFileObj = arrayImgAppobj[i];
if (strFileName == "")
{
}
else
{
string tempImgPateh = SwcUpLoadFilePath + v + "/" + strFileName;
ImgFileObj.Attributes.Add("src", tempImgPateh + "?ts=" + DateTime.Now.Millisecond);
}
}
}
}
}
}
// Définit la chaîne de connexion grâce à la méthode SetchaineConnexionde la DAL
public static void SetchaineConnexion(ConnectionStringSettings chset)
{
string chaine = chset.ConnectionString;
ConnexionBD.GetConnexionBD().SetchaineConnexion(chaine);
}
/// <summary>
/// Initializes a new instance of the <see cref="OutputCommandOperation"/> class.
/// </summary>
/// <param name="connectionStringSettings">Connection string settings to use.</param>
public OutputCommandOperation(ConnectionStringSettings connectionStringSettings)
: base(connectionStringSettings)
{
}
/// <summary>
/// Resolves the connection string from the ConnectionString, ConnectionStringName, or AppSettingsKey
/// property.
/// </summary>
/// <remarks>
/// ConnectiongStringName is only supported on .NET 2.0 and higher.
/// </remarks>
/// <param name="connectionStringContext">Additional information describing the connection string.</param>
/// <returns>A connection string used to connect to the database.</returns>
virtual protected string ResolveConnectionString(out string connectionStringContext)
{
if (ConnectionString != null && ConnectionString.Length > 0)
{
connectionStringContext = "ConnectionString";
return(ConnectionString);
}
#if NET_2_0
if (!String.IsNullOrEmpty(ConnectionStringName))
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[ConnectionStringName];
if (settings != null)
{
connectionStringContext = "ConnectionStringName";
return(settings.ConnectionString);
}
else
{
throw new LogException("Unable to find [" + ConnectionStringName + "] ConfigurationManager.ConnectionStrings item");
}
}
#endif
#if NETSTANDARD
if (!string.IsNullOrWhiteSpace(ConnectionStringFile))
{
var connectionStringFile = string.Format(ConnectionStringFile, Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") ?? Environment.GetEnvironmentVariable("DOTNET_ENVIRONMENT") ?? Environment.GetEnvironmentVariable("ENVIRONMENT") ?? "(unknown)");
var configFile = new FileInfo(connectionStringFile);
if (configFile.Exists)
{
var configurationBuilder = new ConfigurationBuilder();
if (configFile.Extension.ToLowerInvariant() == ".json")
{
configurationBuilder.AddJsonFile(configFile.FullName, false);
}
else
{
throw new LogException($"Unsupported configuration format \"{configFile.Extension}\"");
}
configurationBuilder.AddEnvironmentVariables();
var configuration = configurationBuilder.Build();
connectionStringContext = $"ConnectionStringFile: {configFile.FullName}";
return(configuration.GetConnectionString(ConnectionStringName));
}
throw new LogException($"Unable to find [{ConnectionStringFile}] at \"{configFile.FullName}\"");
}
if (!string.IsNullOrWhiteSpace(ConnectionStringEnvironmentName))
{
connectionStringContext = $"ConnectionStringEnvironmentName: {ConnectionStringEnvironmentName}";
return(Environment.GetEnvironmentVariable(ConnectionStringEnvironmentName));
}
#endif
if (AppSettingsKey != null && AppSettingsKey.Length > 0)
{
connectionStringContext = "AppSettingsKey";
string appSettingsConnectionString = SystemInfo.GetAppSetting(AppSettingsKey);
if (appSettingsConnectionString == null || appSettingsConnectionString.Length == 0)
{
throw new LogException("Unable to find [" + AppSettingsKey + "] AppSettings key.");
}
return(appSettingsConnectionString);
}
connectionStringContext = "Unable to resolve connection string from ConnectionString, ConnectionStrings, or AppSettings.";
return(string.Empty);
}
private bool setData()
{
DbProviderFactory myProv = Database.ProviderFactory;
DbTransaction myTrans = null;
DbConnection myConn = myProv.CreateConnection();
DbCommand myCmd = myConn.CreateCommand();
DbDataReader myRd = null;
string sSql;
string sResult;
bool res = true;
try
{
myConn.ConnectionString = getConnString();
myConn.Open();
myCmd.Connection = myConn;
myTrans = myConn.BeginTransaction();
myCmd.Transaction = myTrans;
//tables structure creation
TextReader tr = new StreamReader(
HttpContext.Current.Request.MapPath(Config.InstallationPath + "sql/create.sql"));
sSql = tr.ReadToEnd();
tr.Close();
sSql = Database.ParseSql(sSql, TxtTablesPrefix.Text);
sResult = Database.ExecuteQuery(myRd, myCmd, sSql);
//bulk data
tr = new StreamReader(
HttpContext.Current.Request.MapPath(Config.InstallationPath + "sql/bulk.sql"));
sSql = tr.ReadToEnd();
tr.Close();
sSql = Database.ParseSql(sSql, TxtTablesPrefix.Text);
sResult = Database.ExecuteQuery(myRd, myCmd, sSql);
myTrans.Commit();
}
catch (SqlException ex)
{
res = false;
myTrans.Rollback();
LblErr.Text += "error in sql query<br />";
LblErr.Text += ex.Message + "<br />";
}
finally
{
myTrans.Dispose();
myConn.Dispose();
}
//set custom data with direct sql because web.config settings reload at next request
if (res)
{
try
{
myConn.ConnectionString = getConnString();
myConn.Open();
myCmd.Connection = myConn;
myTrans = myConn.BeginTransaction();
myCmd.Transaction = myTrans;
sSql = "UPDATE #__memberUsers SET password=@password " +
" WHERE username = @username";
myCmd.CommandText = Database.ParseSql(sSql, TxtTablesPrefix.Text);
myCmd.Parameters.Add(Database.Parameter(myProv, "username", "admin"));
myCmd.Parameters.Add(Database.Parameter(myProv, "password", TxtAdminPassword.Text));
myCmd.ExecuteNonQuery();
myCmd.Parameters.Clear();
sSql = "UPDATE #__appSettings SET KeyValue=@KeyValue " +
" WHERE KeyName=@KeyName ";
myCmd.CommandText = Database.ParseSql(sSql, TxtTablesPrefix.Text);
myCmd.Parameters.Add(Database.Parameter(myProv, "KeyName", "MetaSiteTitle"));
myCmd.Parameters.Add(Database.Parameter(myProv, "KeyValue", TxtSiteTitle.Text));
myCmd.ExecuteNonQuery();
myCmd.Parameters.Clear();
sSql = "UPDATE #__appSettings SET KeyValue=@KeyValue " +
" WHERE KeyName=@KeyName ";
myCmd.CommandText = Database.ParseSql(sSql, TxtTablesPrefix.Text);
myCmd.Parameters.Add(Database.Parameter(myProv, "KeyName", "EmailSender"));
myCmd.Parameters.Add(Database.Parameter(myProv, "KeyValue", TxtEmail.Text));
myCmd.ExecuteNonQuery();
myTrans.Commit();
}
catch (SqlException ex)
{
res = false;
myTrans.Rollback();
LblErr.Text += "error setting custom data<br />";
LblErr.Text += ex.Message + "<br />";
}
finally
{
myTrans.Dispose();
myConn.Dispose();
}
//apply routes
try
{
new MvcRoutesManager().SetAppRoutes();
}
catch (Exception ex)
{
LblErr.Text += "error setting application default routes<br />";
LblErr.Text += ex.Message + "<br />";
}
//update web.config
if (res)
{
try
{
Configuration configuration =
WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
AppSettingsSection appSettingsSection = (AppSettingsSection)configuration.GetSection("appSettings");
if (appSettingsSection != null)
{
appSettingsSection.Settings["ConnectionStringName"].Value = TxtConnectionName.Text;
appSettingsSection.Settings["TabPrefix"].Value = TxtTablesPrefix.Text;
appSettingsSection.Settings["EncryptKey"].Value = TxtEncryptKey.Text;
//appSettingsSection.Settings["CultureDefault"].Value = TxtCultureDefault.Text;
}
ConnectionStringsSection connectionStringsSection = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
if (connectionStringsSection != null)
{
ConnectionStringSettings setting =
new ConnectionStringSettings(TxtConnectionName.Text, getConnString(), "System.Data.SqlClient");
if (connectionStringsSection.ConnectionStrings[TxtConnectionName.Text] != null)
connectionStringsSection.ConnectionStrings[TxtConnectionName.Text].ConnectionString = getConnString();
else
connectionStringsSection.ConnectionStrings.Add(setting);
}
MembershipSection membershipSection = (MembershipSection)configuration.GetSectionGroup("system.web").Sections["membership"];
if (membershipSection != null)
{
membershipSection.Providers["PgnUserProvider"].Parameters["connectionStringName"] = TxtConnectionName.Text;
}
RoleManagerSection roleManagerSection = (RoleManagerSection)configuration.GetSectionGroup("system.web").Sections["roleManager"];
if (roleManagerSection != null)
{
roleManagerSection.Providers["PgnRoleProvider"].Parameters["connectionStringName"] = TxtConnectionName.Text;
}
configuration.Save();
ConfigurationManager.RefreshSection("appSettings");
ConfigurationManager.RefreshSection("connectionStrings");
ConfigurationManager.RefreshSection("membership");
ConfigurationManager.RefreshSection("roleManager");
}
catch (Exception ex)
{
res = false;
LblErr.Text += "Error updating 'web.config' file. Please edit 'Conn1' connection string manually and upload this file again.<br />";
LblErr.Text += ex.Message + "<br />";
}
}
//rename install.txt file
try
{
string installFileName = Config.InstallationPath + "Install.txt";
string renamedInstallFileName = Config.InstallationPath + "Install_completed.txt";
installFileName = HttpContext.Current.Request.MapPath(installFileName);
renamedInstallFileName = HttpContext.Current.Request.MapPath(renamedInstallFileName);
if (File.Exists(installFileName))
File.Move(installFileName, renamedInstallFileName);
}
catch (Exception ex)
{
LblErr.Text += "Error renaming 'install.txt' file, please rename manually in '/pgn-admin/installation/Install_completed.txt'.<br />";
LblErr.Text += ex.Message + "<br />";
}
}
LblErr.Text = renderError(LblErr.Text);
return res;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="connectionStringSetting">连接字符串</param>
public SqlServerCeDbOperator(ConnectionStringSettings connectionStringSetting)
: base(connectionStringSetting)
{
this._dbConnection = new SqlCeConnection(connectionStringSetting.ConnectionString);
this.MyDataBaseType = (DataBaseType)Enum.Parse(typeof(DataBaseType), connectionStringSetting.ProviderName.ToUpper());
}
///<summary>
///更新连接字符串
///</summary>
///<param name="newName">连接字符串名称</param>
///<param name="newConString">连接字符串内容</param>
///<param name="newProviderName">数据提供程序名称</param>
public static void UpdateConnectionStringsConfig(string newName, string newConString, string newProviderName)
{
//指定config文件读取
string file = System.Windows.Forms.Application.ExecutablePath;
Configuration config = ConfigurationManager.OpenExeConfiguration (file);
bool exist = false; //记录该连接串是否已经存在
//如果要更改的连接串已经存在
if (config.ConnectionStrings.ConnectionStrings [newName] != null) {
exist = true;
}
// 如果连接串已存在，首先删除它
if (exist) {
config.ConnectionStrings.ConnectionStrings.Remove (newName);
}
//新建一个连接字符串实例
ConnectionStringSettings mySettings =
new ConnectionStringSettings (newName, newConString, newProviderName);
// 将新的连接串添加到配置文件中.
config.ConnectionStrings.ConnectionStrings.Add (mySettings);
// 保存对配置文件所作的更改
config.Save (ConfigurationSaveMode.Modified);
// 强制重新载入配置文件的ConnectionStrings配置节
ConfigurationManager.RefreshSection ("ConnectionStrings");
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlBatchOperation"/> class.
/// </summary>
/// <param name="connectionStringSettings">The connection string settings to use.</param>
public SqlBatchOperation(ConnectionStringSettings connectionStringSettings)
: base(connectionStringSettings)
{
base.paramPrefix = "@";
}
/// <summary>
/// Creates and caches connection strings by name.
/// </summary>
/// <param name="connectionString"></param>
/// <returns></returns>
public static IDictionary <string, string> CreateConnectionDictionary(ConnectionStringSettings connectionString)
{
return(_provider.Value.CreateConnectionDictionary(connectionString));
}
// Methods
public int IndexOf(ConnectionStringSettings settings) {}
