Beispiel #1
0
        /// <summary>
        /// 取得更新数据的数据库命令
        /// </summary>
        /// <param name="item">实体数据</param>
        /// <returns></returns>
        protected override DapperCommand CreateUpdateCommand(Entity.RoleModule item)
        {
            string sql = $"UPDATE {TableName} SET WHERE RoleId=@RoleId And ModuleId=@ModuleId";

            return(new DapperCommand()
            {
                CommandText = sql,
                Parameters = item
            });
        }
Beispiel #2
0
        /// <summary>
        /// 取得插入数据的数据库命令
        /// </summary>
        /// <param name="item">实体数据</param>
        /// <returns></returns>
        protected override DapperCommand CreateInsertCommand(Entity.RoleModule item)
        {
            string sql = $"INSERT INTO {TableName} (RoleId,ModuleId) VALUES (@RoleId,@ModuleId)";

            return(new DapperCommand()
            {
                CommandText = sql,
                Parameters = item
            });
        }
Beispiel #3
0
        /// <summary>
        /// 取得删除数据的数据库命令
        /// </summary>
        /// <param name="item">实体实例</param>
        /// <returns></returns>
        protected override DapperCommand CreateDeleteCommand(Entity.RoleModule item)
        {
            string            sql = $"DELETE FROM {TableName} WHERE RoleId=@RoleId And ModuleId=@ModuleId";
            DynamicParameters dynamicParameters = new DynamicParameters();

            dynamicParameters.Add("RoleId", item.RoleId);
            dynamicParameters.Add("ModuleId", item.ModuleId);
            return(new DapperCommand()
            {
                CommandText = sql,
                Parameters = dynamicParameters
            });
        }