//if user must change sheet page to read information about chamber's report
public void ChangeSheet(out Stru_GetExcelInfor ss)
{
if (SheetNameList[dtt.Rows.Count - 1] == "Global$")
SelectPage(SheetNameList[dtt.Rows.Count - 1]);
else
ErrorLogger("" + DateTime.Now + " 3D Error : Can't find 'Global' Sheet on Excel..." + '\t' + "");
GetInformation(ds, out ss);//get the information of test item from excel
}
public void GetInformation(DataSet ds, out Stru_GetExcelInfor stru)
{
DES_SA.DES_Service_Algorithm des = new DES_SA.DES_Service_Algorithm();
int sheet_index = 0;
for (int i = 0; i < dtt.Rows.Count - 1; i++)
{
if (SheetNameList[i] == Input_SheetName)
sheet_index = i;
}
stru.First_Encrypt_Infor.name = ds.Tables[0].Rows[5 + (sheet_index * 2)][0].ToString();
stru.First_Encrypt_Infor.value = des.Decoding_Service(ds.Tables[0].Rows[5 + (sheet_index * 2)][1].ToString());
stru.Second_Encrypt_Infor.name = ds.Tables[0].Rows[6 + (sheet_index * 2)][0].ToString();
stru.Second_Encrypt_Infor.value = des.Decoding_Service(ds.Tables[0].Rows[6 + (sheet_index * 2)][1].ToString());
stru.Fourth_Infor.name = ds.Tables[0].Rows[4][0].ToString();
stru.Fourth_Infor.value = ds.Tables[0].Rows[4][1].ToString();
stru.Third_Infor.name = ds.Tables[0].Rows[3][0].ToString();
stru.Third_Infor.value = ds.Tables[0].Rows[3][1].ToString();
stru.Module_name = ds.Tables[0].Rows[2][0].ToString();
stru.Vender = ds.Tables[0].Rows[1][0].ToString();
stru.Test_name = ds.Tables[0].Rows[0][0].ToString();
}
