private void frmReportEx_KeyDown(object sender, KeyEventArgs e)
{
if (e.Control == true && e.KeyCode == Keys.F9)
{
Common.frmSQL mySQL = new Common.frmSQL();
mySQL.MeSQL.Text = strQuerySQL;
if (mySQL.ShowDialog() == DialogResult.OK)
{
strQuerySQL = mySQL.MeSQL.Text;
if (DataBind() == 0)
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
string strSQL = "select * from t_UserReport where F_Name = '" + strName + "'";
DataSet ds = myHelper.GetDs(strSQL);
ds.Tables[0].Rows[0]["F_SQL"] = strQuerySQL;
myHelper.SaveData(ds, strSQL);
}
}
mySQL.Dispose();
}
if (e.KeyCode == Keys.F5)
{
SaveFieldFormat();
}
if (e.KeyCode == Keys.F7)
{
tbSet_Click(null, null);
}
}
private void FormKeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F7 && DataLib.SysVar.strUGroup == "超级用户")
{
SetGridFormat();
}
if (e.KeyCode == Keys.F5 && DataLib.SysVar.strUGroup == "超级用户")
{
DataLib.sysClass.SaveGridToDB(gvList, ReportTag, 0);
//SaveFieldFormat();
}
if (e.Control == true && e.KeyCode == Keys.F9 && DataLib.SysVar.strUGroup == "超级用户")
{
Common.frmSQL mySQL = new Common.frmSQL();
mySQL.MeSQL.Text = strQuerySQL;
if (mySQL.ShowDialog() == DialogResult.OK)
{
strQuerySQL = mySQL.MeSQL.Text;
if (BindData() == 0)
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
string strSQL = "select * from t_SQL where F_Class = '" + ReportTag + "' and F_Tag = 0";
DataSet ds = myHelper.GetDs(strSQL);
if (ds.Tables[0].Rows.Count == 0)
{
DataRow drNew = ds.Tables[0].NewRow();
drNew["F_Class"] = ReportTag;
drNew["F_Tag"] = 0;
drNew["F_SQL"] = strQuerySQL;
ds.Tables[0].Rows.Add(drNew);
}
else
{
ds.Tables[0].Rows[0]["F_SQL"] = strQuerySQL;
}
myHelper.SaveData(ds, strSQL);
}
}
mySQL.Dispose();
}
}
