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