subtablenummatch.as

本人为公司开发的Flex办公系统web源码,包括数据库脚本文件。

package SQL
{
	public class SubtableNumMatch extends SQLBase
	{
		private var msSubtableName:String;
    	private var msSubtableFld:String;
    	private var msLowerRange:String;
    	private var msUpperRange:String;
    	
    	public override function WhereClause():String
    	{
    		return "[" + super.ColumnName + "] in (select " + super.ColumnName + " from " + msSubtableName + " Where " + msSubtableFld + " between " + msLowerRange + " AND " + msUpperRange + ")";
    	}
    	
    	public function set SubtableName(value:String):void
    	{
    		 msSubtableName = value;
    	}
    	public function get SubtableName():String
    	{
    	 	return  msSubtableName;
    	}
    	
    	public function set SubtableFld(value:String):void
    	{
    		msSubtableFld = value
    	}
    	public function get SubtableFld():String
    	{
    		return msSubtableFld;
    	}
    	
    	public function set LowerRange(value:String):void
		{
		  msLowerRange=value;
		}
		
		public function get LowerRange():String
		{
		  return msLowerRange;
		}
		
		public function set UpperRange(value:String):void
		{
		  msUpperRange=value;
		}
		
		public function get UpperRange():String
		{
		  return msUpperRange;
		}
    	
	}
}