static internal System.Data.DataTable SelectVall(string tableName, System.Collections.Generic.List <string> selectedCOll, System.Collections.Generic.Dictionary <string, string> WhereCouple) { var(collumn, where) = DataBaseHelper. SelectFormateHelper(selectedCOll, WhereCouple); var dt = new System.Data.DataTable(); using (var connection = DataBaseConnect.Connect()) { try { connection.Open(); var command = new SqlCommand( string.Format(DataBaseConstants.SelectQuery, collumn, tableName, where), connection); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(dt); } catch (System.Exception e) { connection.Close(); throw e; } } return(dt); }
// 初始化呼叫 public bool Initialize() { bool success = false; if (db.Initialize() && redis.Initialize()) { if (db.Connect() && redis.Connect()) { success = true; } else { SaveLog($"[Error] Connect DB Or Redis Error"); } } return(success); }
// 初始化呼叫 public bool Initialize() { bool success = false; if (db.Initialize() && redis.Initialize()) { if (db.Connect() && redis.Connect()) { AddUpdateFunc("TeamBulletin", CheckTeamBulletin); success = true; } else { SaveLog($"[Error] Connect DB Or Redis Error"); } } return(success); }
// 初始化呼叫 public bool Initialize() { bool success = false; if (db.Initialize() && redis.Initialize()) { if (db.Connect() && redis.Connect()) { AddUpdateFunc("UserAccount", UpdateUserAccount); AddUpdateFunc("UserInfo", UpdateUserInfo); success = true; } else { SaveLog($"[Error] Connect DB Or Redis Error"); } } return(success); }
static internal void DeleteInTable(string tableName, System.Collections.Generic.Dictionary <string, string> WhereCouple) { string WhereCond = DataBaseHelper.WhereFormateHelper(WhereCouple); using (SqlConnection connection = DataBaseConnect.Connect()) { try { connection.Open(); SqlCommand command = new SqlCommand( string.Format(DataBaseConstants.DellQuery, tableName, WhereCond), connection); command.ExecuteNonQuery(); } catch (System.Exception e) { connection.Close(); throw e; } } }
static internal void InsertInTable(string tableName, System.Collections.Generic.Dictionary <string, string> InsertCoup) { var(Coll, vall) = DataBaseHelper.InsertFormateHelper(InsertCoup); using (SqlConnection connection = DataBaseConnect.Connect()) { try { connection.Open(); SqlCommand command = new SqlCommand( string.Format(DataBaseConstants.InsertQuery, tableName, Coll, vall), connection); command.ExecuteNonQuery(); } catch (System.Exception e) { connection.Close(); throw e; } } }
public MainWindow() { InitializeComponent(); using (var connection = DataBaseConnect.Connect()) { try { connection.Open(); var command = new SqlCommand( DataBaseConstants.SelectTableAndColumnName, connection); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { DataBaseConstants.hint = new System.Collections.ObjectModel.ObservableCollection <CoupleTwoValues>(); while (reader.Read()) { string buf_coll_name = (string)reader.GetValue(1); if (buf_coll_name != "is_zip") { DataBaseConstants.hint. Add(new CoupleTwoValues { First = (string)reader.GetValue(0), Second = buf_coll_name }); } } } } catch (System.Exception ex) { MessageBox.Show(ex.Message, "Error"); } } SelectGrid.IsReadOnly = true; }
static internal System.Data.DataTable RunAdvancedQuery(string Query) { var dt = new System.Data.DataTable(); using (var connection = DataBaseConnect.Connect()) { try { connection.Open(); var command = new SqlCommand( Query, connection); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(dt); } catch (System.Exception e) { connection.Close(); throw e; } } return(dt); }
// 初始化呼叫 public bool Initialize() { bool success = false; if (db.Initialize() && redis.Initialize()) { if (db.Connect() && redis.Connect()) { AddUpdateFunc("RideData", UpdateRideData); AddUpdateFunc("RideRecord", UpdateRideRecord); AddUpdateFunc("RideIdList", UpdateRideIdList); AddUpdateFunc("CurWeekRideData", UpdateWeekRideData); success = true; } else { SaveLog($"[Error] Connect DB Or Redis Error"); } } return(success); }
public bool Initialize() { bool bReturn = false; try { log = new Logger(fm1); log.SaveLog($"Controller Version: {version}"); wsServer = new Server(this); dbConnect = new DataBaseConnect(log); if (dbConnect.Initialize()) { if (dbConnect.Connect()) { if (wsServer.Initialize()) { bReturn = true; } } } if (!bReturn) { log.SaveLog("[Error] Controller::Initialize, Initialize Fail"); } } catch (Exception ex) { log.SaveLog($"[Error] Controller::Initialize, Catch Error, Msg:{ex.Message}"); } return(bReturn); }
static internal void UpdateInTable(string tableName, System.Collections.Generic.Dictionary <string, string> Value, System.Collections.Generic.Dictionary <string, string> where) { string Values = DataBaseHelper.UpdateFormateHelper(Value); string StringWhere = DataBaseHelper.WhereFormateHelper(where); using (SqlConnection connection = DataBaseConnect.Connect()) { try { connection.Open(); SqlCommand command = new SqlCommand( string.Format(DataBaseConstants.UpdQuery, tableName, Values, StringWhere), connection); command.ExecuteNonQuery(); } catch (System.Exception e) { connection.Close(); throw e; } } }