private void dataGridViewCheck_DoubleClick(object sender, EventArgs e) { this.SavaType = "edit"; DataGridViewRow row = this.dataGridViewCheck.CurrentRow; this.EditId = row.Cells["ID"].Value.ToString(); string NAME = row.Cells["质检项"].Value.ToString(); string TYPE = row.Cells["CHECKTYPE"].Value.ToString(); string TABLENAME = row.Cells["TABLENAME"].Value.ToString(); string WHERESTRING = row.Cells["WHERESTRING"].Value.ToString(); string SUPTABLE = row.Cells["SUPTABLE"].Value.ToString(); string INPUTTEXT = row.Cells["INPUTTEXT"].Value.ToString(); //string checkType = this.comboBoxCheckType.SelectedItem.ToString(); textBoxName.Text = NAME; this.comboBoxCheckType.SelectedIndex = this.comboBoxCheckType.FindString(TYPE); foreach (DataRowView iTable in this.comboBoxDataSource.Items) { if (TABLENAME == iTable.Row[0].ToString()) { this.comboBoxDataSource.SelectedIndex = this.comboBoxDataSource.FindString((string)iTable.Row[1]); } } if (TYPE == "面内包含点个数") { FormContainPoint formContainPoint = new FormContainPoint(); ContainPoint.textBoxWhereValue = WHERESTRING; ContainPoint.comboBoxPointValue = SUPTABLE; ContainPoint.textBoxNumPointValue = INPUTTEXT; } else if (TYPE == "面和线不相交") { FormNoInterLine formNoInterLine = new FormNoInterLine(); NoInterLine.comboBoxLineValue = SUPTABLE; } else if (TYPE == "面重叠检查(与其他图层)") { FormNoOverlapArea formNoOverlapArea = new FormNoOverlapArea(); NoOverlapArea.comboBoxOverLayerValue = SUPTABLE; } else if (TYPE == "细碎面") { Formxbm formxbm = new Formxbm(); xbmDig.textBoxwhereValue = WHERESTRING; xbmDig.textBoxinputValue = INPUTTEXT; } else if (TYPE == "缝隙检查") { FormNoGaps formgaps = new FormNoGaps(); NoGaps.textBoxareaValue = INPUTTEXT; } else { } }
/// <summary> /// 面内包含点个数 /// 面多部件检查 /// 面和线不相交 /// 跨边界面不相交 /// 跨图层面重叠 /// 面图层自相交 /// 面缝隙 /// 面重叠 /// 细碎面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void comboBoxCheckType_SelectedIndexChanged(object sender, EventArgs e) { this.splitContainer2.Panel2.Controls.Clear(); if (comboBoxCheckType.SelectedItem == null) { return; } string checkType = comboBoxCheckType.Text.ToString(); if (checkType == "面内包含点个数") { FormContainPoint formContainPoint = new FormContainPoint(); ContainPoint = formContainPoint; ShowForm(this.splitContainer2.Panel2, formContainPoint); } else if (checkType == "面和线不相交") { FormNoInterLine formNoInterLine = new FormNoInterLine(); NoInterLine = formNoInterLine; ShowForm(this.splitContainer2.Panel2, formNoInterLine); } else if (checkType == "面重叠检查(与其他图层)") { FormNoOverlapArea formNoOverlapArea = new FormNoOverlapArea(); NoOverlapArea = formNoOverlapArea; ShowForm(this.splitContainer2.Panel2, formNoOverlapArea); } else if (checkType == "细碎面") { Formxbm formxbm = new Formxbm(); xbmDig = formxbm; ShowForm(this.splitContainer2.Panel2, formxbm); } else if (checkType == "缝隙检查") { FormNoGaps formgaps = new FormNoGaps(); NoGaps = formgaps; ShowForm(this.splitContainer2.Panel2, formgaps); } }
private void buttonTopoSave_Click(object sender, EventArgs e) { ConnectDB db = new ConnectDB(); string checkType = comboBoxCheckType.Text.ToString(); string name = textBoxName.Text; string table = comboBoxDataSource.SelectedValue.ToString(); string type = comboBoxCheckType.Text; Boolean result = true; if (checkType == "面内包含点个数") { FormContainPoint formContainPoint = new FormContainPoint(); string where = ContainPoint.textBoxWhereValue; string supTable = ContainPoint.comboBoxPointValue; string inputText = ContainPoint.textBoxNumPointValue; if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',WHERESTRING = '" + where + "',SUPTABLE='" + supTable + "',INPUTTEXT = '" + inputText + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,WHERESTRING,SUPTABLE,INPUTTEXT,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + where + "','" + supTable + "','" + inputText + "','" + this.scheme + "'," + this.checkNo + ")"); } } else if (checkType == "面和线不相交") { FormNoInterLine formNoInterLine = new FormNoInterLine(); string supTable = NoInterLine.comboBoxLineValue; if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',SUPTABLE='" + supTable + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,SUPTABLE,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + supTable + "','" + this.scheme + "'," + this.checkNo + ")"); } } else if (checkType == "面重叠检查(与其他图层)") { FormNoOverlapArea formNoOverlapArea = new FormNoOverlapArea(); string supTable = NoOverlapArea.comboBoxOverLayerValue; if (supTable == table) { DialogResult dr = MessageBox.Show("主表和附表一样,是否继续?", "提示", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',SUPTABLE='" + supTable + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,SUPTABLE,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + supTable + "','" + this.scheme + "'," + this.checkNo + ")"); } } else { return; } } else { if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',SUPTABLE='" + supTable + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,SUPTABLE,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + supTable + "','" + this.scheme + "'," + this.checkNo + ")"); } } } else if (checkType == "细碎面") { Formxbm formxbm = new Formxbm(); string where = xbmDig.textBoxwhereValue; string input = xbmDig.textBoxinputValue; if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',WHERESTRING='" + where + "',INPUTTEXT='" + input + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,WHERESTRING,INPUTTEXT,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + where + "','" + input + "','" + this.scheme + "'," + this.checkNo + ")"); } } else if (checkType == "缝隙检查") { FormNoGaps formgaps = new FormNoGaps(); string input = NoGaps.textBoxareaValue; if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',INPUTTEXT='" + input + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,INPUTTEXT,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + input + "','" + this.scheme + "'," + this.checkNo + ")"); } } else { if (this.SavaType == "edit") { result = db.Update("update GISDATA_TBTOPO set NAME= '" + name + "',CHECKTYPE = '" + type + "',TABLENAME = '" + table + "',SCHEME = '" + this.scheme + "',STEP_NO = " + this.checkNo + " where ID = " + this.EditId); } else { result = db.Insert("insert into GISDATA_TBTOPO (NAME,CHECKTYPE,TABLENAME,SCHEME,STEP_NO) VALUES('" + name + "','" + type + "','" + table + "','" + this.scheme + "'," + this.checkNo + ")"); } } if (result) { refushTable(); } }