/// <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();
}