public void UpdateSalesCallFactView() { // read ini sql string validCallSql = ""; if (_dbManager.SalesppIniPath != null && _dbManager.SalesppIniPath != string.Empty) { IniFile iniFile = new IniFile(_dbManager.SalesppIniPath); validCallSql = iniFile.IniReadValue("FieldInformer", "VALIDCALL"); } // run sproc SqlConnection conn = _dbManager.GetDataSourceConnection(); conn.Open(); SqlCommand cmd = conn.CreateCommand(); try { cmd.CommandText = "EXEC spp.proc_create_V_OLAP_SALESCALL_FACT '" + validCallSql.Replace("'", "''") + "'"; cmd.ExecuteNonQuery(); } catch (Exception exc) { // ignore error cause otherwise default view will be created inside sproc exc = null; } finally { conn.Close(); cmd.Dispose(); } }
/// <summary> /// 读取 /// </summary> /// <returns></returns> public static string ReadFile(string key) { IniFile ini = new IniFile(path); return ini.IniReadValue("setting", key); }
public static string GetValue(string section, string key) { IniFile ini = new IniFile(Application.StartupPath + "\\config.cfg"); return ini.IniReadValue(section, key); }