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;
}
}
}
