请教如何一个将php函数转为.net方法

2014-04-13 07:12:11 146 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

西门子WinCC VBS脚本实战：5分钟搞定变量记录导出到Excel（附完整代码）本文提供了一套高效的西门子WinCC VBS脚本方案，帮助工程师在5分钟内将变量记录数据导出至Excel。方案详细解析了时区转换、数据库连接、SQL查询优化等核心难点，并附带了完整、可直接使用的VBS代码，解决了工业自动化项目中数据导出的实际痛点。阅读详情



function showdistrict($values, $elems=array(), $container='districtbox', $showlevel=null, $containertype = 'birth') {

	$html = '';

	if(!preg_match("/^[A-Za-z0-9_]+$/", $container)) {

		return $html;

	}

	$showlevel = !empty($showlevel) ? intval($showlevel) : count($values);

	$showlevel = $showlevel <= 4 ? $showlevel : 4;

	$upids = array(0);

	for($i=0;$i<$showlevel;$i++) {

		if(!empty($values[$i])) {

			$upids[] = intval($values[$i]);

		} else {

			for($j=$i; $j<$showlevel; $j++) {

				$values[$j] = '';

			}

			break;

		}

	}

	$options = array(1=>array(), 2=>array(), 3=>array(), 4=>array());

	if($upids && is_array($upids)) {

		foreach(C::t('common_district')->fetch_all_by_upid($upids, 'displayorder', 'ASC') as $value) {

			if($value['level'] == 1 && ($value['id'] != $values[0] && ($value['usetype'] == 0 || !(($containertype == 'birth' && in_array($value['usetype'], array(1, 3))) || ($containertype != 'birth' && in_array($value['usetype'], array(2, 3))))))) {

				continue;

			}

			$options[$value['level']][] = array($value['id'], $value['name']);

		}

	}

	$names = array('province', 'city', 'district', 'community');

	for($i=0; $i<4;$i++) {

		if(!empty($elems[$i])) {

			$elems[$i] = dhtmlspecialchars(preg_replace("/[^\[A-Za-z0-9_\]]/", '', $elems[$i]));

		} else {

			$elems[$i] = ($containertype == 'birth' ? 'birth' : 'reside').$names[$i];

		}

	}

	for($i=0;$i<$showlevel;$i++) {

		$level = $i+1;

		if(!empty($options[$level])) {

			$jscall = "showdistrict('$container', ['$elems[0]', '$elems[1]', '$elems[2]', '$elems[3]'], $showlevel, $level, '$containertype')";

			$html .= '<select name="'.$elems[$i].'" id="'.$elems[$i].'" class="ps" onchange="'.$jscall.'" tabindex="1">';

			$html .= '<option value="">'.lang('spacecp', 'district_level_'.$level).'</option>';

			foreach($options[$level] as $option) {

				$selected = $option[0] == $values[$i] ? ' selected="selected"' : '';

				$html .= '<option did="'.$option[0].'" value="'.$option[1].'"'.$selected.'>'.$option[1].'</option>';

			}

			$html .= '</select>';

			$html .= '  ';

		}

	}

	return $html;

}





class table_common_district extends discuz_table

{

	public function __construct() {



		$this->_table = 'common_district';

		$this->_pk    = 'id';



		parent::__construct();

	}



	public function fetch_all_by_upid($upid, $order = null, $sort = 'DESC') {

		$upid = is_array($upid) ? array_map('intval', (array)$upid) : dintval($upid);

		if($upid !== null) {

			$ordersql = $order !== null && !empty($order) ? ' ORDER BY '.DB::order($order, $sort) : '';

			return DB::fetch_all('SELECT * FROM %t WHERE '.DB::field('upid', $upid)." $ordersql", array($this->_table), $this->_pk);

		}

		return array();

	}



	public function fetch_all_by_name($name) {

		if(!empty($name)) {

			return DB::fetch_all('SELECT * FROM %t WHERE '.DB::field('name', $name), array($this->_table));

		}

		return array();

	}



}



	public function fetch_all() {

		return DB::fetch_all('SELECT * FROM %t', array($this->_table));

	}