public static IList<string> getValues(string headerText, string strgKey) { List<string> ret = new List<string>(); DataTable tbl = null; //DBから読み込む using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); tbl = dao.selectSettingRows(headerText, strgKey); con.CloseConnection(); } if (tbl != null) { foreach (DataRow row in tbl.Rows) { ret.Add(row["TEXTVALUE"].ToString()); } } return ret; }
public static void getValue(string strgKey, out string strgValue) { strgValue = ""; if (!SettingsSingleton.isExistsStringValue(strgKey)) { //キャッシュになし //DBから読み込む using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); SettingsDAO dao = new SettingsDAO(con); dao.selectSetting(strgKey, out strgValue); con.CloseConnection(); SettingsSingleton.cache_[strgKey] = new values(Int32.MinValue, strgValue); } } else { //キャッシュにあり //キャッシュの値を返す values v = SettingsSingleton.cache_[strgKey]; strgValue = v.strgValue; } }
public static void setValue(DAOContext con, string strgKey, string strgValue) { SettingsDAO dao = new SettingsDAO(con); dao.mergeSettings(strgKey, strgValue); SettingsSingleton.cache_[strgKey] = new values(Int32.MinValue, strgValue); }
public static bool isExistsHeader(DAOContext con, string headerText) { if (con.Connection.State != ConnectionState.Open) return false; bool ret = false; MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); ret = dao.isExistsHeader(headerText); return ret; }
public MyDAOBase(DAOContext context) { if (context == null) { throw new ArgumentNullException("context"); } this.Context = context; }
public static void deleteSettings(string headerText, string strgKey) { using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.deleteSettings(headerText, strgKey); con.CloseConnection(); } }
public static void deleteSettings(DAOContext con, string headerText) { //DBから読み込む MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.deleteSettings(headerText); dao.deleteHeader(headerText); }
public static void MergeHeader(string headerText) { using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.mergeHeader(headerText); con.CloseConnection(); } }
public static void setValue(string strgKey, string strgValue) { using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); SettingsDAO dao = new SettingsDAO(con); dao.mergeSettings(strgKey, strgValue); con.CloseConnection(); } SettingsSingleton.cache_[strgKey] = new values(Int32.MinValue, strgValue); }
public static void setValue(string headerText, string strgKey, int intValue) { using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.mergeSettings(headerText, strgKey, intValue); con.CloseConnection(); } }
public static void getValue(DAOContext con, string headerText, string strgKey, out int intValue) { intValue = 0; if (con.Connection.State != ConnectionState.Open) return; //DBから読み込む MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.selectSetting(headerText, strgKey, out intValue); }
public static string getValue(DAOContext con, string headerText, string strgKey) { string strgValue = ""; if (con.Connection.State != ConnectionState.Open) return ""; //DBから読み込む MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.selectSetting(headerText, strgKey, out strgValue); return strgValue; }
public static bool isExistsHeader(string headerText) { bool ret = false; using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); ret = dao.isExistsHeader(headerText); con.CloseConnection(); } return ret; }
public static void setStringValues(DAOContext con, string headerText, string strgKey, IList<string> strgs) { if (con.Connection.State != ConnectionState.Open) return; int no = 1; MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.deleteSettings(headerText, strgKey); foreach (string strg in strgs) { dao.insertNew(headerText, strgKey, no, strg); no++; } }
public static string getValue(string headerText, string strgKey) { string strgValue = ""; //DBから読み込む using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.selectSetting(headerText, strgKey, out strgValue); con.CloseConnection(); } return strgValue; }
public static IList<string> getHeaderTexts(DAOContext con) { List<string> headertexts = new List<string>(); DataTable tbl = null; //DBから読み込む MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); tbl = dao.selectHeaders(); if (tbl != null) { foreach (DataRow row in tbl.Rows) { headertexts.Add(row["HEADERTEXT"].ToString()); } } return headertexts; }
public static void setStringValues(string headerText, string strgKey, IList<string> strgs) { int no = 1; using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.deleteSettings(headerText, strgKey); foreach (string strg in strgs) { dao.insertNew(headerText, strgKey, no, strg); no++; } con.CloseConnection(); } }
public static IList<string> getValues(DAOContext con, string headerText, string strgKey) { List<string> ret = new List<string>(); DataTable tbl = null; if (con.Connection.State != ConnectionState.Open) return ret; //DBから読み込む MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); tbl = dao.selectSettingRows(headerText, strgKey); if (tbl != null) { foreach (DataRow row in tbl.Rows) { ret.Add(row["TEXTVALUE"].ToString()); } } return ret; }
public static void getValue(DAOContext con, string strgKey, out string strgValue) { strgValue = ""; if (!SettingsSingleton.isExistsStringValue(strgKey)) { //キャッシュになし //DBから読み込む SettingsDAO dao = new SettingsDAO(con); dao.selectSetting(strgKey, out strgValue); SettingsSingleton.cache_[strgKey] = new values(Int32.MinValue, strgValue); } else { //キャッシュにあり //キャッシュの値を返す values v = SettingsSingleton.cache_[strgKey]; strgValue = v.strgValue; } }
public static void getValue(DAOContext con, string strgKey, out int intValue) { intValue = 0; if (!SettingsSingleton.isExistsIntValue(strgKey)) { //キャッシュになし //DBから読み込む SettingsDAO dao = new SettingsDAO(con); dao.selectSetting(strgKey, out intValue); SettingsSingleton.cache_[strgKey] = new values(intValue, null); } else { //キャッシュにあり //キャッシュの値を返す values v = SettingsSingleton.cache_[strgKey]; intValue = v.intValue; } }
public static IList<string> getHeaderTexts() { List<string> headertexts = new List<string>(); DataTable tbl = null; //DBから読み込む using (DAOContext con = new DAOContext(AccessConstring.SettingConString)) { con.OpenConnection(); MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); tbl = dao.selectHeaders(); con.CloseConnection(); } if (tbl != null) { foreach (DataRow row in tbl.Rows) { headertexts.Add(row["HEADERTEXT"].ToString()); } } return headertexts; }
public AccessSchemaDAO(DAOContext con) : base(con) { }
public static void setValue(DAOContext con, string headerText, string strgKey, string strgValue) { if (con.Connection.State != ConnectionState.Open) return; MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.mergeSettings(headerText, strgKey, strgValue); }
public static void MergeHeader(DAOContext con, string headerText) { if (con.Connection.State != ConnectionState.Open) return; MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.mergeHeader(headerText); }
public static void deleteSettings(DAOContext con, string headerText, string strgKey) { if (con.Connection.State != ConnectionState.Open) return; MyDummySQLSettingsDAO dao = new MyDummySQLSettingsDAO(con); dao.deleteSettings(headerText, strgKey); }
public SettingsDAO(DAOContext con) : base(con) { }
public MyDummySQLSettingsDAO(DAOContext con) : base(con) { }
public funcsDAO(DAOContext con) : base(con) { }
public tableDAO(DAOContext con, string tableName_) : base(con) { this.tableName = tableName_; }
public TemplatesDAO(DAOContext con) : base(con) { }