private void tsmiDelete_Click(object sender, EventArgs e)
{
if (SelectedFeature == null)
{
MessageBox.Show("请选择点进行删除！");
}
else
{
try
{
Int32 iNDH = -1;
try
{
iNDH = Convert.ToInt32(SelectedFeature["NDH"]);
}
catch
{ }
Table tEditTable = (mapControl1.Map.Layers["JKINFO"] as FeatureLayer).Table;
tEditTable.DeleteFeature(SelectedFeature);
SelectedFeature = null;
JKINFOBLL bllJKINFO = new JKINFOBLL();
String MDBFileName = (SysInfo.HTDBInfo[cbMaps.Text] as DBInfo).MDBPath;
bllJKINFO.DeleteJKINFO(iNDH, MDBFileName);
MessageBox.Show("删除成功！");
}
catch
{
MessageBox.Show("数据异常！");
}
}
}
private void JKINFOList_Load(object sender, EventArgs e)
{
JKINFOBLL bllJKINFO = new JKINFOBLL();
try
{
dataGridView1.DataSource = bllJKINFO.GetList(_MDBFileName, "").Tables[0].Copy();
}
catch
{
MessageBox.Show("¼ÓÔØÊý¾Ý³ö´í£¡");
}
}
private void tsmiAdd_Click(object sender, EventArgs e)
{
AddJKINFO frmAddJKINFO = new AddJKINFO();
if (frmAddJKINFO.ShowDialog() == DialogResult.OK)
{
Table tEditTable = (mapControl1.Map.Layers["JKINFO"] as FeatureLayer).Table;
Feature f = new Feature(tEditTable.TableInfo.Columns);
DPoint dp = ConvertTOJWDu(pNodePoint);
f.Geometry = new MapInfo.Geometry.Point(mapControl1.Map.GetDisplayCoordSys(), dp);
//f.GeometryIndex = 4;
f.Style = sDefault;
foreach (DataRow dr in SysInfo.TypeDataTable.Rows)
{
int iType = Convert.ToInt32(dr["JKType"]);
if (frmAddJKINFO.OBJJKINFO.SBLX == iType)
{
f.Style = new MapInfo.Styles.CompositeStyle(new MapInfo.Styles.BitmapPointStyle(dr["BMPFileName"].ToString(), BitmapStyles.None, Color.Blue, 10));
}
}
f["NDH"] = frmAddJKINFO.OBJJKINFO.NDH;
f["SJ"] = frmAddJKINFO.OBJJKINFO.SJ;
f["DW"] = frmAddJKINFO.OBJJKINFO.DW;
MapInfo.Data.Key ftrkey = tEditTable.InsertFeature(f);
//MessageBox.Show(f.Key.Value.ToString());
///查询方法
//SearchInfo si = MapInfo.Data.SearchInfoFactory.SearchWhere("mi_key='8'");
//IResultSetFeatureCollection ifs = MapInfo.Engine.Session.Current.Catalog.Search(tEditTable, si); //JKINFO
//frmAddJKINFO.OBJJKINFO.MAPINFO_ID = Convert.ToInt32(ftrkey.Value);
JKINFOBLL bllJKINFO = new JKINFOBLL();
String MDBFileName = (SysInfo.HTDBInfo[cbMaps.Text] as DBInfo).MDBPath;
if (bllJKINFO.AddJKINFO(frmAddJKINFO.OBJJKINFO, MDBFileName))
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
tEditTable.DeleteFeature(ftrkey);
}
}
}
private void tsmiView_Click(object sender, EventArgs e)
{
if (SelectedFeature == null)
{
MessageBox.Show("请选择点进行查看！");
}
else
{
try
{
Int32 iNDH = Convert.ToInt32(SelectedFeature["NDH"]);
JKINFOBLL bllJKINFO = new JKINFOBLL();
String MDBFileName = (SysInfo.HTDBInfo[cbMaps.Text] as DBInfo).MDBPath;
MapApp.Entities.JKINFO oJKINFO = bllJKINFO.GetJKINFO(iNDH, MDBFileName);
ViewJKINFO frmViewJKINFO = new ViewJKINFO(oJKINFO);
frmViewJKINFO.ShowDialog();
}
catch
{
MessageBox.Show("数据异常！");
}
}
}
private static void RewNew()
{
while (true)
{
JKINFOBLL bllJKINFO = new JKINFOBLL();
String MDBFileName = (SysInfo.HTDBInfo[sMapName] as DBInfo).MDBPath;
DataTable dtAllRow = bllJKINFO.GetList(MDBFileName, "").Tables[0].Copy();
if (dtAllRow.Rows.Count <= 0)
{
return;
}
if (ifs.Count <= 0)
{
return;
}
else
{
//FeatureLayer lyrTemp = (FeatureLayer)mapControl1.Map.Layers["JKINFO"];
//if (lyrTemp != null)
//{
// IFeatureEnumerator fen = (lyrTemp.Table as IFeatureCollection).GetFeatureEnumerator();
// while (fen.MoveNext())
// {
// Feature ftemp = fen.Current;
// try
// {
// Int32 iNDH = -1;
// if (ftemp["NDH"] == null)
// continue;
// try
// {
// iNDH = Convert.ToInt32(ftemp["NDH"]);
// foreach (DataRow dr in dtAllRow.Rows)
// {
// try
// {
// if (iNDH == Convert.ToInt32(dr["NDH"]))
// {
// ftemp["SJ"] = dr["SJ"];
// ftemp["DW"] = dr["DW"];
// ftemp.Table.UpdateFeature(ftemp);
// break;
// }
// }
// catch
// { }
// }
// }
// catch
// {
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show("更新中发生错误：" + ex.Message);
// }
// }
//}
for (int i = 0; i < ifs.Count; i++)
{
Feature ftemp = ifs[i];
try
{
Int32 iNDH = -1;
if (ftemp["NDH"] == null)
{
continue;
}
try
{
iNDH = Convert.ToInt32(ftemp["NDH"]);
foreach (DataRow dr in dtAllRow.Rows)
{
try
{
if (iNDH == Convert.ToInt32(dr["NDH"]))
{
ftemp["SJ"] = dr["SJ"];
ftemp["DW"] = dr["DW"];
ftemp.Table.UpdateFeature(ftemp);
break;
}
}
catch
{ }
}
}
catch
{
}
}
catch //(Exception ex)
{
//MessageBox.Show("更新中发生错误：" + ex.Message);
}
}
}
Thread.Sleep(3000);
}
}
private void tsmiEdit_Click(object sender, EventArgs e)
{
if (SelectedFeature == null)
{
MessageBox.Show("请选择点进行查看！");
}
else
{
JKINFOBLL bllJKINFO = new JKINFOBLL();
String MDBFileName = (SysInfo.HTDBInfo[cbMaps.Text] as DBInfo).MDBPath;
try
{
Int32 iNDH = Convert.ToInt32(SelectedFeature["NDH"]);
MapApp.Entities.JKINFO oJKINFO = bllJKINFO.GetJKINFO(iNDH, MDBFileName);
EditJKINFO frmEditJKINFO = new EditJKINFO(oJKINFO);
if (frmEditJKINFO.ShowDialog() == DialogResult.OK)
{
if (bllJKINFO.EditJKINFO(frmEditJKINFO.OBJJKINFO, MDBFileName))
{
SelectedFeature["DW"] = frmEditJKINFO.OBJJKINFO.DW;
SelectedFeature["SJ"] = frmEditJKINFO.OBJJKINFO.SJ;
SelectedFeature.Style = sDefault;
foreach (DataRow dr in SysInfo.TypeDataTable.Rows)
{
int iType = Convert.ToInt32(dr["JKType"]);
if (frmEditJKINFO.OBJJKINFO.SBLX == iType)
{
SelectedFeature.Style = new MapInfo.Styles.CompositeStyle(new MapInfo.Styles.BitmapPointStyle(dr["BMPFileName"].ToString(), BitmapStyles.None, Color.Blue, 10));
break;
}
}
SelectedFeature.Table.UpdateFeature(SelectedFeature);
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}
}
catch
{
AddJKINFO frmAddJKINFO = new AddJKINFO();
if (frmAddJKINFO.ShowDialog() == DialogResult.OK)
{
Table tEditTable = (mapControl1.Map.Layers["JKINFO"] as FeatureLayer).Table;
SelectedFeature.Style = sDefault;
foreach (DataRow dr in SysInfo.TypeDataTable.Rows)
{
int iType = Convert.ToInt32(dr["JKType"]);
if (frmAddJKINFO.OBJJKINFO.SBLX == iType)
{
SelectedFeature.Style = new MapInfo.Styles.CompositeStyle(new MapInfo.Styles.BitmapPointStyle(dr["BMPFileName"].ToString(), BitmapStyles.None, Color.Blue, 10));
}
}
SelectedFeature["NDH"] = frmAddJKINFO.OBJJKINFO.NDH;
SelectedFeature["SJ"] = frmAddJKINFO.OBJJKINFO.SJ;
SelectedFeature["DW"] = frmAddJKINFO.OBJJKINFO.DW;
tEditTable.UpdateFeature(SelectedFeature);
if (bllJKINFO.AddJKINFO(frmAddJKINFO.OBJJKINFO, MDBFileName))
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}
}
}
}
void t_Tick(object sender, EventArgs e)
{
JKINFOBLL bllJKINFO = new JKINFOBLL();
String MDBFileName = (SysInfo.HTDBInfo[cbMaps.Text] as DBInfo).MDBPath;
dtAllRow = bllJKINFO.GetList(MDBFileName, "").Tables[0].Copy();
if (dtAllRow.Rows.Count <= 0)
{
return;
}
SearchInfo si = MapInfo.Data.SearchInfoFactory.SearchWhere("1=1");
si.QueryDefinition.Columns = new string[] { "*" };// new string[] { "NDH" }; //null
IResultSetFeatureCollection ifs = MapInfo.Engine.Session.Current.Catalog.Search("JKINFO", si);
foreach (MapInfo.Data.Feature f in ifs)
{
try
{
Int32 iNDH = -1;
if (f["NDH"] != null)
{
try
{
iNDH = Convert.ToInt32(f["NDH"]);
foreach (DataRow dr in dtAllRow.Rows)
{
try
{
if (iNDH == Convert.ToInt32(dr["NDH"]))
{
f["SJ"] = dr["SJ"];
f["DW"] = dr["DW"];
f.Table.UpdateFeature(f);
break;
}
}
catch
{ }
}
}
catch
{
}
}
}
catch //(Exception ex)
{
//MessageBox.Show("更新中发生错误：" + ex.Message);
}
}
//SearchInfo si = MapInfo.Data.SearchInfoFactory.SearchWhere("1=1");
//si.QueryDefinition.Columns = new string[] { "*" } ;// new string[] { "NDH" }; //null
//IResultSetFeatureCollection ifs = MapInfo.Engine.Session.Current.Catalog.Search("JKINFO", si);
//if (ifs.Count <= 0)
//{
// return;
//}
//else
//{
// //FeatureLayer lyrTemp = (FeatureLayer)mapControl1.Map.Layers["JKINFO"];
// //if (lyrTemp != null)
// //{
// // IFeatureEnumerator fen = (lyrTemp.Table as IFeatureCollection).GetFeatureEnumerator();
// // while (fen.MoveNext())
// // {
// // Feature ftemp = fen.Current;
// // try
// // {
// // Int32 iNDH = -1;
// // if (ftemp["NDH"] == null)
// // continue;
// // try
// // {
// // iNDH = Convert.ToInt32(ftemp["NDH"]);
// // foreach (DataRow dr in dtAllRow.Rows)
// // {
// // try
// // {
// // if (iNDH == Convert.ToInt32(dr["NDH"]))
// // {
// // ftemp["SJ"] = dr["SJ"];
// // ftemp["DW"] = dr["DW"];
// // ftemp.Table.UpdateFeature(ftemp);
// // break;
// // }
// // }
// // catch
// // { }
// // }
// // }
// // catch
// // {
// // }
// // }
// // catch (Exception ex)
// // {
// // MessageBox.Show("更新中发生错误：" + ex.Message);
// // }
// // }
// //}
// for (int i = 0; i < ifs.Count; i++)
// {
// try
// {
// Int32 iNDH = -1;
// if (ifs[i]["NDH"] != null)
// {
// try
// {
// iNDH = Convert.ToInt32(ifs[i]["NDH"]);
// foreach (DataRow dr in dtAllRow.Rows)
// {
// try
// {
// if (iNDH == Convert.ToInt32(dr["NDH"]))
// {
// ifs[i]["SJ"] = dr["SJ"];
// ifs[i]["DW"] = dr["DW"];
// ifs[i].Table.UpdateFeature(ifs[i]);
// break;
// }
// }
// catch
// { }
// }
// }
// catch
// {
// }
// }
// }
// catch //(Exception ex)
// {
// //MessageBox.Show("更新中发生错误：" + ex.Message);
// }
// }
//}
}
