/// <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);
}
}
