/// <summary> /// 增减区域选项 /// </summary> public void zoneOptions() { try { List <Model_Region> regionlist = new List <Model_Region>(); ResultModelOfArrayOfModel_Regiond4FqxSXX zo = cs.GetZoneOptions(); if (zo.Code != 0) { MessageBox.Show(zo.Message); } else { foreach (Model_Region item in zo.Data) { Model_Region region = new Model_Region(); region.Idk__BackingField = item.Idk__BackingField; region.Namek__BackingField = item.Namek__BackingField; regionlist.Add(region); } } cmbQY.DisplayMember = "Namek__BackingField"; cmbQY.ValueMember = "Idk__BackingField"; cmbQY.DataSource = regionlist; } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ecitmenu_Click(object sender, EventArgs e) { try { //判断是否选中行政区域节点信息 if (treeView1.SelectedNode == null) { MessageBox.Show("请选择行政区域"); return; } if (treeView1.SelectedNode.Name != string.Empty && treeView1.SelectedNode.Text != string.Empty) { Model_Region region = treeView1.SelectedNode.Tag as Model_Region; FrmAdministrativeAE see = new FrmAdministrativeAE(); see._frmadministrativecontrol = this; see.region = region; see.nanber = 0;//0修改,1添加,2修改 see.ShowDialog(); } else { MessageBox.Show("请选择行政区域"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 查看选中行政区域信息的下一级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void checkmenu_Click(object sender, EventArgs e) { try { //判断是否选中行政区域节点信息 if (treeView1.SelectedNode == null) { MessageBox.Show("请选择行政区域"); return; } if (treeView1.SelectedNode.Name != string.Empty && treeView1.SelectedNode.Text != string.Empty) { Model_Region region = new Model_Region(); //MessageBox.Show(treeView1.SelectedNode.Name + "," + treeView1.SelectedNode.Text); region.Idk__BackingField = Convert.ToInt32(treeView1.SelectedNode.Name); region.Namek__BackingField = treeView1.SelectedNode.Text; FrmSeeAdministrative see = new FrmSeeAdministrative(); see.region = region; see.ShowDialog(); } else { MessageBox.Show("请选择行政区域"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 省份 /// </summary> public void getProvince() { try { ResultModelOfArrayOfModel_Regiond4FqxSXX prov = cs.GetRegionInfo(1, true); if (prov.Code != 0) { MessageBox.Show(prov.Message); } else { List <Model_Region> regions = new List <Model_Region>(); Model_Region reg = new Model_Region(); reg.Idk__BackingField = 0; reg.Namek__BackingField = "中国"; regions.Add(reg); foreach (Model_Region item in prov.Data) { Model_Region regs = new Model_Region(); regs.Idk__BackingField = item.Idk__BackingField; regs.Namek__BackingField = item.Namek__BackingField; regs.ParentIdk__BackingField = item.ParentIdk__BackingField; regions.Add(regs); } cmbProvince.DisplayMember = "Namek__BackingField"; cmbProvince.ValueMember = "Idk__BackingField"; cmbProvince.DataSource = regions; } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ecitmenu_Click(object sender, EventArgs e) { Model_Region modelregion = dataGridView1.SelectedRows[0].Tag as Model_Region; //MessageBox.Show(modelregion .Idk__BackingField+ ","+modelregion.Namek__BackingField); FrmAdministrativeAE adminae = new FrmAdministrativeAE(); adminae._frmseeadministratve = this; adminae.region = modelregion; adminae.nanber = 2;//0修改,1添加,2当前窗体 adminae.ShowDialog(); }
public void RegionEdit() { try { if (region != null) { if (RegionDate()) { Model_Region regions = new Model_Region(); if (nanber == 0 || nanber == 2) { //修改 regions.Idk__BackingField = region.Idk__BackingField; regions.ParentIdk__BackingField = region.ParentIdk__BackingField; } else { //添加 regions.ParentIdk__BackingField = region.Idk__BackingField; } regions.Codek__BackingField = txtcode.Text.Trim(); regions.Namek__BackingField = txtname.Text.Trim(); regions.Levelk__BackingField = 0; regions.Orderk__BackingField = 0; regions.NameEnglishk__BackingField = string.Empty; regions.NameShortEnglishk__BackingField = string.Empty; ResultModelOfint regint = cs.RegionEdit(regions); if (regint.Code != 0) { MessageBox.Show(regint.Message); } else { MessageBox.Show("操作成功"); if (nanber == 0 || nanber == 1) { _frmadministrativecontrol.Refurbish(); } if (nanber == 2) { _frmseeadministratve.Refurbish(); } this.Close(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 添加/修改行政区域信息 /// </summary> /// <param name="mregion"></param> /// <returns></returns> public ResultModel <int> RegionEdit(Model_Region mregion) { ResultModel <int> result = new ResultModel <int>(); try { result.Data = AreaCityServer.RegionEdit(mregion); } catch (Exception ex) { result.Code = 1; result.Message = ex.Message; } return(result); }
/// <summary> /// 添加/修改行政区域信息 /// </summary> /// <param name="mregion"></param> /// <returns></returns> public static int RegionEdit(Model_Region mregion) { if (mregion == null) { throw new Exception("没有行政区域信息"); } string sql = ""; int result = 0; int max = 0; sql = string.Format("select max(id) from region ;"); max = Convert.ToInt32(_SqlHelp.ExecuteScalar(sql)); max = max + 1; if (mregion.Id == 0) { sql = string.Format("insert into region(id,`code`,`name`,parentId,`level`,`order`,nameEnglish,nameShortEnglish,lastUpdateTime) values({0},'{1}','{2}',{3},{4},{5},'{6}','{7}','{8}'); ", max, mregion.Code, mregion.Name, mregion.ParentId, mregion.Level, mregion.Order, mregion.NameEnglish, mregion.NameShortEnglish, DateTime.Now); } else { sql = string.Format("update region set `code`='{0}',`name`='{1}',parentId={2},`level`={3},`order`={4},nameEnglish='{5}',nameShortEnglish='{6}',lastUpdateTime='{7}' where id={8} ;", mregion.Code, mregion.Name, mregion.ParentId, mregion.Level, mregion.Order, mregion.NameEnglish, mregion.NameShortEnglish, DateTime.Now, mregion.Id); } if (mregion.Id == 0) { result = _SqlHelp.ExecuteNonQuery(sql); } else { result = _SqlHelp.ExecuteNonQuery(sql); } if (result != 1) { throw new Exception("行政区域更新失败"); } return(result); }
public void City() { try { int a = 0; if (cmbQY.Text != string.Empty) { if (cmbQY.Text != "中国") { a = Convert.ToInt32(cmbQY.SelectedValue); } } List <Model_Region> regionlist = new List <Model_Region>(); ResultModelOfArrayOfModel_Regiond4FqxSXX cit = cs.GetCity(a, true); if (cit.Code != 0) { MessageBox.Show(cit.Message); } else { foreach (Model_Region item in cit.Data) { Model_Region region = new Model_Region(); region.Idk__BackingField = item.Idk__BackingField; region.Namek__BackingField = item.Namek__BackingField; regionlist.Add(region); } } cmbCity.DisplayMember = "Namek__BackingField"; cmbCity.ValueMember = "Idk__BackingField"; cmbCity.DataSource = regionlist; } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }