private void synchronizeData() { Data.PoliceModel.SessionModel session = Data.CenterDataFactory.KeyTable(); Data.CenterDataFactory.BlackName(session.Id); Data.CenterDataFactory.WhiteName(session.Id, session.Name); }
/// <summary> /// 同步比赛 /// </summary> public static PoliceModel.SessionModel KeyTable() { LogManager.WriteLog("开始同步比赛数据"); int session_id = 0; PoliceModel.SessionModel session = new PoliceModel.SessionModel(); try { string searchSql = @"select * FROM sessions WHERE `status` = 0 "; DataTable sessiondt = MySqlDBHelper.ExecuteDataTable(centerCon, searchSql); if (sessiondt.Rows.Count > 0) { DataRow sessiondataRow = sessiondt.Rows[0]; session_id = Convert.ToInt32(sessiondataRow["session_id"]); session.Id = session_id; session.Name = sessiondataRow["session_name"].ToString(); LogManager.WriteLog("比赛场次:" + sessiondataRow["session_name"].ToString()); string deleteSql = "DELETE FROM key_table where session_id =" + session_id + "; DELETE FROM sessions where session_id =" + session_id + ";"; MySqlDBHelper.ExecuteNonQuery(entranceCon, CommandType.Text, deleteSql); string sessionInsertSql = @"INSERT INTO `sessions` (`session_id`,`create_date`,`session_name`,`session_date`,`date_start`,`date_end`,`check_rule`,`status`,`remark`) VALUES (@session_id,@create_date,@session_name,@session_date,@date_start,@date_end,@check_rule,@status,@remark)"; MySqlParameter[] mySqlParameters = new MySqlParameter[9]; mySqlParameters[0] = new MySqlParameter("session_id", sessiondataRow["session_id"]); mySqlParameters[1] = new MySqlParameter("create_date", sessiondataRow["create_date"]); mySqlParameters[2] = new MySqlParameter("session_name", sessiondataRow["session_name"]); mySqlParameters[3] = new MySqlParameter("session_date", sessiondataRow["session_date"]); mySqlParameters[4] = new MySqlParameter("date_start", sessiondataRow["date_start"]); mySqlParameters[5] = new MySqlParameter("date_end", sessiondataRow["date_end"]); mySqlParameters[6] = new MySqlParameter("check_rule", sessiondataRow["check_rule"]); mySqlParameters[7] = new MySqlParameter("status", sessiondataRow["status"]); mySqlParameters[8] = new MySqlParameter("remark", sessiondataRow["remark"]); MySqlDBHelper.ExecuteNonQuery(entranceCon, CommandType.Text, sessionInsertSql, mySqlParameters); string keysearchSql = @"select * FROM key_table WHERE `session_id` = " + session_id; DataTable keytabledt = MySqlDBHelper.ExecuteDataTable(centerCon, keysearchSql); if (keytabledt.Rows.Count > 0) { DataRow row = keytabledt.Rows[0]; string keytableInsertSql = @"INSERT INTO `key_table` (`key_id`,`create_date`,`session_id`,`key_content`,`key_type`,`remark`) VALUES (@key_id,@create_date,@session_id,@key_content,@key_type,@remark)"; MySqlParameter[] keySqlParameters = new MySqlParameter[6]; keySqlParameters[0] = new MySqlParameter("key_id", row["key_id"]); keySqlParameters[1] = new MySqlParameter("create_date", row["create_date"]); keySqlParameters[2] = new MySqlParameter("session_id", row["session_id"]); keySqlParameters[3] = new MySqlParameter("key_content", row["key_content"]); keySqlParameters[4] = new MySqlParameter("key_type", row["key_type"]); keySqlParameters[5] = new MySqlParameter("remark", row["remark"]); MySqlDBHelper.ExecuteNonQuery(entranceCon, CommandType.Text, keytableInsertSql, keySqlParameters); } } LogManager.WriteLog("同步比赛数据完成"); } catch (Exception ex) { LogManager.WriteLog("同步比赛数据异常:" + ex.Message); } return(session); }