index.inc

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

function dml_flowsortinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,NOORDER,TITLE FROM FLOW_SORT ORDER BY NOORDER";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$nd = false;
			$term = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_addflowsort( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "INSERT INTO FLOW_SORT(ID,NOORDER,TITLE,CREATOR,CREATE_DATE)";
		$sql .= " VALUES(0,".$parr['noorder'].",'".$parr['title']."'";
		$sql .= " ,'".$parr['creator']."',NOW())";
		if ( !$edb->executequery( $sql ) )
		{
			$term = false;
			$einfo = "序员不能重复，请重新输入";
		}
		else
		{
			if ( ( $rows = $edb->getaffectedrows( ) ) )
			{
				break;
			}
			$rows = 0;
			$term = false;
			$einfo = "没有作任何修改,请返回";
			break;
		}
	}
	return $term;
}

function dml_modifysort( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE FLOW_SORT SET NOORDER = ".$parr['noorder'].",TITLE = '".$parr['title']."'";
		$sql .= " WHERE ID = ".$parr['id']."";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$term = false;
		$einfo = "修改错误";
		break;
	}
	return $term;
}

function dml_searchsort( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,NOORDER,TITLE FROM FLOW_SORT WHERE ID = ".$parr['id']."";
		if ( !$edb->executequery( $sql ) )
		{
			$term = false;
			$einfo = "查询错误";
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$term = false;
			$einfo = "查询错误";
			break;
		}
	}
	return $term;
}

function dml_delsort( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "\r\n\t\t\t   SELECT COUNT(FLOW_SORT) AS cnt FROM flow_type\r\n\t\t\t\t   WHERE FLOW_SORT=".$parr['id']."\r\n\t\t\t\t";
		$edb->executequery( $sql );
		$term = $edb->getrecordset( );
		if ( !( $term['0']['cnt'] == 0 ) )
		{
			break;
		}
		$sql = "DELETE FROM FLOW_SORT WHERE ID = ".$parr['id']."";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$einfo = "删除错误";
		$term = false;
		break;
	}
	return $term;
}

?>