/// <summary>
/// report_file_path,
/// </summary>
public void update()
{
string sqlStr = string.Format(@"UPDATE Report_Dealwith_Status
SET
sheet_visual_counts = {3},
max_row_index ={4},
max_col_index = {5},
current_row_index ={6},
current_col_index = {7},
status_description = '{8}',
status_flag = {9},
update_time = sysdate
WHERE file_name = '{0}'
AND Sheet_Index = {1}
AND Sheet_Name = '{2}'",
this._file_name,
this._sheet_index,
this._sheet_name,
this.Sheet_visual_counts,
this._max_row_index,
this._max_col_index,
this._current_row_Index,
this._current_col_index,
this._status_description,
this._status_flag?1:0);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
/// 使Socket_Mess的 task_status 为 finished.
/// </summary>
public void closeTheSocketMess()
{
string sqlStr = string.Format(@"UPDATE SOCKET_MESS
SET TASK_STATUS = 'finished'
WHERE PROCESS_NAME = '{0}'",
this._process_Name);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
/// 删除掉此报表的处理记录。
/// </summary>
public void del()
{
string sqlStr = string.Format(@"DELETE FROM Report_Dealwith_status
WHERE File_Name = '{0}'
AND Sheet_Name = '{1}'",
this._file_name,
this._sheet_name);
OracleDaoHelper.executeSQL(sqlStr);
}
public void add()
{
string sqlStr = string.Format(@"INSERT INTO Progress_Info(current_value,max_value,name_of_the_handler,finish_flag)
VALUES(
{0},
{1},
'{2}',
{3}
)",
this._current_value,
this._max_value,
this.Name_of_the_handler,
this._finish_flag ? 1 : 0);
OracleDaoHelper.executeSQL(sqlStr);
}
public void update()
{
string sqlStr = string.Format(@"UPDATE Progress_Info
SET current_value = {1},
max_value = {2},
finish_flag = {3},
msg= '{4}'
WHERE name_of_the_handler = '{0}'
",
this.Name_of_the_handler,
this._current_value,
this._max_value,
this._finish_flag?1:0,
this._msg);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
/// 新增时是否为processing.
/// </summary>
/// <returns></returns>
public int addTheSocketMess()
{
string sqlStr = string.Format(@"INSERT INTO Socket_Mess
(
PROCESS_NAME,
TASK_STATUS
)
VALUES(
'{0}',
'{1}'
)",
this._process_Name,
this._task_status
);
return(OracleDaoHelper.executeSQL(sqlStr));
}
/// <summary>
/// 新增 记录
/// </summary>
public void add()
{
//如果存在，先删除
if (ifExists())
{
del();
}
string sqlStr = string.Format(@"INSERT INTO Report_Dealwith_Status(
file_name,
sheet_visual_counts,
sheet_index,
sheet_name,
max_row_index,
max_col_index,
current_row_index,
status_description,
status_flag,
update_time
)VALUES(
'{0}', --<报表名称>--
{1}, --<电子表格个数>
{2}, --<当前表格索引>
'{3}', --<表格名称>
{4}, --<最大行>
{5}, --<最大列>
{6}, --<当前行>
'{7}', --<状态描述>
{8}, --<状态标志位>
sysdate
)", this._file_name,
this.Sheet_visual_counts,
this._sheet_index,
this._sheet_name,
this._max_row_index,
this._max_col_index,
this._current_row_Index,
this._status_description,
this._status_flag?1:0);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public int updateTheSocketMess()
{
string sqlStr = string.Format(@"UPDATE Socket_MESS
SET Result = '{1}',
FLAG = {2},
STATUS = '{3}',
CURRENT_VALUE = {4},
TOTAL_VALUE = {5},
Task_Status = '{6}',
Update_Time = sysdate
WHERE Process_Name = '{0}'",
this._process_Name,
this._result,
this._flag,
this._status,
this._current_value,
this._total_value,
this._task_status
);
return(OracleDaoHelper.executeSQL(sqlStr));
}
public void delete()
{
string sqlStr = string.Format(@"DELETE FROM Progress_Info WHERE Name_of_the_handler = '{0}'", this.Name_of_the_handler);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
/// 删除 Report_Dealwith_status,通过FileName删除.
/// </summary>
/// <param name="fileName"></param>
public static void delStatusByFileName(string fileName)
{
string sqlStr = string.Format(@"DELETE FROM Report_Dealwith_status WHERE File_Name = '{0}'", fileName);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
///
/// </summary>
/// <param name="nameOfTheHandler"></param>
public static void clear(string nameOfTheHandler)
{
string sqlStr = string.Format(@"DELETE FROM FINISH_MESSAGE WHERE name_of_the_Handler = '{0}'", nameOfTheHandler);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
///
/// </summary>
public void update()
{
string sqlStr = string.Format(@"UPDATE FINISH_MESSAGE SET Prompt = '{2}',Flag = {3},finish_flag = {4} WHERE name_of_the_handler = '{0}' And Random_Str = '{1}'", this.NameOftheHandler, this.RandomStr, this._prompt, this.Flag ? 1:0, this.Finish_flag ? 1:0);
OracleDaoHelper.executeSQL(sqlStr);
}
/// <summary>
///
/// </summary>
public void add()
{
string sqlStr = string.Format(@"INSERT INTO FINISH_MESSAGE(Prompt,Flag,name_of_the_handler,Random_Str,finish_flag) VALUES('{0}',{1},'{2}','{3}',{4})", this.Prompt, this.Flag?1:0, this.NameOftheHandler, this.RandomStr, this.Finish_flag?1:0);
OracleDaoHelper.executeSQL(sqlStr);
}