void InitControl()
{
treeState.DataSource = CommonClass.CountryNameTable;
treeState.Columns["REGION"].Visible = false;
treeState.Columns["NAME"].Visible = false;
treeState.Columns["ENNAME"].Visible = false;
treeState.Columns["CONTINENT"].Visible = false;
treeState.KeyFieldName = "ID";
treeState.ParentFieldName = "PARID";
treeState.Text = "";
treeState.BestFitColumns(true);
////国家名称绑定值
//countryNameTable = AccessHelper.ExecuteDataTable("select NAME from CountryName order by ENNAME ", null);
//List<string> names = new List<string>();
//foreach (DataRow row in countryNameTable.Rows)
//{
// if (!string.IsNullOrEmpty(row["NAME"].ToString()))
// names.Add(row["NAME"].ToString());
//}
//nameArray = names.ToArray();
//countryNameCmb.Properties.Items.AddRange(nameArray);
////参数类型绑定值
//string[] typeName = { "三参", "七参", "十参" };
//paraTypeCmb.Properties.Items.AddRange(typeName);
//坐标系列表绑定值
coorParaTable = AccessHelper.ExecuteDataTable("select * from CoordinatePara", null);
paraGridControl.DataSource = coorParaTable;
paraCountLbl.Text = string.Format("共有{0}条记录", coorParaTable.Rows.Count);
this.ucCoorSystem1.OnPrjSelected += new PrjSelectedHandler(ucCoorSystem1_OnPrjSelected);
}
private DataTable GetPosPair(int wkid)
{
string sql = "select * from T_POS_PAIR where wkid = " + wkid;
DataTable dt = AccessHelper.ExecuteDataTable(sql, null);
return(dt);
}
public static DataTable GetCoorSystemTable(string filter)
{
DataTable
coorSystemtb = AccessHelper.ExecuteDataTable("select * from CoordinateSystem where " + filter + " order by ID", null);
return(coorSystemtb);
}
//private void resetBtn_Click(object sender, EventArgs e)
//{
// countryNameCmb.Text = "";
// countryNameCmb.ClosePopup();
// paraTypeCmb.Text = "";
// gridView1.ActiveFilterString = null;
// paraCountLbl.Text = string.Format("共有{0}条记录", gridView1.RowCount);
//}
private void addBtn_Click(object sender, EventArgs e)
{
DataRow datarow = this.gridView1.GetFocusedDataRow();
FormCoordPara coorParaFrm = new FormCoordPara(datarow);
coorParaFrm.Text = "新增 转换参数";
coorParaFrm.ShowDialog(this);
paraGridControl.DataSource = AccessHelper.ExecuteDataTable("select * from CoordinatePara", null);
Search();
}
void InitControl()
{
treeState.KeyFieldName = "ID";
treeState.ParentFieldName = "PARID";
treeState.PreviewFieldName = "ITRF_NAME";
treeState.Text = "";
treeState.DataSource = CommonClass.ITRFTable;
treeState.BestFitColumns(true);
//坐标系列表绑定值
ITRF_PARATable = AccessHelper.ExecuteDataTable("select * from VW_ITRF ORDER BY PARA_ID ", null);
paraGridControl.DataSource = ITRF_PARATable;
paraCountLbl.Text = string.Format("共有{0}条记录", ITRF_PARATable.Rows.Count);
}
private void editBtn_Click(object sender, EventArgs e)
{
DataRow datarow = this.gridView1.GetFocusedDataRow();
if (!(bool)datarow["Defined"])
{
MessageBox.Show("非自定义参数不可编辑!", "提示");
return;
}
FormCoordPara coorParaFrm = new FormCoordPara(datarow);
coorParaFrm.Text = "编辑 转换参数";
coorParaFrm.ShowDialog(this);
paraGridControl.DataSource = AccessHelper.ExecuteDataTable("select * from CoordinatePara", null);
Search();
}
void InitControl()
{
//国家名称绑定值
countryNameTable = AccessHelper.ExecuteDataTable("select NAME from CountryName", null);
List <string> names = new List <string>();
foreach (DataRow row in countryNameTable.Rows)
{
names.Add(row["NAME"].ToString());
}
nameArray = names.ToArray();
countryNameCmb.Properties.Items.AddRange(nameArray);
//参数类型绑定值
string[] typeName = { "三参", "七参", "十参" };
paraTypeCmb.Properties.Items.AddRange(typeName);
//坐标系列表绑定值
coorParaTable = AccessHelper.ExecuteDataTable("select * from CoordinatePara", null);
paraGridControl.DataSource = coorParaTable;
paraCountLbl.Text = string.Format("共有{0}条记录", coorParaTable.Rows.Count);
}
void frmPrj_OnPrjSelected1(object Project)
{
ClearMidProj();
ShowMidProj(false);
//throw new NotImplementedException();
btnEditTarPrj.EditValue = Project;
this.cmbTransPara.Properties.Items.Clear();
this.cmbTransPara2.Properties.Items.Clear();
DataTable coorParaTable = AccessHelper.ExecuteDataTable(string.Format("select * from CoordinatePara where ( SOU_WKID ={0} and TAR_WKID = {1} ) OR ( SOU_WKID ={1} and TAR_WKID = {0} )",
(btnEditSouPrj.EditValue as CoordProjClass).WKID, (btnEditTarPrj.EditValue as CoordProjClass).WKID), null);
if (coorParaTable == null || coorParaTable.Rows.Count == 0)//没有直接转换关系，则尝试中转
{
coorParaTable = AccessHelper.ExecuteDataTable(string.Format("select sou_wkid , tar_wkid from CoordinatePara where ( SOU_WKID ={0} ) OR ( TAR_WKID = {0} )",
(btnEditSouPrj.EditValue as CoordProjClass).WKID), null);
if (coorParaTable == null || coorParaTable.Rows.Count == 0)
{
return;
}
string wkids = string.Empty;
for (int i = 0; i < coorParaTable.Rows.Count; i++)
{
if ((btnEditSouPrj.EditValue as CoordProjClass).WKID.ToString() == coorParaTable.Rows[i]["sou_wkid"].ToString())
{
wkids += coorParaTable.Rows[i]["tar_wkid"].ToString() + ",";
}
else
{
wkids += coorParaTable.Rows[i]["sou_wkid"].ToString() + ",";
}
}
wkids = wkids.Trim(',');
coorParaTable = AccessHelper.ExecuteDataTable(string.Format("select sou_wkid , tar_wkid from CoordinatePara where ( SOU_WKID in ({0} ) and TAR_WKID = {1} ) OR ( SOU_WKID ={1} and TAR_WKID in ( {0} ) )",
wkids, (btnEditTarPrj.EditValue as CoordProjClass).WKID), null);
if (coorParaTable == null || coorParaTable.Rows.Count == 0)
{
return;
}
string midProjid = coorParaTable.Rows[0]["sou_wkid"].ToString() == (btnEditTarPrj.EditValue as CoordProjClass).WKID.ToString() ?
coorParaTable.Rows[0]["tar_wkid"].ToString() : coorParaTable.Rows[0]["sou_wkid"].ToString();
//获取第一条，作为中转坐标系统
DataTable midProjdt = CommonClass.GetCoorSystemTable("wkid = " + midProjid);
CoordProjClass souprojClass = new CoordProjClass();
souprojClass.NAME = midProjdt.Rows[0]["NAME"].ToString();
souprojClass.WKID = Convert.ToInt32(midProjid);
souprojClass.DEFINITION = midProjdt.Rows[0]["DEFINITION"].ToString();
this.txtMidProj.Text = souprojClass.NAME;
this.txtMidProj.Tag = souprojClass;
coorParaTable = AccessHelper.ExecuteDataTable(string.Format("select * from CoordinatePara where ( SOU_WKID ={0} and TAR_WKID = {1} ) OR ( SOU_WKID ={1} and TAR_WKID = {0} )",
(btnEditSouPrj.EditValue as CoordProjClass).WKID, midProjid), null);
DataTable coorParaTable2 = AccessHelper.ExecuteDataTable(string.Format("select * from CoordinatePara where ( SOU_WKID ={0} and TAR_WKID = {1} ) OR ( SOU_WKID ={1} and TAR_WKID = {0} )",
(btnEditTarPrj.EditValue as CoordProjClass).WKID, midProjid), null);
for (int i = 0; i < coorParaTable2.Rows.Count; i++)
{
this.cmbTransPara2.Properties.Items.Add(new CoordTrancParamClass(coorParaTable2.Rows[i]));
}
ShowMidProj(true);
}
for (int i = 0; i < coorParaTable.Rows.Count; i++)
{
this.cmbTransPara.Properties.Items.Add(new CoordTrancParamClass(coorParaTable.Rows[i]));
}
//buttonEdit1.Tag = Project;
//btnEditSou.Text = (Project as CoordProjClass).NAME;
}
