//public void createUserAndGrant() //不能用代码的形式创建用户,只能手动,原因是网上说:用.NET新提供的managed provider来访问Oracle数据(System.Data.OracleClient),是无法以sys用户登录的。 //{ //创建用户并授权 // initialDB = new DBManager(); // string errorCode = ""; // initialDB.OpenConnection(db_sysName, db_sysPassWord, db_ip, db_port, db_name, ref errorCode); // string createUserSql = "CREATE USER " + db_userName + " IDENTIFIED BY " + db_userPassWord; // string grantSql = "GRANT DBA TO " + db_userName; // OracleCommand createUserCommand = new OracleCommand(createUserSql, initialDB.GetConnection()); // OracleCommand grantCommand = new OracleCommand(createUserSql, initialDB.GetConnection()); // int result = createUserCommand.ExecuteNonQuery(); // int result2 = grantCommand.ExecuteNonQuery(); // initialDB.CloseConnection(); //} public void createAllTableAndSequence(int type) //type 0表示正常数据库,1表示应急数据库 { //创建所有的表和序列 initialDB = new DBManager(); string errorCode = ""; switch (type) { case 0: initialDB.OpenConnection(db_userName, db_userPassWord, db_ip, db_port, db_name, ref errorCode); break; case 1: initialDB.OpenConnection(db_userName, db_userPassWord, db_ip, db_port, emergencyDb_name, ref errorCode); break; } /** * 以前下面这些用循环创建的语句改成为每栋楼根据实际情况单独建表 * 参数分别表示:创建的楼的id,楼中设备最多的有几个参数 * */ //CreateDataTableAndSequence(1, 8);//这行的意思就是创建sid为2(208)的数据表,而208的设备中最多有8个参数 for (int i = 0; i < 10; i++) { CreateDataTableAndSequence(i, 8); } createConstantTableAndInsertConstantData(); //创建除数据表以外的其他数据表,并插入测试数据 }
public static bool changeEmergencyState(int type) //type 0 表示正常状态,1表示应急状态 { dataOfDevice.CloseConnection(); string errorCode = ""; int result = 0; switch (type) { case 0: result = (int)dataOfDevice.OpenConnection(DBHelper.db_userName, DBHelper.db_userPassWord, DBHelper.db_ip, DBHelper.db_port, DBHelper.db_name, ref errorCode); break; case 1: result = (int)dataOfDevice.OpenConnection(DBHelper.db_userName, DBHelper.db_userPassWord, DBHelper.db_ip, DBHelper.db_port, DBHelper.emergencyDb_name, ref errorCode); break; } if (result == (int)ErrorCode.ERR_CODE.OK) { return(true); } return(false); }
public void InitialConnection() //初始化连接 { UdpConnection uc = new UdpConnection(); uc.dataReceivedEvent += receiveData; dataOfDevice = new DBManager(); string errorCode = ""; dataOfDevice.OpenConnection(DBHelper.db_userName, DBHelper.db_userPassWord, DBHelper.db_ip, DBHelper.db_port, DBHelper.db_name, ref errorCode); /** * 发送控制命令到二级的调用方法 * */ //DeviceCommandBox dcb = new DeviceCommandBox(); //dcb.load("deviceId","cabId","high","low","param1","factor"); //List<Box> lb = new List<Box>(); //lb.Add(dcb); //String data = PackageWorker.pack(lb); //sendCommand("192.168.0.105","6003",data); }