Пример #1
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int SupplierId)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from T_Supplier");
            strSql.Append(" where SupplierId=@SupplierId ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@SupplierId", SqlDbType.Int, 4)
            };
            parameters[0].Value = SupplierId;

            return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
        }
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string PointCode)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from T_StationInformation");
            strSql.Append(" where PointCode=@PointCode ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@PointCode", SqlDbType.NVarChar, 20)
            };
            parameters[0].Value = PointCode;

            return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
        }
Пример #3
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int PointID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from T_StationNet");
            strSql.Append(" where PointID=@PointID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@PointID", SqlDbType.Int, 4)
            };
            parameters[0].Value = PointID;

            return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
        }
Пример #4
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string CompanyCode)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from T_Company");
            strSql.Append(" where CompanyCode=@CompanyCode ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 255)
            };
            parameters[0].Value = CompanyCode;

            return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
        }
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int Partsid)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from T_EquipmentParts");
            strSql.Append(" where Partsid=@Partsid ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Partsid", SqlDbType.Int, 4)
            };
            parameters[0].Value = Partsid;

            return(DbBaseHelperSQL.Exists(strSql.ToString(), parameters));
        }