set.inc

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

<?php

function dml_birthdayinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,TEMPLATE,TITLE,CONTENT,UNDERWRITE,CREATOR,SMS_REMIND";
		$sql .= " FROM BIRTHDAY";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
		}
		else if ( !( $term = $edb->getrecordset( ) ) )
		{
			$einfo = "无数据,请设置生日卡";
			$term = false;
		}
		else
		{
			$nd = $edb->getnumrows( );
			break;
		}
	}
	return $term;
}

function dml_insertbirthday( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "INSERT INTO BIRTHDAY(ID,TEMPLATE,TITLE,CONTENT,UNDERWRITE,CREATOR,CREATE_DATE,SMS_REMIND)";
		$sql .= " VALUES(0,'".$parr['template']."','".$parr['title']."','".$parr['content']."',";
		$sql .= "'".$parr['underwrite']."','".$parr['creator']."',NOW(),".$parr['sms_remind'].")";
		while ( $term )
		{
			if ( !$edb->executequery( $sql ) )
			{
				$term = false;
				$einfo = "数据录入错误";
				break;
			}
			else
			{
				if ( ( $rows = $edb->getaffectedrows( ) ) )
				{
					break;
				}
				$rows = 0;
				$term = false;
				$einfo = "数据库错误，。";
				break;
			}
		}
		break;
	}
	return $term;
}

function dml_modifybirthday( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE BIRTHDAY SET TEMPLATE = '".$parr['template']."',";
		$sql .= " TITLE = '".$parr['title']."',CONTENT = '".$parr['content']."',";
		$sql .= " UNDERWRITE = '".$parr['underwrite']."',SMS_REMIND = '".$parr['sms_remind']."'";
		if ( !$edb->executequery( $sql ) )
		{
			$term = false;
			$einfo = "修改错误";
		}
		else
		{
			if ( ( $rows = $edb->getaffectedrows( ) ) )
			{
				break;
			}
			$rows = 0;
			$term = false;
			$einfo = "没有作任何修改,请返回";
			break;
		}
	}
	return $term;
}

function dml_userinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT USER_ID,USER_NAME FROM USER WHERE USER_ID = '".$parr['user_id']."'";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询用户错误";
			$term = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

?>