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())); }