Пример #1
0
        /// <summary>
        /// 获取指定模板的指定项目信息
        /// </summary>
        /// <param name="deviceType"></param>
        /// <param name="project"></param>
        /// <returns></returns>
        public static Model.DeviceTemplate GetDeviceTemplate(Model.DeviceType deviceType, string project)
        {
            string sql = "";

            switch (deviceType)
            {
            case Model.DeviceType.ROSO_RSJ:
                sql = "select * from ROSO_RSJ where Project=@Project";
                break;

            case Model.DeviceType.ROSO_BZJ:
                sql = "select * from ROSO_BZJ where Project=@Project";
                break;

            case Model.DeviceType.ROSO_DXJ:
                sql = "select * from ROSO_DXJ where Project=@Project";
                break;

            case Model.DeviceType.ROSO_RDJ:
                sql = "select * from ROSO_RDJ where Project=@Project";
                break;

            default:
                return(null);

                break;
            }
            SqlParameter[] p =
            {
                new SqlParameter("@Project", project)
            };
            using (SqlDataReader reader = SQLHelper.ExecuteReader(sql, CommandType.Text, p))
            {
                Model.DeviceTemplate dt = new Model.DeviceTemplate();
                if (reader.Read())
                {
                    dt.ID      = Convert.ToInt32(reader["ID"]);
                    dt.Address = Convert.ToInt16(reader["Address"]);
                    dt.Length  = Convert.ToInt16(reader["Length"]);
                    dt.Project = Convert.ToString(reader["Project"]);
                    dt.Remark  = Convert.ToString(reader["Remark"]);
                    dt.Type    = Convert.ToString(reader["Type"]);
                }
                return(dt);
            }
        }
Пример #2
0
        /// <summary>
        /// 获取指定模板的全部信息
        /// </summary>
        /// <param name="deviceType"></param>
        /// <returns></returns>
        public static List <Model.DeviceTemplate> GetDeviceTemplateList(Model.DeviceType deviceType)
        {
            string sql;

            switch (deviceType)
            {
            case Model.DeviceType.ROSO_RSJ:
                sql = "select * from ROSO_RSJ";
                break;

            case Model.DeviceType.ROSO_BZJ:
                sql = "select * from ROSO_BZJ";
                break;

            case Model.DeviceType.ROSO_DXJ:
                sql = "select * from ROSO_DXJ";
                break;

            case Model.DeviceType.ROSO_RDJ:
                sql = "select * from ROSO_RDJ";
                break;

            default:
                return(null);

                break;
            }
            using (SqlDataReader reader = SQLHelper.ExecuteReader(sql, CommandType.Text, null))
            {
                List <Model.DeviceTemplate> list = new List <Model.DeviceTemplate>();
                while (reader.Read())
                {
                    Model.DeviceTemplate dt = new Model.DeviceTemplate();
                    dt.ID      = Convert.ToInt32(reader["ID"]);
                    dt.Address = Convert.ToInt16(reader["Address"]);
                    dt.Length  = Convert.ToInt16(reader["Length"]);
                    dt.Project = Convert.ToString(reader["Project"]);
                    dt.Remark  = Convert.ToString(reader["Remark"]);
                    dt.Type    = Convert.ToString(reader["Type"]);
                    list.Add(dt);
                }
                return(list);
            }
        }
Пример #3
0
 /// <summary>
 /// 在指定类型模板信息列表中获取指定项目的信息
 /// </summary>
 /// <param name="list"></param>
 /// <param name="project"></param>
 /// <returns></returns>
 public static Model.DeviceTemplate GetDeviceTemplate(List <Model.DeviceTemplate> list, string project)
 {
     Model.DeviceTemplate dt = list.Find(p => p.Project.Equals(project));
     return(dt);
 }