private void openCheck(string _tableName,string _bom,string _job)
{
myConnection = default(SqlCeConnection);
DataTable dt = new DataTable();
Adapter = default(SqlCeDataAdapter);
myConnection = new SqlCeConnection(storagePath.getDatabasePath());
myConnection.Open();
myCommand = myConnection.CreateCommand();
myCommand.CommandText = "SELECT [id] FROM [" + _tableName + "] WHERE id ='" + txtBom.Text + "' ";
myCommand.CommandType = CommandType.Text;
Adapter = new SqlCeDataAdapter(myCommand);
Adapter.Fill(dt);
myConnection.Close();
if (dt.Rows.Count > 0)
{
frmCheck frmCheck = new frmCheck(this.txtJob.Text.ToUpper(),this.txtBom.Text.ToUpper(),"");
// frmCheck.BindDataGrid();
frmCheck.setBom(dt.Rows[0]["id"].ToString());
frmCheck.setData(_bom, _job);
frmCheck.Show();
// frmCheck.setBom(this.txtBom.Text);
//frmCheck.setJob(this.txtJob.Text);
dt = null;
MessageBox.Show("Bom : " + dt.Rows[0]["id"].ToString());
}
else
{
MessageBox.Show("Bom : " + txtBom.Text + " does not exited");
}
}
private void goToChecking()
{
int num = 10;
if (this.txtJob.Text.ToUpper().Substring(0, 1) == "J")
{
Thread t = new Thread(delegate()
{
this.progressBar1.Value = num;
});
progressBar1.Visible = true;
progressBar1.Value = 30;
//bomdata = XElement.Load(path);
//XElement storedata;
//IEnumerable<XElement> storeEle = null;
//storedata = XElement.Load(path);
//storeEle = from sEl in storedata.Descendants("BOM")
// where (string)sEl.Attribute("ID") == txtBom.Text
// // where (string)sEl.Attribute("Job") == job
// select sEl;
//if (storeEle.Count() == 0)
//{
// MessageBox.Show("Bom : " + txtBom.Text + " no have in system. Please update BOM");
//}
//else
//{
if (this.checkStoredata())
{
progressBar1.Value = 60;
frmCheck frmCheck = new frmCheck(this.txtJob.Text.ToUpper(), this.txtBom.Text.ToUpper(), username);
//frmCheck.setBOMID(txtBomID.Text);
//frmCheck.setJob(txtJob.Text);
frmCheck.setPath(path);
frmCheck.setUsername(username);
frmCheck.Show();
progressBar1.Value = 100;
progressBar1.Visible = false;
}
else
{
progressBar1.Value = 100;
progressBar1.Visible = false;
MessageBox.Show("Bom : " + bm + " no have in system", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1);
}
}
else
{
MessageBox.Show("Job : " + this.txtJob.Text + " no have in system", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1);
}
//}
}