public void onInitSet() { try { mainform.onDBRead_Robotlist("all"); mainform.onDBRead_RobotStatus(); mainform.onDBRead_Maplist(); onCtrlEnable(false); dataGridView_robotreg.Rows.Clear(); List <string> strrobotlist = new List <string>(); int cnt = mainform.Robot_RegInfo_list.Count(); for (int i = 0; i < cnt; i++) { string strtmp = ""; Robot_RegInfo robotinfo = mainform.Robot_RegInfo_list.ElementAt(i).Value; strtmp = string.Format("{0},{1},{2},{3},{4}({5})", robotinfo.robot_id, robotinfo.robot_name, robotinfo.robot_ip, robotinfo.robot_group, robotinfo.map_name, robotinfo.map_id); if (mainform.Robot_Status_list.ContainsKey(robotinfo.robot_id)) { strtmp = string.Format("{0},{1}", mainform.Robot_Status_list[robotinfo.robot_id].work_status, strtmp); } else { strtmp = string.Format("wait,{0}", strtmp); } string[] strtmpbuf = strtmp.Split(','); dataGridView_robotreg.Rows.Add(strtmpbuf); } if (mainform.Map_list.Count > 0) { for (int j = 0; j < mainform.Map_list.Count; j++) { Map_list maplist = new Map_list(); maplist = mainform.Map_list.ElementAt(j).Value; string strmap = string.Format("{0}({1})", maplist.map_name, maplist.map_id); cboMap.Items.Add(strmap); } } } catch (Exception ex) { Console.WriteLine("robotreg_Ctrl ..onInitSet err" + ex.Message.ToString()); } }
/// <summary> /// 등록된 맵리스트 읽기 /// </summary> public void onDBRead_Maplist() { string sql = ""; bool bdataok = false; try { sql = string.Format("SELECT * FROM map_t "); DataSet ds = new DataSet(); MySqlDataAdapter da = new MySqlDataAdapter(sql, G_SqlCon); da.Fill(ds); Map_list.Clear(); int ncnt = ds.Tables[0].Rows.Count; if (ncnt > 0) { for (int i = 0; i < ncnt; i++) { string strmapid = ds.Tables[0].Rows[i]["map_id"].ToString(); string strmapname = ds.Tables[0].Rows[i]["map_name"].ToString(); Map_list maplist = new Map_list(); maplist.map_id = strmapid; maplist.map_name = strmapname; Map_list.Add(strmapid, maplist); } } } catch (MySqlException ex) { MessageBox.Show("onDBRead_Maplist err" + ex.Message.ToString()); } catch (Exception ex2) { MessageBox.Show("onDBRead_Maplist err" + ex2.Message.ToString()); } }