private void txtContent_DoubleClick(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
TextBox txt = (TextBox)sender;
if (rbSchedule.Checked)
{
frmViewText frm = new frmViewText(clsTranslate.TranslateString("Action Schedule"), txt.Text.Trim());
frm.ShowDialog();
}
else
{
string traceflaglist = string.Empty;
if (rbCustomerLog.Checked)
{
traceflaglist = "1";
}
dalCustomerLog dal = new dalCustomerLog();
BindingCollection <modCustomerLog> list = dal.GetIList(string.Empty, string.Empty, string.Empty, txtSalesMan.Text, traceflaglist, ((TextBox)sender).Tag.ToString(), DateTime.Parse(txt.Tag.ToString()).AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd HH:mm:ss"), out Util.emsg);
if (list != null)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Customer Log"), list);
frm.ShowDialog();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void toolExecute_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSql.Text.Trim()))
{
return;
}
try
{
this.Cursor = Cursors.WaitCursor;
CloseAll();
string[] sql;
if (txtSql.SelectionLength == 0)
{
sql = txtSql.Text.Trim().Split(';');
}
else
{
sql = txtSql.SelectedText.Trim().Split(';');
}
for (int i = 0; i < sql.Length; i++)
{
if (!string.IsNullOrEmpty(sql[i].Trim()))
{
string[] f = sql[i].Split(' ');
string tablename = string.Empty;
switch (f[0].ToUpper().Trim())
{
case "SELECT":
try
{
for (int k = 0; k < f.Length; k++)
{
if (f[k].ToUpper().Trim() == "FROM")
{
if (f.Length > k + 1)
{
tablename = f[k + 1];
}
break;
}
}
DataSet ds = SqlHelper.ExecuteDs(sql[i]);
if (ds != null)
{
frmViewList frm = new frmViewList((i + 1).ToString() + ".Select " + tablename, ds);
ShowMDIChild(frm, frm);
}
}
catch (Exception ex)
{
frmViewText frm = new frmViewText((i + 1).ToString() + ".Select " + tablename, sql[i] + "\r\n\r\n" + ex.Message.ToString());
ShowMDIChild(frm, frm);
}
break;
case "DELETE":
case "TRUNCATE":
case "DROP":
frmViewText frmt = new frmViewText(i.ToString(), "You are not permitted to operater like this!");
ShowMDIChild(frmt, frmt);
break;
case "INSERT":
case "UPDATE":
try
{
for (int k = 0; k < f.Length; k++)
{
if (f[k].ToUpper().Trim() == "FROM")
{
if (f.Length > k + 1)
{
tablename = f[k + 1];
}
break;
}
}
int iRet = SqlHelper.ExecuteNonQuery(sql[i]);
if (iRet >= 0)
{
frmViewText frme = new frmViewText((i + 1).ToString() + "." + f[0] + " " + tablename, sql[i] + "\r\n\r\n Execute Success");
ShowMDIChild(frme, frme);
}
}
catch (Exception ex)
{
frmViewText frme = new frmViewText((i + 1).ToString() + "." + f[0] + " " + tablename, sql[i] + "\r\n\r\n" + ex.Message.ToString());
ShowMDIChild(frme, frme);
}
break;
default:
frmViewText frmd = new frmViewText(i.ToString(), "You are not permitted to operater like this!");
ShowMDIChild(frmd, frmd);
break;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
