private void simpleButton2_Click(object sender, EventArgs e)
{
if (this._trancParamClass == null)
{
MessageBox.Show("请先计算参数！");
return;
}
if (this.btnEditCountry.EditValue == null || this.buttonEdit1.EditValue == null)
{
MessageBox.Show("请选择对应坐标系！");
return;
}
bool firstSave = false;//第一次保存
if (this._wkid == -1)
{
this._wkid = Convert.ToInt32(AccessHelper.ExecuteScalar("select max (wkid) from CoordinatePara ", null)) + 1;
firstSave = true;
}
this._trancParamClass.WKID = _wkid;
this._trancParamClass.Defined = true;
this._trancParamClass.Method = "CF";
this._trancParamClass.PARAM_TYPE = "7";
this._trancParamClass.SOU_PRJ = this.btnEditCountry.Text;
this._trancParamClass.SOU_WKID = (this.btnEditCountry.EditValue as CoordProjClass).WKID;
this._trancParamClass.TAR_PRJ = this.buttonEdit1.Text;
this._trancParamClass.TAR_WKID = (this.buttonEdit1.EditValue as CoordProjClass).WKID;
DataRow datarow = this._trancParamClass.ToDatarow();
FormCoordPara coorParaFrm = new FormCoordPara(datarow);
coorParaFrm.OnTransParamSaved += new TransParamSavedHandler(coorParaFrm_OnTransParamSaved);
coorParaFrm.Text = "编辑 转换参数";
coorParaFrm.ShowDialog(this);
this.ucPosPair1.WKID = this._wkid;
this.ucPosPair1.Save();
}
void FormLoad()
{
//参数类型绑定值
string[] typeName = { "三参", "七参", "十参" };
paraTypeCmb.Properties.Items.AddRange(typeName);
paraTypeCmb.SelectedIndex = 0;
object ds = null;
object z0 = null;
if (this.Text.Contains("编辑"))
{
foreach (DataColumn colum in focusRow.Table.Columns)
{
foreach (Control control in this.Controls)
{
if (control.HasChildren)
{
foreach (Control item in control.Controls)
{
if (item.Tag != null && item.Tag.ToString().ToUpper().Equals(colum.ColumnName.ToUpper()))
{
if (item is TextEdit)
{
(item as TextEdit).EditValue = focusRow[colum.ColumnName];
}
if (item is CalcEdit)
{
(item as CalcEdit).EditValue = focusRow[colum.ColumnName];
}
if (item is TextBox)
{
(item as TextBox).Text = focusRow[colum.ColumnName].ToString();
}
if (colum.ColumnName.ToUpper().Equals("DS"))
{
ds = focusRow[colum.ColumnName];
}
if (colum.ColumnName.ToUpper().Equals("Z0"))
{
z0 = focusRow[colum.ColumnName];
}
}
}
}
}
}
if (!(ds is System.DBNull || ds is System.DBNull))
{
paraTypeCmb.SelectedIndex = 1;
}
if (!(ds is System.DBNull) && (ds is System.DBNull))
{
paraTypeCmb.SelectedIndex = 2;
}
}
if (this.Text.Contains("查看"))
{
foreach (DataColumn colum in focusRow.Table.Columns)
{
foreach (Control control in this.Controls)
{
if (control.HasChildren)
{
foreach (Control item in control.Controls)
{
if (item.Tag != null && item.Tag.ToString().ToUpper().Equals(colum.ColumnName.ToUpper()))
{
if (item is TextEdit)
{
(item as TextEdit).EditValue = focusRow[colum.ColumnName];
(item as TextEdit).Properties.ReadOnly = true;
}
if (item is TextBox)
{
(item as TextBox).Text = focusRow[colum.ColumnName].ToString();
(item as TextBox).ReadOnly = true;
}
if (item is CalcEdit)
{
(item as CalcEdit).EditValue = focusRow[colum.ColumnName];
(item as CalcEdit).Properties.ReadOnly = true;
}
if (colum.ColumnName.ToUpper().Equals("DS"))
{
ds = focusRow[colum.ColumnName];
}
if (colum.ColumnName.ToUpper().Equals("Z0"))
{
z0 = focusRow[colum.ColumnName];
}
}
}
}
}
}
if (!(ds is System.DBNull || ds is System.DBNull))
{
paraTypeCmb.SelectedIndex = 1;
}
if (!(ds is System.DBNull) && (ds is System.DBNull))
{
paraTypeCmb.SelectedIndex = 2;
}
paraTypeCmb.Properties.ReadOnly = true;
saveBtn.Enabled = false;
}
if (this.Text.Contains("新增"))
{
object maxId = AccessHelper.ExecuteScalar("select max(wkid) + 1 from CoordinatePara", null);
WKIDCalcEdit.EditValue = maxId;
}
//初始化坐标系统
CoordProjClass souprojClass = new CoordProjClass();
souprojClass.NAME = this.focusRow["SOU_PRJ"].ToString();
souprojClass.WKID = Convert.ToInt32(this.focusRow["SOU_WKID"]);
this.btnEditSou.EditValue = souprojClass;
CoordProjClass tarprojClass = new CoordProjClass();
tarprojClass.NAME = this.focusRow["TAR_PRJ"].ToString();
tarprojClass.WKID = Convert.ToInt32(this.focusRow["TAR_WKID"]);
this.btnEditTar.EditValue = tarprojClass;
}
private void saveBtn_Click(object sender, EventArgs e)
{
CheckBeforeSave();
object CoorTranName = tranNameTxtEdit.Text,
Accuracy = AccurCalcEdit.EditValue,
WKID = WKIDCalcEdit.EditValue,
AreaofUse = useAreaTxtEdit.Text,
//Method = tranMethodTxtEdit.Text,
MaximumLatitude = maxLatCalcEdit.EditValue,
MinimumLatitude = minLatCalcEdit.EditValue,
MaximumLongitude = maxLonCalcEdit.EditValue,
MinimumLongitude = minLonCalcEdit.EditValue,
dx = dxCalcEdit.EditValue,
dy = dyCalcEdit.EditValue,
dz = dzCalcEdit.EditValue,
rx = rxCalcEdit.EditValue = rxCalcEdit.Enabled ? rxCalcEdit.EditValue : "null",
ry = ryCalcEdit.EditValue = ryCalcEdit.Enabled ? ryCalcEdit.EditValue : "null",
rz = rzCalcEdit.EditValue = rzCalcEdit.Enabled ? rzCalcEdit.EditValue : "null",
ds = dsCalcEdit.EditValue = dsCalcEdit.Enabled ? dsCalcEdit.EditValue : "null",
X0 = X0CalcEdit.EditValue = X0CalcEdit.Enabled ? X0CalcEdit.EditValue : "null",
Y0 = Y0CalcEdit.EditValue = Y0CalcEdit.Enabled ? Y0CalcEdit.EditValue : "null",
Z0 = Z0CalcEdit.EditValue = Z0CalcEdit.Enabled ? Z0CalcEdit.EditValue : "null";
string countryName = string.Empty,
sou_prj = string.Empty,
tar_prj = string.Empty;
int sou_wkid = 0,
tar_wkid = 0;
if (this.btnEditCountry.EditValue != null && (CountryClass)this.btnEditCountry.EditValue != null)
{
countryName = ((CountryClass)this.btnEditCountry.EditValue).NAME;
}
if (this.btnEditSou.EditValue != null && (CoordProjClass)this.btnEditSou.EditValue != null)
{
sou_prj = ((CoordProjClass)this.btnEditSou.EditValue).NAME;
sou_wkid = ((CoordProjClass)this.btnEditSou.EditValue).WKID;
}
if (this.btnEditTar.EditValue != null && (CoordProjClass)this.btnEditTar.EditValue != null)
{
tar_prj = ((CoordProjClass)this.btnEditTar.EditValue).NAME;
tar_wkid = ((CoordProjClass)this.btnEditTar.EditValue).WKID;
}
string Method = string.Empty;
switch (paraTypeCmb.EditValue.ToString())
{
case "三参":
Method = "3";
break;
case "七参":
Method = "7";
break;
case "十参":
Method = "10";
break;
}
try
{
string sqlStr = "";
if (iParamId <= 0)
{
object maxId = AccessHelper.ExecuteScalar("select max(id) + 1 from CoordinatePara", null);
iParamId = (int)maxId;
sqlStr = string.Format("INSERT INTO CoordinatePara (CoorTranName,Accuracy,WKID,AreaofUse,Method,MaximumLatitude,MinimumLatitude,MaximumLongitude,MinimumLongitude,dx,dy,dz,rx,ry,rz,ds,X0,Y0,Z0,Defined,ID , PARAM_TYPE,SOU_PRJ,SOU_WKID,TAR_PRJ,TAR_WKID,COUNTRYNAME)"
+ "VALUES('{0}',{1},{2},'{3}','{4}',{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},'{21}','{22}',{23},'{24}',{25},'{26}')",
CoorTranName, Accuracy, WKID, AreaofUse, Method, MaximumLatitude, MinimumLatitude, MaximumLongitude, MinimumLongitude, dx, dy, dz, rx, ry, rz, ds, X0, Y0, Z0, true, Convert.ToInt32(maxId), Method, sou_prj, sou_wkid, tar_prj, tar_wkid, countryName);
}
else
{
sqlStr = string.Format("UPDATE CoordinatePara SET CoorTranName = '{0}'," +
"Accuracy = {1}," +
"WKID = {2}," +
"AreaofUse = = '{3}'," +
"method = = '{4}'," +
"MaximumLatitude = {5}," +
"MinimumLatitude = {6}," +
"MaximumLongitude = {7}," +
"MinimumLongitude = {8}," +
"dx = {9}," +
"dy = {10}," +
"dz = {11}," +
"rx = {12}," +
"ry = {13}," +
"rz = {14}," +
"ds = {15}," +
"X0 = {16}," +
"Y0 = {17}," +
"Z0 = {18}, " +
"PARAM_TYPE = '{20}', " +
"SOU_PRJ = '{21}', " +
"SOU_WKID = {22}, " +
"TAR_PRJ = '{23}', " +
"TAR_WKID = {24}, " +
"COUNTRYNAME = '{25}' " +
"WHERE ID={19}",
CoorTranName, Accuracy, WKID, AreaofUse, Method, MaximumLatitude, MinimumLatitude, MaximumLongitude, MinimumLongitude, dx, dy, dz, rx, ry, rz, ds, X0, Y0, Z0, iParamId, Method, sou_prj, sou_wkid, tar_prj, tar_wkid, countryName);
}
if (AccessHelper.ExecuteNonQuery(sqlStr, null) == 1)
{
this.Text = "编辑 转换参数";
if (this.OnTransParamSaved != null)
{
CoordTrancParamClass trancparam = new CoordTrancParamClass();
trancparam.WKID = Convert.ToInt32(WKID);
trancparam.ID = iParamId;
this.OnTransParamSaved(trancparam);
}
MessageBox.Show("保存成功！", "提示");
}
else
{
MessageBox.Show("保存失败！", "提示");
if (this.Text.Contains("新增"))
{
iParamId = 0;
}
}
}
catch (Exception err)
{
MessageBox.Show("保存失败！\t\n" + err.Message, "提示");
if (this.Text.Contains("新增"))
{
iParamId = 0;
}
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
CheckBeforeSave();
object CoorTranName = tranNameTxtEdit.Text,
Accuracy = AccurCalcEdit.EditValue,
WKID = WKIDCalcEdit.EditValue,
AreaofUse = useAreaTxtEdit.Text,
Method = tranMethodTxtEdit.Text,
MaximumLatitude = maxLatCalcEdit.EditValue,
MinimumLatitude = minLatCalcEdit.EditValue,
MaximumLongitude = maxLonCalcEdit.EditValue,
MinimumLongitude = minLonCalcEdit.EditValue,
dx = dxCalcEdit.EditValue,
dy = dyCalcEdit.EditValue,
dz = dzCalcEdit.EditValue,
rx = rxCalcEdit.EditValue = rxCalcEdit.Enabled ? rxCalcEdit.EditValue : "null",
ry = ryCalcEdit.EditValue = ryCalcEdit.Enabled ? ryCalcEdit.EditValue : "null",
rz = rzCalcEdit.EditValue = rzCalcEdit.Enabled ? rzCalcEdit.EditValue : "null",
ds = dsCalcEdit.EditValue = dsCalcEdit.Enabled ? dsCalcEdit.EditValue : "null",
X0 = X0CalcEdit.EditValue = X0CalcEdit.Enabled ? X0CalcEdit.EditValue : "null",
Y0 = Y0CalcEdit.EditValue = Y0CalcEdit.Enabled ? Y0CalcEdit.EditValue : "null",
Z0 = Z0CalcEdit.EditValue = Z0CalcEdit.Enabled ? Z0CalcEdit.EditValue : "null";
try
{
string sqlStr = "";
if (this.Text.Contains("新增"))
{
object maxId = AccessHelper.ExecuteScalar("select max(id) from CoordinatePara", null);
sqlStr = string.Format("INSERT INTO CoordinatePara (CoorTranName,Accuracy,WKID,AreaofUse,Method,MaximumLatitude,MinimumLatitude,MaximumLongitude,MinimumLongitude,dx,dy,dz,rx,ry,rz,ds,X0,Y0,Z0,Defined,ID)"
+ "VALUES('{0}',{1},{2},'{3}','{4}',{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20})",
CoorTranName, Accuracy, WKID, AreaofUse, Method, MaximumLatitude, MinimumLatitude, MaximumLongitude, MinimumLongitude, dx, dy, dz, rx, ry, rz, ds, X0, Y0, Z0, true, Convert.ToInt32(maxId) + 1);
}
if (this.Text.Contains("编辑"))
{
sqlStr = string.Format("UPDATE CoordinatePara SET CoorTranName = '{0}'," +
"Accuracy = {1}," +
"WKID = {2}," +
"AreaofUse = = '{3}'," +
"Method = = '{4}'," +
"MaximumLatitude = {5}," +
"MinimumLatitude = {6}," +
"MaximumLongitude = {7}," +
"MinimumLongitude = {8}," +
"dx = {9}," +
"dy = {10}," +
"dz = {11}," +
"rx = {12}," +
"ry = {13}," +
"rz = {14}," +
"ds = {15}," +
"X0 = {16}," +
"Y0 = {17}," +
"Z0 = {18} " +
"WHERE ID={19}",
CoorTranName, Accuracy, WKID, AreaofUse, Method, MaximumLatitude, MinimumLatitude, MaximumLongitude, MinimumLongitude, dx, dy, dz, rx, ry, rz, ds, X0, Y0, Z0, focusRow["ID"]);
}
if (AccessHelper.ExecuteNonQuery(sqlStr, null) == 1)
{
MessageBox.Show("保存成功！", "提示");
}
else
{
MessageBox.Show("保存失败！", "提示");
}
}
catch (Exception err)
{
MessageBox.Show("保存失败！\t\n" + err.Message, "提示");
}
}