public static ResultRequest.Job Get_Result_Respond(ResultRequest.Result result,
ref string sql, ref int left, ref int right, ref int mid, ref string str_result)
{
ResultRequest.Job work_state = ResultRequest.Job.None;
if (Confirm.Is_Click_btnGDatabaseName)
{
work_state = Handing.Respond(result, ResultRequest.Mode.String, ResultRequest.Mode_SQL.DB_Name,
ref sql, ref left, ref right, ref mid, ref str_result);
}
else if (Confirm.Is_Click_btnGNameTables)
{
if (Confirm.Count_Tables_Done)
{
work_state = Handing.Respond(result, ResultRequest.Mode.String, ResultRequest.Mode_SQL.TABLES_NAME,
ref sql, ref left, ref right, ref mid, ref str_result);
}
else
{
work_state = Handing.Respond(result, ResultRequest.Mode.Number, ResultRequest.Mode_SQL.TABLES_NAME,
ref sql, ref left, ref right, ref mid, ref str_result);
}
}
else if (Confirm.Is_Click_btnGNameColumns)
{
if (Confirm.Find_Quantity_Done)
{
work_state = Handing.Respond(result, ResultRequest.Mode.String, ResultRequest.Mode_SQL.COLUMNS_NAME,
ref sql, ref left, ref right, ref mid, ref str_result);
}
else
{
work_state = Handing.Respond(result, ResultRequest.Mode.Number, ResultRequest.Mode_SQL.COLUMNS_NAME,
ref sql, ref left, ref right, ref mid, ref str_result);
}
}
else if (Confirm.Is_Click_btnGetData)
{
if (!Confirm.Find_Quantity_Row_Done.Contains(false))
{
work_state = Handing.Respond(result, ResultRequest.Mode.String, ResultRequest.Mode_SQL.DATA_TABLE,
ref sql, ref left, ref right, ref mid, ref str_result);
}
else
{
work_state = Handing.Respond(result, ResultRequest.Mode.Number, ResultRequest.Mode_SQL.DATA_TABLE,
ref sql, ref left, ref right, ref mid, ref str_result);
}
}
return(work_state);
}
private void wbro_Brower_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
{
txt_Url.Text = wbro_Brower.Url.ToString();
html = wbro_Brower.DocumentText;
html_Document_Current = wbro_Brower.Document;
if (btn_Click)
{
ResultRequest.Result result = Handing.GetResultSubmit(html_Document_Current);
ResultRequest.Job work_state = ResultRequest.Job.None;
int left, mid, right, index;
string str_result, sql;
left = mid = right = index = 0;
str_result = sql = "";
Variable.Get_Data_Variable(ref left, ref mid, ref right, ref index, ref str_result, ref sql);
work_state = Handing.Get_Result_Respond(result, ref sql, ref left, ref right, ref mid, ref str_result);
Variable.Set_Data_Variable(left, mid, right, index, str_result, sql);
if (work_state == ResultRequest.Job.Done_ALL)
{
if (Confirm.Is_Click_btnGDatabaseName)
{
Confirm.Is_Click_btnGDatabaseName = false;
btn_Click = false;
btn_GetDBName.Enabled = false;
Variable.Left = 0; Variable.Right = 255; Variable.Mid = 127; Variable.Index_str = 0;
Variable.Str_result = "";
return;
}
else if (Confirm.Is_Click_btnGNameTables)
{
if (Confirm.Count_Tables_Done) // print table name
{
Variable.Index_str = 0;
if (Variable.Index_Tables < Variable.Quantity_Tables)
{
Variable.Index_Tables++;
lbl_TBsName.Text += " ";
Variable.Left = 0; Variable.Right = 255; Variable.Mid = 127;
btn_GetTBsName.PerformClick();
return;
}
else // all done
{
Variable.Index_str = 0;
Confirm.Is_Click_btnGNameTables = false;
btn_Click = false;
cmb_TbsName.Items.Add(Variable.Db_TablesName);
return;
}
}
else
{
lbl_Count_TBsName.Text += Variable.Str_result;
Variable.Quantity_Tables = Convert.ToInt32(Variable.Str_result);
Confirm.Count_Tables_Done = true;
Variable.Reset_Data_Variable();
btn_GetTBsName.PerformClick();
return;
}
}
else if (Confirm.Is_Click_btnGNameColumns)
{
if (Confirm.Find_Quantity_Done)
{
Variable.Index_Columns++;
if (Variable.Index_Columns >= Variable.Quantity_Columns[Variable.Index_Tables])
{
Variable.Index_Columns = 0;
Variable.Index_Tables++;
}
Variable.Reset_Data_Variable();
btn_GetColsName.PerformClick();
return;
}
else
{
Variable.Quantity_Columns[Variable.Index_Tables] = Convert.ToInt32(Variable.Str_result);
Variable.Str_result = "";
Variable.Index_Tables++;
Variable.Reset_Data_Variable();
btn_GetColsName.PerformClick();
return;
}
}
else if (Confirm.Is_Click_btnGetData)
{
if (Confirm.Find_Quantity_Row_Done.Contains(false)) //don't complete
{
Variable.Quantity_Row[Variable.Index_Tables] = Convert.ToInt32(Variable.Str_result);
Confirm.Find_Quantity_Row_Done[Variable.Index_Tables] = true;
Variable.Reset_Data_Variable();
btn_GetData.PerformClick();
return;
}
else
{
Variable.Index_Columns++;
if (Variable.Index_Columns >= Variable.Quantity_Columns[Variable.Index_Tables])
{
Variable.Index_Columns = 0;
Variable.Index_Rows++;
if (Variable.Index_Rows >= Variable.Quantity_Row[Variable.Index_Tables])
{
Variable.Index_Rows = 0;
Variable.Index_Tables++;
}
}
else
{
Change_IndexCols_Whent_GetDataTable();
}
Variable.Reset_Data_Variable();
btn_GetData.PerformClick();
return;
}
}
}
else if (work_state == ResultRequest.Job.Done_OnePart)
{
if (Confirm.Is_Click_btnGDatabaseName)
{
lbl_Result_DBName.Text += Variable.Str_result;
Variable.Db_Name += Variable.Str_result;
Variable.Sql_Request = Handing.Change_Sql_Get_Next_Char(ResultRequest.Mode_SQL.DB_Name);
}
else if (Confirm.Is_Click_btnGNameTables)
{
Variable.Db_TablesName[Variable.Index_Tables] += Variable.Str_result;
lbl_TBsName.Text += Variable.Str_result;
Variable.Sql_Request = Handing.Change_Sql_Get_Next_Char(ResultRequest.Mode_SQL.TABLES_NAME);
}
else if (Confirm.Is_Click_btnGNameColumns)
{
Variable.Db_ColumnsName[Variable.Index_Tables][Variable.Index_Columns] += Variable.Str_result;
Variable.Sql_Request = Handing.Change_Sql_Get_Next_Char(ResultRequest.Mode_SQL.COLUMNS_NAME);
}
else if (Confirm.Is_Click_btnGetData)
{
Variable.Bd_DataTable[Variable.Index_Tables][Variable.Index_Rows][Variable.Index_Columns] += Variable.Str_result;
Variable.Sql_Request = Handing.Change_Sql_Get_Next_Char(ResultRequest.Mode_SQL.DATA_TABLE);
dgv_Data.DataSource = Fill_Data_To_DataTable();
}
PutData(Variable.Sql_Request);
}
else if (work_state == ResultRequest.Job.Continue)
{
PutData(Variable.Sql_Request);
}
}
}
