private void DGOut_CellClick(object sender, DataGridViewCellEventArgs e)
{
int port = 0;
int c = DGOut.CurrentRow.Index;
if (c >= 8)
{
port = 1;
}
else
{
port = 0;
}
if (Convert.ToBoolean(DGOut[0, c].Value) == true)
{
DGOut[1, c].Style.BackColor = Color.Green;;
DGOut[1, c].Style.ForeColor = Color.Yellow;
DGOut[0, c].Value = 0;
Global.Dig_OutBit(port, c, false);
}
else
{
DGOut[1, c].Style.BackColor = Color.Red;;
DGOut[1, c].Style.ForeColor = Color.Yellow;
DGOut[0, c].Value = 1;
Global.Dig_OutBit(port, c, true);
}
}
//private void Read_Project()
//{
// try
// {
// Global.Open_Connection("General", "con");
// OleDbCommand cmd = new OleDbCommand("SELECT * FROM tblProject Where ProjectFile = '" + Global.PrjNm + "'", Global.con);
// OleDbDataReader Rd = cmd.ExecuteReader();
// while (Rd.Read())
// {
// frmMain.Prj[0] = Rd.GetValue(0).ToString();
// frmMain.Prj[1] = Rd.GetValue(1).ToString();
// frmMain.Prj[2] = Rd.GetValue(2).ToString();
// //frmMain.Prj[3] = Rd.GetValue(3).ToString();
// frmMain.Prj[4] = Rd.GetValue(4).ToString();
// Global.NCyl = Rd.GetValue(4).ToString();
// frmMain.Prj[5] = Rd.GetValue(5).ToString();
// frmMain.Prj[6] = Rd.GetValue(6).ToString();
// Global.EngMd = frmMain.Prj[6].Trim();
// }
// Global.con.Close();
// }
// catch (Exception ex)
// {
// MessageBox.Show("Error in Rd_Project : ", ex.Message);
// Global.Create_OnLog(ex.Message);
// }
//}
private void Check_File_Validation()
{
try
{
if (Global.EngNo == String.Empty)
{
MessageBox.Show("Engine No. Not Entered ......., ");
}
else
{
Global.Open_Connection("General", "con");
MySqlCommand cmd = new MySqlCommand("SELECT * FROM tblProject WHERE ProjectFile = '" + Global.PrjNm + "'", Global.con);
MySqlDataReader Rd = cmd.ExecuteReader();
int x = 0;
while (Rd.Read())
{
for (x = 0; x < (Rd.FieldCount - 1); x++)
{
Global.Prj[x] = Rd.GetValue(x).ToString();
}
}
Global.cumhours = "0000.00.00";
Global.Open_Connection("General", "con");
MySqlCommand cmd1 = new MySqlCommand("SELECT * FROM tblEngine", Global.con);
MySqlDataReader Rd1 = cmd1.ExecuteReader();
x = 0;
while (Rd1.Read())
{
if (Global.Prj[1] == Rd1.GetValue(0).ToString())
{
f_Found = true;
break;
}
if (Convert.ToInt32(Global.Prj[12]) >= 1000)
{
Global.Dig_OutBit(0, 6, true);
}
else
{
Global.Dig_OutBit(0, 6, false);
}
x += 1;
}
if (f_Found == false)
{
MessageBox.Show("Engine File Not Found ....... ");
return;
}
Global.con.Close();
// **************************
Global.Open_Connection("Limit", "conLim");
DataTable dt = Global.conLim.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Global.Prj[3] == dt.Rows[i]["TABLE_NAME"].ToString())
{
f_Found = true;
break;
}
x += 1;
}
if (f_Found == false)
{
MessageBox.Show("Limit File Not Found ....... ");
return;
}
// **************************
Global.Open_Connection("Sequence", "conSeq");
dt = Global.conSeq.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Global.Prj[2] == dt.Rows[i]["TABLE_NAME"].ToString())
{
f_Found = true;
break;
}
x += 1;
}
if (f_Found == false)
{
MessageBox.Show("Sequence File Not Found ....... ");
return;
}
// **************************
}
}
catch (Exception ex)
{
MessageBox.Show("Error in Check File validation:" + ex.Message);
}
}
