Esempio n. 1
0
        public static void Lot_Select(ref List <DB_TBL_LOT> Lot)
        {
            conn.Open();
            string          Lot_All_Select_Sql     = "SELECT * FROM TBL_LOT;";               //본인의 DB이름
            MySqlCommand    Command_Lot_All_Select = new MySqlCommand(Lot_All_Select_Sql, conn);
            MySqlDataReader Reader_Lot_All_Select  = Command_Lot_All_Select.ExecuteReader(); // Sql문 Reader하는 Class

            while (Reader_Lot_All_Select.Read())                                             // TBL_MODEL의 컬럼 내용 모두 읽을 때 까지 반복
            {
                DB_TBL_LOT Lott = new DB_TBL_LOT();
                Lott.Lot_Id                 = Reader_Lot_All_Select["lot_id"].ToString();
                Lott.Model_Id               = Reader_Lot_All_Select["model_id"].ToString();
                Lott.Line_Id                = Reader_Lot_All_Select["line_id"].ToString();
                Lott.Total_Product_Count    = Reader_Lot_All_Select["total_product_count"].ToString();
                Lott.Product_Speed_Warn     = Reader_Lot_All_Select["product_speed_warn"].ToString();
                Lott.Product_Fail_Rate_Warn = Reader_Lot_All_Select["product_fail_rate_warn"].ToString();
                Lott.Product_Color          = Reader_Lot_All_Select["product_color"].ToString();
                Lott.Temp_Margin            = Reader_Lot_All_Select["temp_margin"].ToString();
                Lott.Humid_Margin           = Reader_Lot_All_Select["humid_margin"].ToString();
                Lott.Oper_Id                = Reader_Lot_All_Select["oper_id"].ToString();
                Lott.Working_State          = Reader_Lot_All_Select["working_state"].ToString();
                Lott.Lot_Created_Time       = Reader_Lot_All_Select["lot_created_time"].ToString();
                Lott.Lot_Start_Time         = Reader_Lot_All_Select["lot_start_time"].ToString();
                Lott.Lot_End_Time           = Reader_Lot_All_Select["lot_end_time"].ToString();

                Lot.Add(Lott);

                //Lot.Add(Reader_Lot_All_Select["lot_id"].ToString() + " " + Reader_Lot_All_Select["model_id"].ToString() + " " + Reader_Lot_All_Select["line_id"].ToString() + " " + Reader_Lot_All_Select["total_product_count"].ToString() + " " + Reader_Lot_All_Select["product_speed_warn"].ToString() +
                //     Reader_Lot_All_Select["product_fail_rate_warn"].ToString() + " " + Reader_Lot_All_Select["product_color"].ToString() + " " + Reader_Lot_All_Select["temp_margin"].ToString() + " " + Reader_Lot_All_Select["humid_margin"].ToString() + " " + Reader_Lot_All_Select["oper_id"].ToString() +
                //      Reader_Lot_All_Select["working_state"].ToString() + " " + Reader_Lot_All_Select["lot_created_time"].ToString() + " " + Reader_Lot_All_Select["lot_start_time"].ToString() + " " + Reader_Lot_All_Select["lot_end_time"].ToString()); // 모든 정보 ArrayList 담기
            }
        }
Esempio n. 2
0
        ////
        public static void Lot_Insert(ref DB_TBL_LOT lot) // Lot 기본정보 Insert 메서드
        {
            conn.Open();                                  // Mysql Open
            string Lot_Insert_Sql = "INSERT INTO TBL_LOT (lot_id, model_id, line_id, total_product_count, product_speed_warn, product_fail_rate_warn, product_color, " +
                                    "temp_margin, humid_margin, oper_id, working_state, lot_created_time) VALUES('" + lot.Lot_Id + "'," + lot.Model_Id + ",'" + lot.Line_Id + "'," + lot.Total_Product_Count + "," + lot.Product_Speed_Warn + "," + lot.Product_Fail_Rate_Warn + ", " +
                                    "'" + lot.Product_Color + "'," + lot.Temp_Margin + "," + lot.Humid_Margin + ",'" + lot.Oper_Id + "'," + lot.Working_State + ",now());"; // Insert 쿼리문
            MySqlCommand Command_Lot_Insert = new MySqlCommand(Lot_Insert_Sql, conn);                                                                                       // Insert Command문

            Command_Lot_Insert.ExecuteNonQuery();                                                                                                                           // Insert 실행
            conn.Close();                                                                                                                                                   // mysql Close
        }
Esempio n. 3
0
        }  // 작업시작 후 model start time 갱신

        public void Proc_req_lot_create(string[] receive_data_division, ref NetworkStream stream)
        {
            DB_TBL_LOT Lot = new DB_TBL_LOT(receive_data_division[2], receive_data_division[3], receive_data_division[4], receive_data_division[5], receive_data_division[6], receive_data_division[7],
                                            receive_data_division[8], receive_data_division[9], receive_data_division[10], receive_data_division[11], receive_data_division[12], "-", "-", "-");

            DB_MGR.Lot_Insert(ref Lot);

            string send_data = "lot생성";

            byte[] Response_Data = Encoding.Default.GetBytes(send_data);
            stream.Write(Response_Data, 0, Response_Data.Length);
        } // lot 생성