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 갯수 만큼 생성
