/// <summary>
/// 插入条件项
/// </summary>
public void InsertWhereItem()
{
WhereItem wi = null;
using (frmQueryWhere whereCfg = new frmQueryWhere())
{
wi = whereCfg.ShowWhereItem(_dbHelper, _sysParList, "", this);
}
if (wi == null)
{
return;
}
if (string.IsNullOrEmpty(wi.SourceFmt))
{
return;
}
rtbSql.SelectedText = wi.SourceFmt;
qcReview.LoadSqlDesign(rtbSql.Text);
rtbPreview.Text = qcReview.Query.TestSql();
}
private void rtbSql_DoubleClick(object sender, EventArgs e)
{
try
{
int mouseIndex = rtbSql.SelectionStart;
string tmp = rtbSql.Text.Substring(0, mouseIndex);
int indexLeftStart = tmp.LastIndexOf("<wi=");
int indexLeftEnd = tmp.IndexOf("/wi>", indexLeftStart + 1);
int leftLength = tmp.Length;
tmp = rtbSql.Text.Substring(mouseIndex);
int indexRightStart = tmp.IndexOf("<wi=");
int indexRightEnd = tmp.IndexOf("/wi>");
if (indexRightStart <= 0)
{
indexRightStart = 99999999;
}
if (indexLeftStart >= 0 && indexLeftStart > indexLeftEnd && indexRightEnd >= 0 && indexRightEnd < indexRightStart)
{
rtbSql.SelectionStart = indexLeftStart;
rtbSql.SelectionLength = leftLength + indexRightEnd - indexLeftStart + 4;
}
else
{
return;
}
string oldFmt = rtbSql.SelectedText;
if (string.IsNullOrEmpty(oldFmt))
{
return;
}
frmQueryWhere wi = new frmQueryWhere();
WhereItem result = wi.ShowWhereItem(_dbHelper, _sysParList, oldFmt, this);
if (result == null)
{
return;
}
string whereItemFmt = result.SaveWhereToString();
if (string.IsNullOrEmpty(whereItemFmt))
{
return;
}
rtbSql.SelectedText = whereItemFmt; // rtbSql.Text.Replace(oldFmt, result);
}
catch (Exception ex)
{
MsgBox.ShowException(ex, this);
}
}