public static void Products_Select(ref List <DB_TBL_PRODUCTS> Products) // Model 모두 검색 메소드 { conn.Open(); string Products_All_Select_Sql = "SELECT * FROM TBL_PRODUCTS;"; //본인의 DB이름 MySqlCommand Command_Products_All_Select = new MySqlCommand(Products_All_Select_Sql, conn); MySqlDataReader Reader_Products_All_Select = Command_Products_All_Select.ExecuteReader(); // Sql문 Reader하는 Class while (Reader_Products_All_Select.Read()) // TBL_MODEL의 컬럼 내용 모두 읽을 때 까지 반복 { DB_TBL_PRODUCTS Productss = new DB_TBL_PRODUCTS(); Productss._Id = Reader_Products_All_Select["_id"].ToString(); Productss.Model = Reader_Products_All_Select["model"].ToString(); Productss.Line_Id = Reader_Products_All_Select["line_id"].ToString(); Productss.Lot_Id = Reader_Products_All_Select["lot_id"].ToString(); Productss.Model_Temp = Reader_Products_All_Select["model_temp"].ToString(); Productss.Model_Humidity = Reader_Products_All_Select["model_humidity"].ToString(); Productss.Working_State = Reader_Products_All_Select["working_state"].ToString(); Productss.Insp_Result = Reader_Products_All_Select["insp_result"].ToString(); Productss.Fail_Reason = Reader_Products_All_Select["fail_reason"].ToString(); Productss.Insp_Time = Reader_Products_All_Select["insp_time"].ToString(); ; Products.Add(Productss); //Products.Add(Reader_Products_All_Select["_id"].ToString() + " " + Reader_Products_All_Select["model"].ToString() + " " + Reader_Products_All_Select["line_id"].ToString() + " " + Reader_Products_All_Select["lot_id"].ToString() // + " " + Reader_Products_All_Select["model_temp"].ToString() + " " + Reader_Products_All_Select["model_humidity"].ToString() + " " + Reader_Products_All_Select["working_state"].ToString() + " " + Reader_Products_All_Select["insp_result"].ToString() // + " " + Reader_Products_All_Select["fail_reason"].ToString() + " " + Reader_Products_All_Select["insp_time"].ToString()); // 모든 정보 ArrayList 담기 } conn.Close(); }
} // lot 작업시작시 product count 갯수 만큼 생성 public void Proc_req_products_update2(string[] receive_data_division, ref NetworkStream stream) { try { if (receive_data_division[3].Substring(0, 1) == "\n") { DB_TBL_PRODUCTS Products = new DB_TBL_PRODUCTS(receive_data_division[2], "", "", receive_data_division[3].Substring(1, receive_data_division[3].Length - 1) , receive_data_division[4], receive_data_division[5], "1", receive_data_division[6], receive_data_division[7]); DB_MGR.Products_Update2(ref Products); string send_data = "products Update 성공"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } else { DB_TBL_PRODUCTS Products = new DB_TBL_PRODUCTS(receive_data_division[2], "", "", receive_data_division[3], receive_data_division[4], receive_data_division[5], "1", receive_data_division[6], receive_data_division[7]); DB_MGR.Products_Update2(ref Products); string send_data = "products Update 성공"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } } catch (Exception gh) { string send_data = gh.ToString(); byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } }
///////////////// public static void Products_Insert(ref DB_TBL_PRODUCTS Products) // Products Insert 메소드 { conn.Open(); // Mysql Open string Products_Insert_Sql = "INSERT INTO TBL_PRODUCTS (_id, model, line_id, lot_id, working_state, insp_time) VALUES(" + Products._Id + ",'" + Products.Model + "','" + Products.Line_Id + "','" + Products.Lot_Id + "',0,now());"; // Insert 쿼리문 MySqlCommand Command_Products_Insert = new MySqlCommand(Products_Insert_Sql, conn); // Insert Command문 Command_Products_Insert.ExecuteNonQuery(); // Insert 실행 conn.Close(); // mysql Close }
public static void Products_Update3(ref DB_TBL_PRODUCTS Products) { conn.Open(); string Products_Update_Sql = "update TBL_PRODUCTS set working_state = 2 where _id = " + Products._Id + " and lot_id = '" + Products.Lot_Id + "';"; MySqlCommand Command_Products_Update = new MySqlCommand(Products_Update_Sql, conn); Command_Products_Update.ExecuteNonQuery(); conn.Close(); }
public static void Products_Update(ref DB_TBL_PRODUCTS Products) // Model Update 메소드 { conn.Open(); string Products_Update_Sql = "update TBL_PRODUCTS set model_temp = " + Products.Model_Temp + ", model_humidity = " + Products.Model_Humidity + ", insp_result = '" + Products.Insp_Result + "', fail_reason = '" + Products.Fail_Reason + "'," + "insp_time = now() where _id = " + Products._Id + ";"; MySqlCommand Command_Products_Update = new MySqlCommand(Products_Update_Sql, conn); Command_Products_Update.ExecuteNonQuery(); conn.Close(); }
public static void Products_Update2(ref DB_TBL_PRODUCTS Products) { try { conn.Open(); string Products_Update_Sql = "update TBL_PRODUCTS set model_temp = " + Products.Model_Temp + ", model_humidity = " + Products.Model_Humidity + ", " + "working_state = '" + Products.Working_State + "', insp_result = '" + Products.Insp_Result + "', fail_reason = '" + Products.Fail_Reason + "'," + "insp_time = now() where _id = " + Products._Id + " and lot_id = '" + Products.Lot_Id + "';"; MySqlCommand Command_Products_Update = new MySqlCommand(Products_Update_Sql, conn); Command_Products_Update.ExecuteNonQuery(); conn.Close(); } catch (Exception gh) { conn.Close(); } }
public void Proc_req_products_update3(string[] receive_data_division, ref NetworkStream stream) { if (receive_data_division[3].Substring(0, 1) == "\n") { DB_TBL_PRODUCTS Products = new DB_TBL_PRODUCTS(receive_data_division[2], "", "", receive_data_division[3].Substring(1, receive_data_division[3].Length - 1), "", "", "", "", ""); DB_MGR.Products_Update3(ref Products); string send_data = "products 종료"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } else { DB_TBL_PRODUCTS Products = new DB_TBL_PRODUCTS(receive_data_division[2], "", "", receive_data_division[3], "", "", "", "", ""); DB_MGR.Products_Update3(ref Products); string send_data = "products 종료"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } }
} // 작업시작시 line 생성 public void Proc_req_products_create(string[] receive_data_division, ref NetworkStream stream) { for (int i = 0; i < Convert.ToInt32(receive_data_division[5]); i++) { DB_TBL_PRODUCTS Products = new DB_TBL_PRODUCTS(go_txt, receive_data_division[2], receive_data_division[3], receive_data_division[4], "30", "20", "0", "-", "-"); DB_MGR.Products_Insert(ref Products); bo12 = Convert.ToInt32(go12); bo11 = Convert.ToInt32(go11); bo10 = Convert.ToInt32(go10); bo9 = Convert.ToInt32(go9); bo8 = Convert.ToInt32(go8); bo7 = Convert.ToInt32(go7); bo6 = Convert.ToInt32(go6); bo5 = Convert.ToInt32(go5); bo4 = Convert.ToInt32(go4); bo3 = Convert.ToInt32(go3); bo2 = Convert.ToInt32(go2); bo1 = Convert.ToInt32(go1); bo12++; go12 = bo12.ToString(); go_txt = go1 + go2 + go3 + go4 + go5 + go6 + go7 + go8 + go9 + go10 + go11 + go12; if (go12 == "0") { bo11++; go_index++; } if (go11 == "0" && go_index == 1) { bo10++; go_index++; } if (go10 == "0" && go_index == 2) { bo9++; go_index++; } if (go9 == "0" && go_index == 3) { bo8++; go_index++; } if (go8 == "0" && go_index == 4) { bo7++; go_index++; } if (go7 == "0" && go_index == 5) { bo6++; go_index++; } if (go6 == "0" && go_index == 6) { bo5++; go_index++; } if (go5 == "0" && go_index == 7) { bo4++; go_index++; } if (go4 == "0" && go_index == 8) { bo3++; go_index++; } if (go3 == "0" && go_index == 9) { bo2++; go_index++; } if (go2 == "0" && go_index == 10) { bo1++; go_index++; } if (go1 == "0" && go_index == 11) { bo1 = 0; bo2 = 0; bo3 = 0; bo4 = 0; bo5 = 0; bo6 = 0; bo7 = 0; bo8 = 0; bo9 = 0; bo10 = 0; bo11 = 0; bo12 = 0; go_index = 0; } go12 = bo12.ToString(); go11 = bo11.ToString(); go10 = bo10.ToString(); go9 = bo9.ToString(); go8 = bo8.ToString(); go7 = bo7.ToString(); go6 = bo6.ToString(); go5 = bo5.ToString(); go4 = bo4.ToString(); go3 = bo3.ToString(); go2 = bo2.ToString(); go1 = bo1.ToString(); } string send_data = "products 생성"; byte[] Response_Data = Encoding.Default.GetBytes(send_data); stream.Write(Response_Data, 0, Response_Data.Length); } // lot 작업시작시 product count 갯수 만큼 생성