tables_design.js

ASP[1].NET在线SQL数据库企业管理器v0.13(C#源码提供),希望对大家有用

	function SetFields (item, setFields) {
		parseName = item.name.split("_");
		itemNumber = parseName[1];
		
		typeStr = item.options[item.selectedIndex].text; 
		
		e = document.forms("editForm").elements;
	
		if (setFields==1) {
				setValues = true;
	
		} else {
				if (e("Name_" + itemNumber).value=='') {
					setValues = true;
				} else {
					setValues = false;
				}
		}
		
		if (setValues) {
			e("Default_" + itemNumber).value= "";
			e("Default_" + itemNumber).className= "TableInput";
			e("Default_" + itemNumber).disabled = false;
		}
		
		switch (typeStr.toLowerCase()) {
			case "bigint":
					
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = false;
					
					e("Seed_" + itemNumber).className= "TableInput";
					e("Seed_" + itemNumber).disabled = false;
					
					e("Increment_" + itemNumber).className= "TableInput";
					e("Increment_" + itemNumber).disabled = false;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 8;
						e("Precision_" + itemNumber).value= 19;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					break;	
					
			case "binary":
					
					e("Length_" + itemNumber).className= "TableInput";
					e("Length_" + itemNumber).disabled = false;
				
					e("Precision_" + itemNumber).className= "TableInputOff";	
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
						
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 50;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					break;	
			
			case "bit":
					
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 1;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					break;		
			
			case "char":
					e("Length_" + itemNumber).className= "TableInput";
					e("Length_" + itemNumber).disabled = false;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 10;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					break;	
					
			case "datetime":
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 8;
						e("Precision_" + itemNumber).value= "";
						e("Scale_" + itemNumber).value= "";
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;		
					
					
			 case "decimal":
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInput";
					e("Precision_" + itemNumber).disabled = false;
					
					e("Scale_" + itemNumber).className= "TableInput";
					e("Scale_" + itemNumber).disabled = false;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 9;
						e("Precision_" + itemNumber).value= 18;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
						
					break;		
					
			 case "float":
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 8;
						e("Precision_" + itemNumber).value= 53;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
					
			 case "image":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 16;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
		
			 case "int":
					
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = false;
					
					e("Seed_" + itemNumber).className= "TableInput";
					e("Seed_" + itemNumber).disabled = false;
					
					e("Increment_" + itemNumber).className= "TableInput";
					e("Increment_" + itemNumber).disabled = false;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 4;
						e("Precision_" + itemNumber).value= 10;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;
					
					
			case "money":
					
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
				
					e("Identity_" + itemNumber).disabled = true;
				
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
				
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {			
						e("Length_" + itemNumber).value= 8;
						e("Precision_" + itemNumber).value= 19;
						e("Scale_" + itemNumber).value= 4;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;								
		
			 case "nchar":
					
					e("Length_" + itemNumber).className= "TableInput";
					e("Length_" + itemNumber).disabled = false;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
					
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
					
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					if (setValues) {
						e("Length_" + itemNumber).value= 10;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					
					break;	
			
			case "ntext":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
				
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Scale_" + itemNumber).className= "TableInputOff";
					e("Scale_" + itemNumber).disabled = true;
					
					e("Identity_" + itemNumber).disabled = true;
						
				
					e("Seed_" + itemNumber).className= "TableInputOff";
					e("Seed_" + itemNumber).disabled = true;
				
					e("Increment_" + itemNumber).className= "TableInputOff";
					e("Increment_" + itemNumber).disabled = true;
					
					
					if (setValues) {
						e("Length_" + itemNumber).value= 16;
						e("Precision_" + itemNumber).value= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}