//全部删除菜单响应
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;
if (Tablename.Contains("."))
{
Tablename = Tablename.Split('.')[1];//处理SDE表
}
FaceControl pFaceControl = (FaceControl)(m_Hook.MainUserControl);
if (pGridControl.DataSource == null)
{
return;
}
//删除数据时要询问一次
if (DevComponents.DotNetBar.MessageBoxEx.Show("确定要全部删除吗？删除后不可恢复！", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
try
{
if (GeoDataCenterFunLib.LogTable.m_sysTable == null)
{
return;
}
Exception ex = null;
LogTable.m_sysTable.DeleteRows(Tablename, "", out ex);//删除
if (ex != null)
{
throw new Exception("删除全部数据失败！", ex);
}
}
catch (Exception pEx)
{
DevComponents.DotNetBar.MessageBoxEx.Show(pEx.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
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;
}
/////
if (this.WriteLog)
{
Plugin.LogTable.Writelog(Caption);//xisheng 2011.07.09 增加日志
}
//OleDbConnection mycon = new OleDbConnection(connstr); //定义OleDbConnection对象实例并连接数据库
////构造删除数据的语句
//string strExp = "delete from " + Tablename ;
//OleDbCommand aCommand = new OleDbCommand(strExp, mycon);
//mycon.Open();
////执行删除语句
//aCommand.ExecuteNonQuery();
//mycon.Close();
////再次初始化datagridview控件
//pfacecontrol.InitDataInfoList(Tablename );
//if (m_Hook != null)
//{
// LogFile log = new LogFile(m_Hook.tipRichBox, m_Hook.strLogFilePath);
// if (log != null)
// {
// log.Writelog("数据全部删除");
// }
//}
/* 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;
if (Tablename.Contains("."))
{
Tablename = Tablename.Split('.')[1];//处理SDE表
}
FaceControl pFaceControl = (FaceControl)(m_Hook.MainUserControl);
if (pGridControl.DataSource == null)
{
return;
}
//如果未选中记录...
if (pGridControl.SelectedRows.Count == 0)
{
DevComponents.DotNetBar.MessageBoxEx.Show("未选中记录！");
return;
}
int k = pGridControl.SelectedRows.Count;
//删除数据时，要询问一次
if (pGridControl.SelectedRows.Count > 0)
{
if (DevComponents.DotNetBar.MessageBoxEx.Show("确定要删除选中的记录吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
//OleDbConnection mycon = new OleDbConnection(connstr); //定义OleDbConnection对象实例并连接数据库
//string strExp = "";
//OleDbCommand aCommand = new OleDbCommand(strExp, mycon);
//mycon.Open();
//int i = 0, j = 0;
if (GeoDataCenterFunLib.LogTable.m_sysTable == null)
{
return;
}
Exception err;
ITable pTable = LogTable.m_sysTable.OpenTable(Tablename, out err);
if (pTable == null)
{
//MessageBox.Show(err.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
ErrorHandle.ShowFrmErrorHandle("提示", err.Message);
return;//若日志表不存在，返回null
}
if (pGridControl.SelectedRows.Count > 0)
{
string objectID = pTable.OIDFieldName;
string strExp = objectID + " IN (";
for (int h = 0; h < pGridControl.SelectedRows.Count; h++)
{
//构造删除记录的语句
for (int i = 0; i < pGridControl.ColumnCount; i++)
{
if (pGridControl.Columns[i].Name.ToUpper().Equals("ID"))
{
strExp += pGridControl.SelectedRows[h].Cells[i].Value.ToString() + ",";
}
}
}
strExp = strExp.Substring(0, strExp.Length - 1);
strExp += ")";
//执行删除记录的语句段
IWorkspace pWorkspace = LogTable.m_gisDb.WorkSpace;
ITransactions pTransactions = (ITransactions)pWorkspace;
try
{
if (!pTransactions.InTransaction)
{
pTransactions.StartTransaction();
}
}
catch (Exception eX)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", eX.Message);
return;
}
Exception exError;
if (!LogTable.m_sysTable.DeleteRows(Tablename, strExp, out exError))
{
ErrorHandle.ShowFrmErrorHandle("提示", "删除记录失败！" + exError.Message);
return;
}
try
{
if (pTransactions.InTransaction)
{
pTransactions.CommitTransaction();
}
}
catch (Exception eX)
{
}
}
//再次初始化datagridview控件
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;
}
/////
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 bool Parse()
{
var temp = this.Content;
var results = new List <string>();
var potentialResults = new Stack <string>();
var prefix = string.Empty;
var parses = Instructions.Split('|');
foreach (var parse in parses)
{
var colon = parse.IndexOf(':');
if (colon > -1)
{
var cmd = parse.Substring(0, colon);
var part = parse.Substring(colon + 1);
var save = cmd.Contains("?");
var nextToken = cmd.Contains("&");
var prefixed = cmd.Contains("+");
var restore = cmd.Contains("^");
if (nextToken)
{
results.Add(temp);
temp = "";
}
if (prefixed)
{
prefix += temp;
temp = string.Empty;
}
if (restore)
{
temp = potentialResults.Count > 0 ? potentialResults.Pop() : this.Content;
}
if (save)
{
potentialResults.Push(prefix + temp);
prefix = string.Empty;
}
var contains = temp.Contains(part);
if (cmd.Contains("i"))
{
if (!CheckDoc(temp))
{
return(false);
}
nodes = doc.SelectNodes(part);
IsDictionary = true;
}
else if (cmd.Contains("k"))
{
keypart = part;
}
else if (cmd.Contains("v"))
{
valuepart = part;
}
else if (cmd.Contains("table") && nodes != null)
{
if (part.Contains("name="))
{
Tablename = part.Substring(part.IndexOf("name=") + 5);
var j = Tablename.IndexOf(";");
if (j > -1)
{
Tablename = Tablename.Substring(0, j);
}
}
foreach (var node in nodes)
{
IXmlNode key = null;
Windows.Data.Xml.Dom.XmlNodeList valueset = null;
try
{
key = node.SelectSingleNode(keypart);
valueset = node.SelectNodes(valuepart);
}
catch (Exception)
{
//skip if not matching
continue;
}
if (!string.IsNullOrWhiteSpace(key?.InnerText))
{
if (!string.IsNullOrWhiteSpace(key.InnerText) && !dictionary.ContainsKey(key.InnerText))
{
var values = new StringBuilder();
var count = valueset.Count();
foreach (var value in valueset)
{
values.Append(value.InnerText);
if (--count > 0)
{
values.Append("~");
}
}
dictionary.Add(key.InnerText, values.ToString());
}
}
}
Debug.WriteLine(string.Format("Table {0} saved count = {1}", Tablename, dictionary.Count));
}
else if (cmd.Contains("R"))
{
temp = temp.RightOf(part);
}
else if (cmd.Contains("L"))
{
temp = temp.LeftOf(part);
}
else if (cmd.Contains("B"))
{
temp = temp.Between(part);
}
else if (cmd.Contains("!"))
{
temp = part;
}
else if (cmd.Contains("J") || cmd.Contains("j"))
{
var jParsed = JToken.Parse(temp);
if (jParsed != null)
{
var jToken = jParsed.SelectToken(part);
if (jToken != null)
{
if (cmd.Contains("j"))
{
temp = ((JProperty)jToken).Name;
if (cmd.Contains("J"))
{
temp += ":'" + jToken.Value <string>() + "'";
}
}
else
{
temp = jToken.Value <string>();
}
}
else
{
temp = string.Empty;
}
}
else
{
temp = string.Empty;
}
}
else if (cmd.Contains("X"))
{
var expr = new Regex(part);
var matches = expr.Match(part);
var matchResults = new StringBuilder();
while (matches.Success)
{
contains = true;
matchResults.Append(matches.Value);
matchResults.Append("~");
matches = matches.NextMatch();
}
temp = matchResults.ToString();
if (!string.IsNullOrWhiteSpace(temp))
{
temp = temp.Substring(0, temp.Length - 1);
}
}
else if (cmd.Contains("F"))
{
results.Add(prefix + temp);
prefix = string.Empty;
temp = string.Format(part, results.ToArray());
results.Clear();
}
if (save && !contains)
{
temp = potentialResults.Pop();
}
}
if (string.IsNullOrWhiteSpace(temp))
{
break;
}
}
if (!string.IsNullOrWhiteSpace(temp))
{
results.Add(prefix + temp);
prefix = string.Empty;
}
var builder = new StringBuilder();
for (var i = 0; i < results.Count; i++)
{
builder.Append(results[i]);
if (i < results.Count - 1)
{
builder.Append("|");
}
}
Result = builder.Length == 0 ? string.Empty : builder.ToString();
return(true);
}
