eip_manage/Zeus/WebRoot/business/database/js/database_operation.js

$(document).ready( function(){
	$('#hospitalid').combobox({
 		editable:false,   
    	valueField:'hosid',   
   		textField:'hos_name'
	});
	var pd = Commonjs.ajax("BasicAction_queryHosInfo.action",{},false).result;
	$('#hospitalid').combobox('loadData',pd);
});
function dispalyQuery(){	
		$('#query').slideToggle("show");
}

function alertMessage(msgText){	
	alert(msgText);
}
function doQuery(formId){
	var form=$('');
	if(formId){
		form = $('#'+formId);
	}
	var url= form[0].action;
	var data='';
	var fields=form.serializeArray();
	$.each(fields,function(i,field){
		if(i==0){
			data+="'"+field.name+"':'"+field.value+"'";
		}else{
			data+=",'"+field.name+"':'"+field.value+"'";
		}
	});
//	if (fields.length > 0) {
//		data+=",displayColumns:'"+displayColumns+"'";
//	}else {
//		data+="displayColumns:'"+displayColumns+"'";
//	}
	data=eval('({'+data+'});');
	
	
	$('#'+dataTableName).datagrid({
		url: url,
		title: '',
		iconCls: 'icon-save',
		fit:false,
		collapsible:false,
		nowrap: true,
		striped: true,
		border:false,
		collapsible:false,
		fitColumns: true, 
		singleSelect: true,
		idField:'id',
		pagination:true,
		pageSize:15,
		pageNumber:1,
		rownumbers:true,
		queryParams:data,
		columns:dataTableColumns
	});
	
	
//	$('#'+dataTableName).datagrid({
//		title:'',
//		iconCls:'',
//		nowrap: true,
//		border:false,
//		striped: true,
//		collapsible:false,
//		singleSelect:false,
//		fitColumns: false,
//		url:url,
//		idField:'id',
//		pagination:true,
//		fit:false,
//		rownumbers:true,
//		pageSize:20,
//		pageNumber:1,
//		queryParams:data,
//		columns: dataTableColumns
//	});
}

function tianxie1(){
$('#sqltext').val("show tables");
}

function tianxie2(){
$('#sqltext').val("SELECT COLUMN_NAME, DATA_TYPE, COLUMN_COMMENT, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE  table_name = 'bat_user'");
}

function chongzhi(){
$('#sqltext').val("");
}

function exec(){
	var ghthosid = $('#hospitalid').combobox('getValue');
	var sqltype = $("#sqltype").val();
	var sqltext = $("#sqltext").val();
	if(ghthosid==""){
		alert("请选择一家医院");
	}else{
		if(!confirm("确定执行该语句操作?"+sqltext)){
			return ;
		}
		var rowData = {};
		rowData.hospitalid= ghthosid;
		rowData.sqltype= sqltype;
		rowData.sqltext= sqltext;
		var result = Commonjs.ajax("./DataBaseAction_ExecSql.action",rowData,false);
		console.info(result);
		if(result.RespCode!='10000'){
			alert(result.RespMessage);
			return;
		}
		var data = result.Data;
		var datas=[]
		if(!data.length){
			datas.push(data);
		}else{
			datas=data;
		}
		var Columns = (result.Title).split(",");
		var jsons=[];
		var dataTableColumns = [];
		for ( var i = 0; i < Columns.length; i++) {
			var json={};
			json.field=Columns[i];
			json.title=Columns[i];
			jsons.push(json);
		}
		dataTableColumns.push(jsons);
		var dg = $('#dg').datagrid({
			title : '',
			height : $('#layoutid').layout('panel', 'center').panel(
			'options').height,
			data:datas,
			columns : dataTableColumns,
			fitColumns : false,
			singleSelect : true,
		});
		dg.datagrid('loadData',datas);
	}

}