Esempi in C# (CSharp) per FMS_DbHelperMySQL.Exists

Esempio n. 1

File: fms_ac_period.cs Progetto: zhangvs/XMH_CRMBSmysql_new

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from fms_ac_period");
            strSql.Append(" where Id=@Id ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id", MySqlDbType.Int32, 11)
            };
            parameters[0].Value = Id;

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

Esempio n. 2

File: fms_costitem_dep.cs Progetto: zhangvs/XMH_CRMBSmysql_new

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from fms_costitem_dep");
            strSql.Append(" where id=@id ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@id", MySqlDbType.Int32, 11)
            };
            parameters[0].Value = id;

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