void clickButtonToDraw(object sender, EventArgs e) { Button bt1 = (Button)sender; if (clickMenu == 1) { //Lấy level của nút này try { string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'"; int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel)); if (getlevel < Main.levelNumber - 1) { frmInputData f = new frmInputData(bt1.Name, bt1.Text, idMucTieu); f.StartPosition = FormStartPosition.CenterScreen; f.Show(); } } catch (SqlException) { } } else if (clickMenu == 2) { try { string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'"; int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel)); //MessageBox.Show(Form1.levelNumber.ToString()); //MessageBox.Show("có level ="+getlevel.ToString()); if (getlevel < Main.levelNumber - 1 - 1) { Form3 f = new Form3(bt1.Name, bt1.Text); f.Show(); } } catch (SqlException) { } } else { totalButtonToDraw++; if (totalButtonToDraw == 1) { pointRight.X = bt1.Left + 100; pointRight.Y = bt1.Top + 15; pointLeft.X = bt1.Left; pointLeft.Y = bt1.Top + 15; //Luu id button so 1 bang text id_button_1 = select id_button from BUTTON with button_name = bt1.Name indexFirstButton = bt1.Name; } if (totalButtonToDraw == 2) { //Luu id button so 1 bang text indexSecondButton = select id_button from BUTTON with button_name = bt1.Name indexSecondButton = bt1.Name; //Kiểm tra xem 2 button này có trong bảng kết nối không string queryString_connect_scalar_1 = @"select count(*) FROM CONNECT WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexFirstButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexSecondButton + "')"; //MessageBox.Show("Nút "+id_button_1+" và "+indexSecondButton+" có EXECUTESCALR = "+ketnoisql.ExecuteScalar(queryString_connect_scalar_1).ToString()); string queryString_connect_scalar_2 = @"select count(*) FROM CONNECT WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexSecondButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexFirstButton + "')"; //MessageBox.Show("space cua button " + id_button_1 + " la " + (string)ketnoisql.ExecuteScalar(queryString_space_button1)); string queryString_space_button1 = @"SELECT button_space FROM BUTTON WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexFirstButton + "')"; string queryString_space_button2 = @"SELECT button_space FROM BUTTON WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexSecondButton + "')"; string space_button_1 = (string)ketnoisql.ExecuteScalar(queryString_space_button1); string space_button_2 = (string)ketnoisql.ExecuteScalar(queryString_space_button2); string queryString_space = ""; //MessageBox.Show("space cua button " + id_button_1 + " la " + ketnoisql.ExecuteScalar(queryString_space_button1).ToString() + "\n space cua button " + indexSecondButton + " la " + ketnoisql.ExecuteScalar(queryString_space_button2).ToString()); if (Convert.ToInt32(space_button_1) > Convert.ToInt32(space_button_2)) { queryString_space = @"select count (*) FROM BUTTON WHERE(survey_id = " + idMucTieu + " AND button_space < N'" + space_button_1 + "' AND button_space > N'" + space_button_2 + "')"; } else { queryString_space = @"select count (*) FROM BUTTON WHERE(survey_id = " + idMucTieu + " AND button_space > N'" + space_button_1 + "' AND button_space < N'" + space_button_2 + "')"; } if ((int)ketnoisql.ExecuteScalar(queryString_connect_scalar_1) != 0 || (int)ketnoisql.ExecuteScalar(queryString_connect_scalar_2) != 0) { MessageBox.Show("Đã có nét vẽ rồi"); totalButtonToDraw = 0; } //Kiểm tra xem có vẽ nhảy cóc hay không else if ((int)ketnoisql.ExecuteScalar(queryString_space) != 0) { MessageBox.Show("Không vẽ nhảy cóc"); totalButtonToDraw = 0; } else { //Vẽ DrawLineConnectButtonAndInsertData(bt1); totalButtonToDraw = 0; } } } }
void clickButtonToDraw(object sender, EventArgs e) { Button bt1 = (Button)sender; if (clickMenu == 1) { //Lấy level của nút này try { string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'"; int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel)); if (getlevel < Main.levelNumber - 1) { frmInputData f = new frmInputData(bt1.Name, bt1.Text, idMucTieu); f.StartPosition = FormStartPosition.CenterScreen; f.Show(); } } catch (SqlException) { } } else if (clickMenu == 2) { try { string query_getLevel = @"SELECT button_level FROM dbo.BUTTON WHERE survey_id = " + idMucTieu + " AND button_name=N'" + bt1.Name + "'"; int getlevel = Convert.ToInt32(ketnoisql.ExecuteScalar(query_getLevel)); //MessageBox.Show(Form1.levelNumber.ToString()); //MessageBox.Show("có level ="+getlevel.ToString()); if (getlevel < Main.levelNumber - 1 - 1) { Form3 f = new Form3(bt1.Name, bt1.Text); f.Show(); } } catch (SqlException) { } } else { totalButtonToDraw++; if (totalButtonToDraw == 1) { pointRight.X = bt1.Left + 100; pointRight.Y = bt1.Top + 15; pointLeft.X = bt1.Left; pointLeft.Y = bt1.Top + 15; //Luu id button so 1 bang text id_button_1 = select id_button from BUTTON with button_name = bt1.Name indexFirstButton = bt1.Name; } if (totalButtonToDraw == 2) { //Luu id button so 1 bang text indexSecondButton = select id_button from BUTTON with button_name = bt1.Name indexSecondButton = bt1.Name; //Kiểm tra xem 2 button này có trong bảng kết nối không string queryString_connect_scalar_1 = @"select count(*) FROM CONNECT WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexFirstButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexSecondButton + "')"; //MessageBox.Show("Nút "+id_button_1+" và "+indexSecondButton+" có EXECUTESCALR = "+ketnoisql.ExecuteScalar(queryString_connect_scalar_1).ToString()); string queryString_connect_scalar_2 = @"select count(*) FROM CONNECT WHERE (survey_id = " + idMucTieu + " AND CONNECT.connect_button_highLevel = N'" + indexSecondButton + "' AND CONNECT.connect_button_lowLevel = N'" + indexFirstButton + "')"; //MessageBox.Show("space cua button " + id_button_1 + " la " + (string)ketnoisql.ExecuteScalar(queryString_space_button1)); string queryString_space_button1 = @"SELECT button_space FROM BUTTON WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexFirstButton + "')"; string queryString_space_button2 = @"SELECT button_space FROM BUTTON WHERE (survey_id = " + idMucTieu + " AND button_name = N'" + indexSecondButton + "')"; string space_button_1 = (string)ketnoisql.ExecuteScalar(queryString_space_button1); string space_button_2 = (string)ketnoisql.ExecuteScalar(queryString_space_button2); string queryString_space = ""; //MessageBox.Show("space cua button " + id_button_1 + " la " + ketnoisql.ExecuteScalar(queryString_space_button1).ToString() + "\n space cua button " + indexSecondButton + " la " + ketnoisql.ExecuteScalar(queryString_space_button2).ToString()); if (Convert.ToInt32(space_button_1) > Convert.ToInt32(space_button_2)) queryString_space = @"select count (*) FROM BUTTON WHERE(survey_id = " + idMucTieu + " AND button_space < N'" + space_button_1 + "' AND button_space > N'" + space_button_2 + "')"; else queryString_space = @"select count (*) FROM BUTTON WHERE(survey_id = " + idMucTieu + " AND button_space > N'" + space_button_1 + "' AND button_space < N'" + space_button_2 + "')"; if ((int)ketnoisql.ExecuteScalar(queryString_connect_scalar_1) != 0 || (int)ketnoisql.ExecuteScalar(queryString_connect_scalar_2) != 0) { MessageBox.Show("Đã có nét vẽ rồi"); totalButtonToDraw = 0; } //Kiểm tra xem có vẽ nhảy cóc hay không else if ((int)ketnoisql.ExecuteScalar(queryString_space) != 0) { MessageBox.Show("Không vẽ nhảy cóc"); totalButtonToDraw = 0; } else { //Vẽ DrawLineConnectButtonAndInsertData(bt1); totalButtonToDraw = 0; } } } }