public static int Count(string tableName)
{
string sql = string.Format("SELECT COUNT(1) FROM MDS_IMP_OBJTABLE_INFO WHERE OBJECT_TABLE_CODE='{0}'", tableName);
object count = OracleHelper.Scalar(sql);
return(Convert.ToInt32(count.ToString()));
}
/// <summary>
/// 任务下是否有配置script
/// </summary>
/// <param name="taskid"></param>
/// <param name="scriptCode"></param>
/// <returns></returns>
public static int getTaskScriptCount(string taskid, string scriptCode)
{
string sql = string.Format("select count(1) from mpm.pm_task_info pti left join import.mds_imp_data_script s on instr(pti.resolver_task_id, s.fid) > 0 where pti.id='{0}' and s.mids_script_code='{1}'", taskid, scriptCode);
int count = Convert.ToInt32(OracleHelper.Scalar(sql).ToString());
return(count);
}
public static int CheckCode(string code)
{
string sql = string.Format("SELECT COUNT(MIDS_SCRIPT_CODE) FROM MDS_IMP_DATA_SCRIPT WHERE MIDS_SCRIPT_CODE='{0}'", code);
return(Convert.ToInt32(OracleHelper.Scalar(sql).ToString()));
}
