Пример #1
0
        private static Dictionary <string, string> getLabelersList_byGroup(string GroupPath)
        {
            DataTable dt = new GetMysql().FilledTable(@"SELECT D.name,D.ip_addr FROM device D, device_has_group Dh, devicemodel DM, `group` G
WHERE Dh.Device_ID=D.Device_ID AND D.devicemodel_iddevicemodel=DM.iddevicemodel AND DM.`Type`='Labeler' AND Dh.Group_id=G.id AND G.`id`=pathtoid('" + GroupPath + "');");
            Dictionary <string, string> dict = new Dictionary <string, string>();

            foreach (DataRow dr in dt.Rows)
            {
                dict.Add(dr["name"].ToString(), dr["ip_addr"].ToString());
            }
            return(dict);
        }
Пример #2
0
        /// <summary>
        /// Queries a List of printers in the PathDirectory MySQL Schema for a SoftName
        /// </summary>
        /// <param name="printerName">ex: C42</param>
        /// <returns></returns>
        public string GetSoftNameByAddress(string IPAddress)
        {
            string ip = new GetMysql().ScalarValue(@"SELECT name FROM device WHERE D.`ip_addr`='" + IPAddress + "';");

            return(ip);
        }
Пример #3
0
        /// <summary>
        /// Queries a List of printers in the PathDirectory MySQL Schema for an IpAddress
        /// </summary>
        /// <param name="printerName">ex: C42</param>
        /// <returns></returns>
        public string GetAddressBySoftName(string printerName)
        {
            string ip = new GetMysql().ScalarValue(@"SELECT ip_addr FROM device WHERE `name`='" + printerName + "';");

            return(ip);
        }