private void buttonLoad_Click(object sender, EventArgs e)
{
if (innerAnyQuery.AnyQueryID == String.Empty)
innerAnyQuery.AnyQueryID = CliUtils.GetMenuID(innerAnyQuery.PackageForm);
frmAnyQuerySaveLoad faqsl = new frmAnyQuerySaveLoad(innerAnyQuery.BindingSource, "Load", innerAnyQuery.AnyQueryID);
faqsl.ShowDialog();
if (faqsl.isOK && faqsl.fileName != String.Empty)
{
String templateID = faqsl.fileName;
String text = String.Empty;
String tableName = String.Empty;
object[] param = new object[2];
param[0] = innerAnyQuery.AnyQueryID;
param[1] = templateID;
object[] myRet = CliUtils.CallMethod("GLModule", "AnyQueryLoad", param);
if (myRet != null && myRet[0].ToString() == "0")
{
text = myRet[1].ToString();
tableName = myRet[2].ToString();
}
String message = String.Empty;
if (tableName == "" || tableName != GetTableName())
{
message = SysMsg.GetSystemMessage(CliUtils.fClientLang, "Srvtools", "AnyQuery", "CheckTable");
MessageBox.Show(message);
this.DialogResult = System.Windows.Forms.DialogResult.None;
return;
}
List<Panel> tempPanel = new List<Panel>();
for (int i = 0; i < this.panel2.Controls.Count; i++)
{
if (this.panel2.Controls[i] is InfoRefButton && !(this.panel2.Controls[i] as InfoRefButton).autoPanel)
{
tempPanel.Add((this.panel2.Controls[i] as InfoRefButton).panel);
}
}
this.panel2.Controls.Clear();
Count = 0;
message = SysMsg.GetSystemMessage(CliUtils.fClientLang, "Srvtools", "AnyQuery", "ColumnValue");
String[] ColumnValue = message.Split(';');
Label labelColumn = new Label();
labelColumn.Location = new Point(124, 16);
labelColumn.Text = ColumnValue[0];
this.panel2.Controls.Add(labelColumn);
Label labelValue = new Label();
labelValue.Location = new Point(335, 16);
labelValue.Text = ColumnValue[1];
this.panel2.Controls.Add(labelValue);
Label conditionLabel = new Label();
conditionLabel.Text = ColumnValue[2];
conditionLabel.Location = new Point(477, 16);
ComboBox cbCondition = new ComboBox();
cbCondition.Name = "cbCondition";
cbCondition.Location = new Point(557, 13);
cbCondition.Size = new Size(54, 20);
cbCondition.Items.AddRange(new String[] { "AND", "OR" });
cbCondition.DropDownStyle = ComboBoxStyle.DropDownList;
cbCondition.SelectedIndex = 0;
InfoDataSet ids = null;
if (innerAnyQuery.BindingSource != null)
{
ids = innerAnyQuery.BindingSource.DataSource as InfoDataSet;
XmlDocument DBXML = new XmlDocument();
DBXML.LoadXml(text);
XmlNode aNode = DBXML.DocumentElement.FirstChild;
while (aNode != null)
{
Count++;
cbCondition.Text = CreateColumns(ids, aNode, tempPanel);
aNode = aNode.NextSibling;
}
}
this.panel2.Controls.Add(cbCondition);
this.panel2.Controls.Add(conditionLabel);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (innerAnyQuery.AnyQueryID == String.Empty)
innerAnyQuery.AnyQueryID = CliUtils.GetMenuID(innerAnyQuery.PackageForm);
frmAnyQuerySaveLoad faqsl = new frmAnyQuerySaveLoad(innerAnyQuery.BindingSource, "Save", innerAnyQuery.AnyQueryID);
faqsl.ShowDialog();
if (faqsl.isOK && faqsl.fileName != String.Empty)
{
String templateID = faqsl.fileName;
String text = String.Empty;
String xml = GetSaveXML();
object[] param = new object[4];
param[0] = innerAnyQuery.AnyQueryID;
param[1] = templateID;
param[2] = xml;
param[3] = GetTableName();
object[] myRet = CliUtils.CallMethod("GLModule", "AnyQuerySave", param);
if (myRet != null && myRet[0].ToString() == "0")
{
string message = SysMsg.GetSystemMessage(CliUtils.fClientLang, "Srvtools", "AnyQuery", "SaveSuccess");
MessageBox.Show(message);
}
}
}