示例#1
0
        /// <summary>
        /// 根据条件删除
        /// </summary>
        /// <param name="keys">键值集合</param>
        public virtual bool Delete(PropertyParamGroup paramGroup)
        {
            List <SqlParameter> pars = paramGroup.GetParams();
            string sql = string.Format("DELETE FROM [{0}] WHERE {1}", EntitySet.GetType().Name, paramGroup.ToString());

            SqlParameter[] paras = pars == null ? null : pars.ToArray();
            return(Entities.Database.ExecuteSqlCommand(sql, paras) > 0);
        }
示例#2
0
        /// <summary>
        /// 根据属性键值对查询对象集合
        /// </summary>
        /// <param name="paramGroup">属性键值对</param>
        /// <returns></returns>
        public virtual List <TEntity> Get(PropertyParamGroup paramGroup)
        {
            List <SqlParameter> paras = paramGroup.GetParams();

            SqlParameter[] pars = paras == null ? new SqlParameter[0] : paras.ToArray();
            string         sql  = string.Format("SELECT * FROM [{0}] WHERE {1}", EntitySet.GetType().Name, paramGroup.ToString());

            return(Entities.Database.SqlQuery <TEntity>(sql, pars).ToList());
        }