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(); } }