/// <summary>
///
/// </summary>
/// <returns></returns>
public bool ifExistsTheProcess()
{
string sqlStr = string.Format(@"select
1
FROM Socket_Mess
WHERE process_name = '{0}'",
this._process_Name);
return(OracleDaoHelper.getDTBySql(sqlStr).Rows.Count > 0 ? true : false);
}
/// <summary>
/// 判断某文件中的索引为: sheet_Index，名称为: sheet_Name 的表格是否存在记录。
/// </summary>
/// <returns></returns>
public bool ifExists()
{
string sqlStr = string.Format(@"SELECT 1
FROM Report_DealWith_Status
WHERE FILE_NAME = '{0}'
AND Sheet_Name = '{1}'",
this._file_name,
this._sheet_name);
return(OracleDaoHelper.getDTBySql(sqlStr).Rows.Count > 0 ? true : false);
}
/// <summary>
///
/// </summary>
/// <param name="productName"></param>
/// <returns></returns>
public static string getVersion(string productName)
{
string sqlStr = string.Format(@"select Release_Version
from Application_Availability
where product_name = '{0}'", productName);
DataTable dt = OracleDaoHelper.getDTBySql(sqlStr);
if (dt.Rows.Count == 0)
{
return("");
}
return(dt.Rows[0]["Release_Version"].ToString());
}
/// <summary>
///
/// </summary>
/// <param name="applicationName"></param>
/// <returns></returns>
public static ProgressInfo getProgressInfo(string applicationName)
{
string sqlStr = string.Format(@"SELECT max_value,
current_value,
name_of_the_handler,
update_time,
finish_flag,
msg
FROM Progress_Info
WHERE Name_of_the_handler = '{0}'
", applicationName);
DataTable dt = OracleDaoHelper.getDTBySql(sqlStr);
return(ConvertHelper <ProgressInfo> .ConvertToObj(dt));
}
private MSG isValid_TheLineName_Or_TheTeamName(string teamName, string lineName)
{
string sqlStr = string.Format(@"SELECT 1 FROM Line_Info where line_name = '{0}'", lineName);
MSG msg = new MSG();
msg.Flag = OracleDaoHelper.getDTBySql(sqlStr).Rows.Count > 0 ? true : false;
msg.Msg = msg.Flag ? "" :"此线体名： " + lineName + " 在Line_Info表中不存在";
if (!msg.Flag)
{
return(msg);
}
//线体检查通过
sqlStr = string.Format(@"SELECT 1 FROM Team_Info where team_name = '{0}'", teamName);
msg.Flag = OracleDaoHelper.getDTBySql(sqlStr).Rows.Count > 0 ? true : false;
msg.Msg = msg.Flag ? "" : "此班组名： " + teamName + " 在team_name表中不存在";
return(msg);
}
/// <summary>
/// 获取最新的一条信息。
/// </summary>
/// <returns></returns>
public static DataTable getLastestMsg()
{
string sqlStr = string.Format(@"SELECT Prompt,
Flag
FROM
(
select row_number() over(order by update_time desc) row_id,
name_of_the_Handler,
prompt,
flag,
finish_flag,
update_time
from FINISH_MESSAGE
) TEMP
where row_id = 1");
return(OracleDaoHelper.getDTBySql(sqlStr));
}
/// <summary>
/// 获取当天的所有处理结果.
/// </summary>
/// <returns></returns>
public static DataTable getAllReportDealWithStatusTheDay()
{
string sqlStr = string.Format(@"SELECT file_name AS ""文件名"",
sheet_visual_counts AS ""表格数"",
sheet_index AS ""索引"",
sheet_name AS ""表格名"",
current_row_index AS ""当前行"",
status_description AS ""进度"",
CASE status_flag
WHEN 1 THEN N'正常'
ELSE N'异常'
END ""状态"",
update_time AS ""更新时间""
FROM Report_Dealwith_Status
WHERE TRUNC(update_Time,'DD') = TRUNC(SYSDATE, 'DD)
ORDER BY sheet_Index ASC");
return(OracleDaoHelper.getDTBySql(sqlStr));
}
/// <summary>
/// 获取此报表下的所有DataTable
/// </summary>
/// <returns></returns>
public DataTable getDTOfTheReport()
{
string sqlStr = string.Format(@"SELECT report_file_path AS ""文件名"",
sheet_visual_counts AS ""表格数"",
sheet_index AS ""索引"",
sheet_name AS ""表格名"",
current_row_index AS ""当前行"",
status_description AS ""进度"",
CASE status_flag
WHEN 1 THEN N'正常'
ELSE N'异常'
END ""状态"",
update_time AS ""更新时间""
FROM Report_Dealwith_Status
WHERE file_name = '{0}'
ORDER BY sheet_Index ASC",
this._file_name);
return(OracleDaoHelper.getDTBySql(sqlStr));
}
/// <summary>
///
/// </summary>
/// <param name="nameOfTheHandler"></param>
/// <returns></returns>
public static DataTable getLastestMsgByHandlerName(string nameOfTheHandler)
{
string sqlStr = string.Format(@"SELECT Prompt,
Flag,
Finish_Flag
FROM
(
select row_number() over(order by update_time desc) row_id,
name_of_the_Handler,
prompt,
flag,
finish_flag,
update_time
from FINISH_MESSAGE
) TEMP
WHERE name_Of_The_Handler = '{0}'
and row_id = 1", nameOfTheHandler);
return(OracleDaoHelper.getDTBySql(sqlStr));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public Socket_Mess getCurrentStatus()
{
string sqlStr = string.Format(@"select
PROCESS_NAME,
RESULT,
FLAG,
STATUS,
Task_Status,
CURRENT_VALUE,
TOTAL_VALUE
FROM Socket_Mess
WHERE process_name = '{0}'",
this._process_Name);
List <Socket_Mess> socketMessList = DT_To_List.TableToList <Socket_Mess>(OracleDaoHelper.getDTBySql(sqlStr));
if (socketMessList.Count == 0)
{
return(null);
}
return(socketMessList[0]);
}
public DataTable getProgressInfo()
{
return(OracleDaoHelper.getDTBySql(string.Format(@"SELECT current_value,max_value,finish_flag,msg FROM Progress_Info WHERE Name_of_the_handler = '{0}'", this.Name_of_the_handler)));
}
public bool ifExists()
{
string sqlStr = string.Format(@"SELECT 1 FROM Progress_Info WHERE Name_of_the_handler = '{0}'", Name_of_the_handler);
return(OracleDaoHelper.getDTBySql(sqlStr).Rows.Count > 0 ? true : false);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public DataTable getRealTimeMessage()
{
string sqlStr = string.Format(@"SELECT msg,flag FROM RealTime_Message WHERE name_Of_The_Handler = '{0}'", this._nameOfTheHandler);
return(OracleDaoHelper.getDTBySql(sqlStr));
}
/// <summary>
/// 依据PN 和 randomStr 获取 Message
/// </summary>
/// <param name="pN"></param>
/// <param name="randomStr"></param>
/// <returns></returns>
public static DataTable getMsgByNameOfTheHandlerAndRandomStr(string pN, string randomStr)
{
string sqlStr = string.Format(@"SELECT prompt,flag,finish_flag FROM FINISH_MESSAGE where name_of_the_Handler= '{0}' and random_str ='{1}'", pN, randomStr);
return(OracleDaoHelper.getDTBySql(sqlStr));
}
