📄 tables_design.js

📁 ASP[1].NET在线SQL数据库企业管理器v0.13(C#源码提供),希望对大家有用
💻 JS
📖 第 1 页 / 共 2 页
字号:
上一页 12
						
					break;				
					
			case "numeric":
					
					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 = 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= 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 "nvarchar":
			 
					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("Seed_" + itemNumber).value= "";
						e("Identity_" + itemNumber).checked = false;
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
					
			case "real":
			 
					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= 4;
						e("Precision_" + itemNumber).value= 24;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;				
					
			case "smalldatetime":
			 
					e("Length_" + itemNumber).className= "TableInputOff";
					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= 4;
						e("Precision_" + itemNumber).value= "";
						e("Scale_" + itemNumber).value= "";
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;			
					
					
			case "smallint":
			 
					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= 2;
						e("Precision_" + itemNumber).value= 5;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;					
		
			case "smallmoney":
			 
					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= 4;
						e("Precision_" + itemNumber).value= 10;
						e("Scale_" + itemNumber).value= 4;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}
					
					break;					
		
		case "text":
			 
					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 "timestamp":
					e("Length_" + itemNumber).className= "TableInputOff";
					e("Length_" + itemNumber).disabled = true;
					
					e("Precision_" + itemNumber).className= "TableInputOff";
					e("Precision_" + itemNumber).disabled = true;
					
					e("Default_" + itemNumber).className= "TableInputOff";
					e("Default_" + 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= 0;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}	
					
					
					break;				
		
		case "tinyint":
			 
					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= 1;
						e("Precision_" + itemNumber).value= 3;
						e("Scale_" + itemNumber).value= 0;
						e("Identity_" + itemNumber).checked = false;
						e("Seed_" + itemNumber).value= "";
						e("Increment_" + itemNumber).value= "";
					}	
					
					break;		
					
		case "uniqueidentifier":
			 
					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("Default_" + itemNumber).value= "(newid())";			 
						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 "varbinary":
					
					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 "varchar":
					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;	
										
		
		}
	  
		
	}
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -