//private void fill_Engine_Details()
//{
// String Str = "";
// Global.CStopTm = DateTime.Now.ToString("hh:mm:ss tt");
// for (int x = 0; x <= 19; x++) EngData[x] = null;
// //string Str = null;
// EngData[0] = Global.Eng_FileNm;
// EngData[1] = Global.EngType;
// EngData[2] = Global.TestRef;
// EngData[3] = Global.FipNo;
// EngData[4] = Global.EngNo;
// EngData[5] = Global.NCyl;
// EngData[6] = Global.Bor;
// EngData[7] = Global.Strk;
// EngData[8] = Global.Svol;
// if (Global.flg_Radiator == true) EngData[9] = "YES"; else EngData[9] = "NO";
// if (Global.flg_Fan == true) EngData[10] = "YES"; else EngData[10] = "NO";
// if (Global.flg_AirCln == true) EngData[11] = "YES"; else EngData[11] = "NO";
// if (Global.flg_Silincer == true) EngData[12] = "YES"; else EngData[12] = "NO";
// EngData[13] = "EDB- 200";
// EngData[14] = Global.OperatorNm;
// EngData[15] = Global.EnginerNm;
// EngData[16] = Global.T_CellNo;
// EngData[17] = Global.CStrtTm;
// EngData[18] = Global.CStopTm;
// if (Global.ErrorMatrix == null) Global.ErrorMatrix = "*******";
// EngData[19] = Global.ErrorMatrix;
// Str = "";
// for (int i = 0; i <= 18; i++)
// {
// if ((EngData[i] == null) || (EngData[i] == ""))
// {
// EngData[i] = "****";
// }
// Str = Str + EngData[i] + "', '";
// }
// Global.Open_DataConn("Data", "conData");
// SqlCommand cmd2 = new SqlCommand("Insert into EngDetails values('" + Str + EngData[19] + "' )", Global.conData);
// cmd2.ExecuteNonQuery();
// Global.conData.Close();
//}
private void ExportData()
{
try
{
if (Global.flg_RecorsPmData == true)
{
Global.Open_PMConn(Global.CDate, "conPM");
MySqlDataAdapter adp = new MySqlDataAdapter("select * from " + Global.Eng_PMFileNm, Global.conPM);
DataSet ds = new DataSet();
adp.Fill(ds);
prgT.Maximum = ds.Tables[0].Rows.Count - 1;
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
prgT.Value = i;
string str = "";
string str1 = "'" + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "'";
for (int j = 1; j <= ds.Tables[0].Columns.Count - 2; j++)
{
str = str + ds.Tables[0].Rows[i].ItemArray[j].ToString() + ", ";
}
string str2 = "'" + ds.Tables[0].Rows[i].ItemArray[13].ToString() + "'";
MySqlCommand cmd = new MySqlCommand("Insert into " + Global.Eng_PMFileNm + "values(" + str1 + "," + str + "" + str2 + " )", Global.conPM);
cmd.ExecuteNonQuery();
}
Global.conPM.Close();
MessageBox.Show("Data Transfer Over");
this.Close();
}
else
{
MessageBox.Show("No Data ......");
this.Close();
}
}
else
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Error Code:-15006", ex.Message);
Global.Create_OnLog(ex.Message + " : Export Data....", "Alart");
this.Close();
}
}
