private void FrmMain_Load(object sender, EventArgs e) { DBConnection conn = null; try { dteBegin.DateTime = dteEnd.DateTime = DateTime.Now; string sql = StoredProcedure + "@CMD='GET_MC'"; conn = new DBConnection(connectionString); DBResult result = conn.SelectQuery(sql); using (DataTable dt = result.getDataTable()) { if (dt.Rows.Count > 0) { Meteorite.Controls.ControlsUtils.BindLookUpEdit(lueMC, dt, "MC_NO", "MC_NO", false); } } mnuOptions.Checked = ReadSavedTestPoints; seCopy.EditValue = NumberOfCopy; bool no_printer = true; foreach (String printer in PrinterSettings.InstalledPrinters) { if (String.Compare(PRINTER, printer, false) == 0) { no_printer = false; } } if (no_printer) { MessageBox.Show("Please select printer.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning); FrmPrinter f = new FrmPrinter(); f.ShowDialog(); f.Dispose(); } } catch (Exception x) { MessageBox.Show(x.Message); } finally { DBHelper.CloseConn(conn); } }
private DataTable QueryPrint(bool preview) { DBConnection conn = null; try { conn = new DBConnection(connectionString); DBResult result = conn.SelectQuery(String.Format(StoredProcedure + " @CMD='PRINT', @PREVIEW={0}", preview ? 1 : 0)); DataTable dt = result.getDataTable(); return(dt); } catch (Exception x) { DBHelper.Rollback(conn); throw x; } finally { DBHelper.CloseConn(conn); } }
private DataTable QueryDB(bool re_cal) { DBConnection conn = null; try { conn = new DBConnection(connectionString); string s = String.Format(StoredProcedure + " @CMD='SEARCH', @DATE1={0},@DATE2={1},@RE_ISSUE={2}", dteBegin.DateTime.ToString("yyMMdd"), dteEnd.DateTime.ToString("yyMMdd"), cbNo.Checked ? 0 : 1); s += string.Format(", @READ_SAVED_TEST_POINTS={0}", ReadSavedTestPoints ? 1 : 0); if (lueMC.EditValue != null) { string m; m = Meteorite.Controls.ControlsUtils.ReadLookUpEdit(lueMC)[Meteorite.Controls.ComboMemberType.Value].ToString(); s += string.Format(", @MC_NO_={0}", m); } if (re_cal) { s += string.Format(", @RE_CAL={0}", 1); } else { s += string.Format(", @RE_CAL={0}", 0); } DBResult result = conn.SelectQuery(s); DataTable dt = result.getDataTable(); return(dt); } catch (Exception x) { DBHelper.Rollback(conn); throw x; } finally { DBHelper.CloseConn(conn); } }