/// <summary> /// / /// </summary> /// <param name="model_id"></param> /// <param name="model_temp"></param> /// <param name="model_humidity"></param> /// <param name="aname"></param> public static void Model_Insert(ref DB_TBL_MODEL Model) // Model Insert 메소드 { conn.Open(); // Mysql Open string Model_Insert_Sql = "INSERT INTO TBL_MODEL VALUES(" + Model.Model_Id + "," + Model.Model_Temp + "," + Model.Model_Humidity + ",'" + Model.Model_Aname + "');"; // Insert 쿼리문 MySqlCommand SQL_INSERT = new MySqlCommand(Model_Insert_Sql, conn); // Insert Command문 SQL_INSERT.ExecuteNonQuery(); // Insert 실행 conn.Close(); // mysql Close }
public static void Model_Update(ref DB_TBL_MODEL Model) // Model Update 메소드 { conn.Open(); string Model_Update_Sql = "update TBL_MODEL set model_id = " + Model.Model_Id + ", model_temp = " + Model.Model_Temp + ", model_humidity = " + Model.Model_Humidity + ", aname = '" + Model.Model_Aname + "' where model_id = " + Model.Model_Id + ";"; // update sql문을 담을 string 변수 MySqlCommand SQL_Update = new MySqlCommand(Model_Update_Sql, conn); SQL_Update.ExecuteNonQuery(); conn.Close(); }
} // model 생성 public void Proc_req_model_updata(string[] receive_data_division, ref NetworkStream stream) { DB_TBL_MODEL Model = new DB_TBL_MODEL(receive_data_division[2], receive_data_division[3], receive_data_division[4], receive_data_division[5]); DB_MGR.Model_Update(ref Model); string send_data = "모델업데이트 완료"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } // model 변경
} // model 변경 public void Proc_req_model_delete(string[] receive_data_division, ref NetworkStream stream) { try { DB_TBL_MODEL model = new DB_TBL_MODEL(); DB_MGR.Model_Delete(receive_data_division[2]); string send_data = "모델 삭제완료"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } catch (Exception gg) { string send_data = "모델 삭제실패"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } } // model 삭제
public static void Model_Select(ref List <DB_TBL_MODEL> Model) { conn.Open(); string Model_All_Select_Sql = "SELECT * FROM TBL_MODEL;"; //본인의 DB이름 MySqlCommand Command_Model_All_Select = new MySqlCommand(Model_All_Select_Sql, conn); MySqlDataReader Reader_Model_All_Select = Command_Model_All_Select.ExecuteReader(); // Sql문 Reader하는 Class while (Reader_Model_All_Select.Read()) // TBL_MODEL의 컬럼 내용 모두 읽을 때 까지 반복 { DB_TBL_MODEL Model_Select = new DB_TBL_MODEL(); // TBL_MODEL 테이블 객체 생성 Model_Select.Model_Id = Reader_Model_All_Select["model_id"].ToString(); // TBL_MODEL 테이블의 model_id 컬럼 불러오기 Model_Select.Model_Temp = Reader_Model_All_Select["model_temp"].ToString(); // TBL_MODEL 테이블의 model_temp 컬럼 불러오기 Model_Select.Model_Humidity = Reader_Model_All_Select["model_humidity"].ToString(); // TBL_MODEL 테이블의 model_humidity 컬럼 불러오기 Model_Select.Model_Aname = Reader_Model_All_Select["aname"].ToString(); // TBL_MODEL 테이블의 aname 컬럼 불러오기 Model.Add(Model_Select); // 모든 정보 ArrayList 담기 } conn.Close(); }