private void buttonZoom_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(t_gush_num.Text) && !String.IsNullOrEmpty(t_parcel_num.Text)) { IMapDocument mxd = CancelParcelEditor10_5.ArcMap.Application.Document as IMapDocument; IMap map = mxd.get_Map(0); IFeatureLayer flayer = AO.getLayerFromMxd(map, "חלקות להכנסה"); string query = "GUSHNUM = " + Convert.ToInt32(t_gush_num.Text).ToString() + " AND PARCEL_FINAL = " + Convert.ToInt32(t_parcel_num.Text).ToString(); AO.ZoomToSelection(mxd, flayer, query); } }
private void insert_Click(object sender, EventArgs e) { IMapDocument mxd = CancelParcelEditor10_5.ArcMap.Application.Document as IMapDocument; IMap map = mxd.get_Map(0); string gdb = AO.getLayerPathFromMxd(map, "חלקות לעריכה"); if (String.IsNullOrEmpty(gdb)) { MessageBox.Show("שכבת חלקות לעריכה אינה קיימת במפה"); } else { ITable table = AO.open_table(gdb, "CANCEL_PARCEL_EDIT"); if (table != null) { if (!String.IsNullOrEmpty(f_gush_num.Text) && !String.IsNullOrEmpty(f_parcel_num.Text) && !String.IsNullOrEmpty(t_gush_num.Text) && !String.IsNullOrEmpty(t_parcel_num.Text) && !String.IsNullOrEmpty(f_gush_suffix.Text) && !String.IsNullOrEmpty(t_gush_suffix.Text) ) { if (String.IsNullOrEmpty(f_parcel_num_e.Text) && String.IsNullOrEmpty(t_parcel_num_e.Text)) { IRow row = table.CreateRow(); row.Value[row.Fields.FindField("F_GUSH_NUM")] = Convert.ToInt32(f_gush_num.Text); row.Value[row.Fields.FindField("F_PARCEL_NUM")] = Convert.ToInt32(f_parcel_num.Text); row.Value[row.Fields.FindField("T_GUSH_NUM")] = Convert.ToInt32(t_gush_num.Text); row.Value[row.Fields.FindField("T_PARCEL_NUM")] = Convert.ToInt32(t_parcel_num.Text); row.Value[row.Fields.FindField("F_GUSH_SUFFIX")] = Convert.ToInt32(f_gush_suffix.Text); row.Value[row.Fields.FindField("T_GUSH_SUFFIX")] = Convert.ToInt32(t_gush_suffix.Text); row.Store(); MessageBox.Show("רשומה נוספה"); } else { if (!String.IsNullOrEmpty(f_parcel_num_e.Text) && String.IsNullOrEmpty(t_parcel_num_e.Text)) { int f_parcel_end = Convert.ToInt32(f_parcel_num_e.Text); int f_parcel_start = Convert.ToInt32(f_parcel_num.Text); while (f_parcel_start <= f_parcel_end) { IRow row = table.CreateRow(); row.Value[row.Fields.FindField("F_GUSH_NUM")] = Convert.ToInt32(f_gush_num.Text); row.Value[row.Fields.FindField("F_PARCEL_NUM")] = f_parcel_start; row.Value[row.Fields.FindField("T_GUSH_NUM")] = Convert.ToInt32(t_gush_num.Text); row.Value[row.Fields.FindField("T_PARCEL_NUM")] = Convert.ToInt32(t_parcel_num.Text); row.Value[row.Fields.FindField("F_GUSH_SUFFIX")] = Convert.ToInt32(f_gush_suffix.Text); row.Value[row.Fields.FindField("T_GUSH_SUFFIX")] = Convert.ToInt32(t_gush_suffix.Text); row.Store(); f_parcel_start++; } MessageBox.Show("רשומות נוספו (איחוד)"); } if (String.IsNullOrEmpty(f_parcel_num_e.Text) && !String.IsNullOrEmpty(t_parcel_num_e.Text)) { int t_parcel_end = Convert.ToInt32(t_parcel_num_e.Text); int t_parcel_start = Convert.ToInt32(t_parcel_num.Text); while (t_parcel_start <= t_parcel_end) { IRow row = table.CreateRow(); row.Value[row.Fields.FindField("F_GUSH_NUM")] = Convert.ToInt32(f_gush_num.Text); row.Value[row.Fields.FindField("F_PARCEL_NUM")] = Convert.ToInt32(f_parcel_num.Text); row.Value[row.Fields.FindField("T_GUSH_NUM")] = Convert.ToInt32(t_gush_num.Text); row.Value[row.Fields.FindField("T_PARCEL_NUM")] = t_parcel_start; row.Value[row.Fields.FindField("F_GUSH_SUFFIX")] = Convert.ToInt32(f_gush_suffix.Text); row.Value[row.Fields.FindField("T_GUSH_SUFFIX")] = Convert.ToInt32(t_gush_suffix.Text); row.Store(); t_parcel_start++; } MessageBox.Show("רשומות נוספו (חלוקה)"); } } } else { MessageBox.Show("נא למלא את כל השדות"); } } else { MessageBox.Show("טבלת CANCEL_PARCEL_EDIT אינה קיימת ב gdb"); } } }
private void cancel_Click(object sender, EventArgs e) { IMapDocument mxd = CancelParcelEditor10_5.ArcMap.Application.Document as IMapDocument; IMap map = mxd.get_Map(0); string gdb = AO.getLayerPathFromMxd(map, "חלקות לעריכה"); if (String.IsNullOrEmpty(gdb)) { MessageBox.Show("שכבת חלקות לעריכה אינה קיימת במפה"); } else { ITable table = AO.open_table(gdb, "CANCEL_PARCEL_EDIT"); if (table != null) { if (!String.IsNullOrEmpty(f_gush_num.Text) && !String.IsNullOrEmpty(f_parcel_num.Text) && !String.IsNullOrEmpty(t_gush_num.Text) && !String.IsNullOrEmpty(t_parcel_num.Text) && !String.IsNullOrEmpty(f_gush_suffix.Text) && !String.IsNullOrEmpty(t_gush_suffix.Text)) { if (String.IsNullOrEmpty(f_parcel_num_e.Text) && String.IsNullOrEmpty(t_parcel_num_e.Text)) { ICursor cursor = AO.create_table_cursor(table); IRow row = cursor.NextRow(); bool deleted = false; while (row != null) { if (!(row.Value[row.Fields.FindField("F_GUSH_NUM")] == null) && !(row.Value[row.Fields.FindField("F_PARCEL_NUM")] == null) && !(row.Value[row.Fields.FindField("T_GUSH_NUM")] == null) && !(row.Value[row.Fields.FindField("T_PARCEL_NUM")] == null)) { if ( row.Value[row.Fields.FindField("F_GUSH_NUM")] == Convert.ToInt32(f_gush_num.Text) && row.Value[row.Fields.FindField("F_PARCEL_NUM")] == Convert.ToInt32(f_parcel_num.Text) && row.Value[row.Fields.FindField("T_GUSH_NUM")] == Convert.ToInt32(t_gush_num.Text) && row.Value[row.Fields.FindField("T_PARCEL_NUM")] == Convert.ToInt32(t_parcel_num.Text) ) { row.Delete(); MessageBox.Show("רשומה נמחקה"); deleted = true; } row = cursor.NextRow(); } } if (deleted == false) { MessageBox.Show("לא נמצאה רשומה למחיקה"); } } else { if (!String.IsNullOrEmpty(f_parcel_num_e.Text) && String.IsNullOrEmpty(t_parcel_num_e.Text)) { int f_parcel_end = Convert.ToInt32(f_parcel_num_e.Text); int f_parcel_start = Convert.ToInt32(f_parcel_num.Text); List <object> parcel_num_in = new List <object>(); while (f_parcel_start <= f_parcel_end) { parcel_num_in.Add(f_parcel_start.ToString()); f_parcel_start++; } string query = "T_PARCEL_NUM =" + t_parcel_num.Text + " AND F_PARCEL_NUM IN (" + AO.ListToString(parcel_num_in) + ")"; ICursor cursor = AO.create_table_cursor_with_query(table, query); IRow row = cursor.NextRow(); bool deleted = false; while (row != null) { row.Delete(); row = cursor.NextRow(); deleted = true; } if (deleted == false) { MessageBox.Show("לא נמצאה רשומה למחיקה"); } } if (String.IsNullOrEmpty(f_parcel_num_e.Text) && !String.IsNullOrEmpty(t_parcel_num_e.Text)) { int t_parcel_end = Convert.ToInt32(t_parcel_num_e.Text); int t_parcel_start = Convert.ToInt32(t_parcel_num.Text); List <object> parcel_num_in = new List <object>(); while (t_parcel_start <= t_parcel_end) { parcel_num_in.Add(t_parcel_start.ToString()); t_parcel_start++; } string query = "F_PARCEL_NUM =" + f_parcel_num.Text + " AND T_PARCEL_NUM IN (" + AO.ListToString(parcel_num_in) + ")"; ICursor cursor = AO.create_table_cursor_with_query(table, query); IRow row = cursor.NextRow(); bool deleted = false; while (row != null) { row.Delete(); row = cursor.NextRow(); deleted = true; } if (deleted == false) { MessageBox.Show("לא נמצאה רשומה למחיקה"); } } } } else { MessageBox.Show("נא למלא את כל השדות"); } } else { MessageBox.Show("טבלת CANCEL_PARCEL_EDIT אינה קיימת ב gdb"); } } }
private void button1_Click(object sender, EventArgs e) { IMapDocument mxd = ZoomNextError.ArcMap.Application.Document as IMapDocument; IMap map = mxd.get_Map(0); string gdb = AO.getLayerPathFromMxd(map, "חלקות לעריכה"); if (String.IsNullOrEmpty(gdb)) { MessageBox.Show("שכבת חלקות לעריכה אינה קיימת במפה"); } if (String.IsNullOrEmpty(gdb)) { MessageBox.Show("שכבת חלקות לעריכה אינה קיימת במפה"); } else { ITable table = AO.open_table(gdb, "Errors"); int sum_items = table.RowCount(null); if (table != null) { counter_items++; int counter = 0; ICursor cursor = AO.create_table_cursor_with_query(table, "\"OBJECTID\" > " + current_OID.ToString()); IRow row = cursor.NextRow(); while (counter < 1 && row != null) { if (counter_items < sum_items) { counter++; current_OID = row.OID; //MessageBox.Show(current_OID.ToString()); string GushNum = row.Value[row.Fields.FindField("GushNum")]; string ParcelNum = row.Value[row.Fields.FindField("ParcelNum")]; string GushSfx = row.Value[row.Fields.FindField("GushSfx")]; object ErrDescription = row.Value[row.Fields.FindField("ErrDescription")]; string query = "OBJECTID < 0"; if (GushNum == "0" && ParcelNum == "0" && ErrDescription != null) { if (ErrDescription.ToString().Contains("OID:")) { //MessageBox.Show(System.Text.RegularExpressions.Regex.Match(ErrDescription.ToString(), @"\d+").Value); string oid = System.Text.RegularExpressions.Regex.Match(ErrDescription.ToString(), @"\d+").Value; query = "OBJECTID = " + oid; } } else { query = "GUSH_NUM = " + GushNum + " AND PARCEL = " + ParcelNum + " AND GUSH_SUFFIX = " + GushSfx; } IFeatureLayer flayer = AO.getLayerFromMxd(map, "חלקות לעריכה"); AO.ZoomToSelection(mxd, flayer, query); List_acc.Add(row.OID); //MessageBox.Show(get(List_acc)); row = cursor.NextRow(); if (ErrDescription != null) { label3.Text = ErrDescription.ToString(); label5.Text = sum_items.ToString() + " / " + List_acc.Count.ToString(); } else { label3.Text = "ללא תיאור"; label5.Text = ""; } } else { current_OID = -1; counter_items = 0; } } } } }