Exemple #1
0
        /// <summary>
        /// 获取一个连接配置
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static Entity.Connection GetConnectionModel(string id)
        {
            Entity.Connection connModel = null;
            if (string.IsNullOrEmpty(id))
            {
                return(connModel);
            }

            XmlDocument doc = new XmlDocument();

            doc.Load(DatabaseconfigPath);

            XmlNode xmlNode = doc.SelectSingleNode("servers/server[@id='" + id.ToString() + "']");

            if (null != xmlNode)
            {
                connModel                  = new SharpTools.Entity.Connection();
                connModel.ID               = new Guid(xmlNode.Attributes["id"].Value);
                connModel.Name             = xmlNode.Attributes["name"].Value;
                connModel.Database         = xmlNode.Attributes["database"].Value;
                connModel.ConnectionString = xmlNode.FirstChild.InnerText;
                connModel.DbType           = xmlNode.Attributes["dbtype"].Value.ConvertTo <DataBaseType>();
            }

            return(connModel);
        }
        //public bool Connect(Entity.Connection cn)
        private bool Connect(Entity.Connection cn)
        {
            bool isConnected = false;

            if (cn.IP.Trim() == "" || cn.Port.Trim() == "")
            {
                Util.LogHelper.WriteLog("IP and Port cannot be null.");

                return(false);
            }

            int idwErrorCode = 0;

            isConnected = this.device.Connect_Net(cn.IP.Trim(), Convert.ToInt32(cn.Port.Trim()));

            if (isConnected)
            {
                //if (this.device.RegEvent(cn.MachineNumber, 65535))//Here you can register the realtime events that you want to be triggered(the parameters 65535 means registering all)
                //{
                //    this.device.OnConnected += new zkemkeeper._IZKEMEvents_OnConnectedEventHandler(OnConnected);
                //}
            }
            else
            {
                device.GetLastError(ref idwErrorCode);
                Util.LogHelper.WriteLog(string.Format("Unable to connect the device, ErrorCode={0}", idwErrorCode.ToString()));
            }

            return(isConnected);
        }
Exemple #3
0
        /// <summary>
        /// 确认
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            button1_Click(null, null);

            if (!isConnection)
            {
                return;
            }


            Entity.Connection connectionModel = new Entity.Connection();
            connectionModel.Database         = cbbServer.Text;
            connectionModel.ID               = Guid.NewGuid();
            connectionModel.Name             = cbbServer.Text + "(Oracle)";
            connectionModel.ConnectionString = connstr;
            connectionModel.DbType           = DataBaseType.Oracle;
            Utils.AddConnection(connectionModel);

            this.DialogResult = DialogResult.OK;

            this.Close();
        }
Exemple #4
0
        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="conection"></param>
        public static void AddConnection(Entity.Connection conection)
        {
            XmlDocument doc = getXmlDocument();

            XmlNode root = doc.SelectSingleNode("servers");

            XmlElement xe = doc.CreateElement("server");

            xe.SetAttribute("id", conection.ID.ToString());
            xe.SetAttribute("name", conection.Name);
            xe.SetAttribute("database", conection.Database);
            xe.SetAttribute("dbtype", conection.DbType.ToString());

            XmlElement      xe1   = doc.CreateElement("connectionstring");
            XmlCDataSection cdata = doc.CreateCDataSection(conection.ConnectionString);

            xe1.AppendChild(cdata);

            xe.AppendChild(xe1);

            root.AppendChild(xe);

            doc.Save(DatabaseconfigPath);
        }