private void MenuItemAddRcd_Click(object sender, EventArgs e)
{ //added by chulili 2011-02-24 添加记录功能
TableForm myTableForm = new TableForm(gridControl, m_connstr, m_TableName);
myTableForm.InitForm("ADD");
myTableForm.ShowDialog();
OleDbCommandBuilder builder = new OleDbCommandBuilder(m_Adapter);
//将数据提交到数据库更新
try
{
m_Adapter.Update(m_dataTable);
//提交后重新获取数据，避免ID列的值与数据库中不一致
m_dataTable.Clear();
m_Adapter.Fill(m_dataTable);
gridControl.DataSource = null;
gridControl.DataSource = m_dataTable;
//gridControl.Update();
}
catch (System.Exception m)
{
Console.WriteLine(m.Message);
}
}
/// <summary>
/// 增加双击启动编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridControl_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (gridControl.DataSource == null)
{
return;
}
//如果未选中记录。。。
if (gridControl.SelectedRows.Count == 0)
{
MessageBox.Show("未选中记录！");
return;
}
//如果选中多行记录。。。
if (gridControl.SelectedRows.Count > 1)
{
MessageBox.Show("仅可修改一行！");
return;
}
int idx = gridControl.SelectedRows[0].Index;//yjl20111103 add
//初始化修改记录对话框
//初始化添加记录对话框
TableForm myTableForm = new TableForm(gridControl, m_connstr, m_TableName);
myTableForm.InitForm("MODIFY");
myTableForm.ShowDialog();
//记录修改后再次初始化dataview控件
InitDataInfoList(m_TableName);
////ZQ 20111017 add 及时更新数据字典
switch (m_TableName)
{
case "属性对照表":
SysCommon.ModField.InitNameDic(Plugin.ModuleCommon.TmpWorkSpace, SysCommon.ModField._DicFieldName, "属性对照表");
break;
case "标准图层代码表":
SysCommon.ModField.InitLayerNameDic(Plugin.ModuleCommon.TmpWorkSpace, SysCommon.ModField._DicLayerName);
break;
//default:
// ///ZQ 20111020 add 增加重启提示
// MessageBox.Show("添加的记录只有应用系统重启以后才能生效！","提示！");
// break;
}
//yjl20111103 add
if (gridControl.Rows.Count > idx)
{
//取消默认的第1行选中
gridControl.Rows[0].Selected = false;
//设置选择行
gridControl.Rows[idx].Selected = true;
//设置当前行
gridControl.CurrentCell = gridControl.Rows[idx].Cells[0];
}
/////
Plugin.LogTable.Writelog("修改记录");//xisheng 2011.07.09 增加日志
}
private void MenuItemModifyRcd_Click(object sender, EventArgs e)
{ //added by chulili 2011-02-24 修改记录功能
if (gridControl.SelectedRows.Count == 0)
{
MessageBox.Show("未选中记录！");
return;
}
if (gridControl.SelectedRows.Count > 1)
{
MessageBox.Show("仅可修改一行！");
return;
}
TableForm myTableForm = new TableForm(gridControl, m_connstr, m_TableName);
myTableForm.InitForm("MODIFY");
myTableForm.ShowDialog();
InitDataInfoList(m_TableName);
//OleDbCommandBuilder builder = new OleDbCommandBuilder(m_Adapter);
//////将数据提交到数据库更新
//try
//{
// m_Adapter.Update(m_dataTable);
// //提交后重新获取数据，避免ID列的值与数据库中不一致
// m_dataTable.Clear();
// m_Adapter.Fill(m_dataTable);
// gridControl.DataSource = null;
// gridControl.DataSource = m_dataTable;
//}
//catch (System.Exception m)
//{
// Console.WriteLine(m.Message);
//}
}
//添加记录菜单响应
public override void OnClick()
{
if (m_Hook.GridCtrl == null)
{
return;
}
FaceControl pfacecontrol = (FaceControl)m_Hook.MainUserControl;
DataGridView pGridControl = m_Hook.GridCtrl;
if (pfacecontrol.getEditable() == false)
{
return;
}
string connstr, Tablename;
//获取数据库连接串和表名
connstr = pfacecontrol.m_connstr;
Tablename = pfacecontrol.m_TableName;
FaceControl pFaceControl = (FaceControl)(m_Hook.MainUserControl);
if (pGridControl.DataSource == null)
{
return;
}
//如果未选中记录。。。
if (pGridControl.SelectedRows.Count == 0)
{
MessageBox.Show("未选中记录！");
return;
}
//如果选中多行记录。。。
if (pGridControl.SelectedRows.Count > 1)
{
MessageBox.Show("仅可修改一行！");
return;
}
int idx = pGridControl.SelectedRows[0].Index;//yjl20111103 add
//初始化修改记录对话框
TableForm myTableForm = new TableForm(pGridControl, connstr, Tablename);
myTableForm.InitForm("MODIFY");
myTableForm.ShowDialog();
//记录修改后再次初始化dataview控件
pfacecontrol.InitDataInfoList(Tablename);
////ZQ 20111017 add 及时更新数据字典
switch (Tablename)
{
case "属性对照表":
SysCommon.ModField.InitNameDic(Plugin.ModuleCommon.TmpWorkSpace, SysCommon.ModField._DicFieldName, "属性对照表");
break;
case "标准图层代码表":
SysCommon.ModField.InitLayerNameDic(Plugin.ModuleCommon.TmpWorkSpace, SysCommon.ModField._DicLayerName);
break;
//default:
// ///ZQ 20111020 add 增加重启提示
// MessageBox.Show("修改的记录只有应用系统重启以后才能生效！", "提示！");
// break;
}
//yjl20111103 add
if (pGridControl.Rows.Count > idx)
{
//取消默认的第1行选中
pGridControl.Rows[0].Selected = false;
//设置选择行
pGridControl.Rows[idx].Selected = true;
//设置当前行
pGridControl.CurrentCell = pGridControl.Rows[idx].Cells[0];
}
/////
if (this.WriteLog)
{
Plugin.LogTable.Writelog(Caption);//xisheng 2011.07.09 增加日志
}
/* Exception eError;
* AddGroup frmGroup = new AddGroup();
* if (frmGroup.ShowDialog() == DialogResult.OK)
* {
* ModuleOperator.DisplayRoleTree("", m_Hook.RoleTree, ref ModData.gisDb, out eError);
* if (eError != null)
* {
* ErrorHandle.ShowFrmError("提示", eError.Message);
* return;
* }
* }
*/
}
//添加记录菜单响应
public override void OnClick()
{
if (m_Hook.GridCtrl == null)
{
return;
}
FaceControl pfacecontrol = (FaceControl)m_Hook.MainUserControl;
DataGridView pGridControl = m_Hook.GridCtrl;
if (pfacecontrol.getEditable() == false)
{
return;
}
string connstr, Tablename;
//获取数据库连接串和表名
connstr = pfacecontrol.m_connstr;
Tablename = pfacecontrol.m_TableName;
FaceControl pFaceControl = ( FaceControl )(m_Hook.MainUserControl);
if (pGridControl.DataSource == null)
{
return;
}
//初始化添加记录对话框
TableForm myTableForm = new TableForm(pGridControl, connstr, Tablename);
myTableForm.InitForm("ADD");
DialogResult result = myTableForm.ShowDialog();
if (result == DialogResult.OK) //changed by xisheng 2011.06.16
{ //记录添加后再次初始化dataview控件
pfacecontrol.InitDataInfoList(Tablename, true);
}
else
{
pfacecontrol.InitDataInfoList(Tablename, false);
}
////ZQ 20111017 add 及时更新数据字典
switch (Tablename)
{
case "属性对照表":
SysCommon.ModField.InitNameDic(Plugin.ModuleCommon.TmpWorkSpace, SysCommon.ModField._DicFieldName, "属性对照表");
break;
case "标准图层代码表":
SysCommon.ModField.InitLayerNameDic(Plugin.ModuleCommon.TmpWorkSpace, SysCommon.ModField._DicLayerName);
break;
//default:
// ///ZQ 20111020 add 增加重启提示
// MessageBox.Show("添加的记录只有应用系统重启以后才能生效！","提示！");
// break;
}
/////
if (this.WriteLog)
{
Plugin.LogTable.Writelog(Caption);//xisheng 2011.07.09 增加日志
}
//OleDbCommandBuilder builder = new OleDbCommandBuilder(pFaceControl.m_Adapter );
////将数据提交到数据库更新
//try
//{
// pFaceControl.m_Adapter.Update(pFaceControl.m_dataTable);
// //提交后重新获取数据
// pFaceControl.m_dataTable.Clear();
// pFaceControl.m_Adapter.Fill(pFaceControl.m_dataTable);
// pGridControl.DataSource = null;
// pGridControl.DataSource = pFaceControl.m_dataTable;
// //gridControl.Update();
//}
//catch (System.Exception m)
//{
// Console.WriteLine(m.Message);
//}
//pGridControl = null;
//pFaceControl = null;
/* Exception eError;
* AddGroup frmGroup = new AddGroup();
* if (frmGroup.ShowDialog() == DialogResult.OK)
* {
* ModuleOperator.DisplayRoleTree("", m_Hook.RoleTree, ref ModData.gisDb, out eError);
* if (eError != null)
* {
* ErrorHandle.ShowFrmError("提示", eError.Message);
* return;
* }
* }
*/
}